Update Query!
in [General]
|
From: John W. Vinson on 10 Mar 2010 00:36 On Wed, 10 Mar 2010 17:20:37 +1300, "Bob Vance" <rjvance(a)ihug.co.nz> wrote: >Well actually I have 25 tables and want to delete the contents of 20 of them >to form a empty database that my friends can use without my data in it, so i >should still look at cascade delete...Thanks bob There's an easier way! Create a new empty database, and use File... Get External Data... Import to import all 25 tables. For the ones you want empty, check the box "design view only"; for the rest, check "structure and data". -- John W. Vinson [MVP]
From: De Jager on 13 Mar 2010 12:33 "Bob Vance" <rjvance(a)ihug.co.nz> wrote in message news:OMFu8n9vKHA.404(a)TK2MSFTNGP02.phx.gbl... > > Can I have an UpDate query to delete all content of all fields in > tblHorses > tblOwners > tblInvoices > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home Edition Ver 5.1 Service Pack 3 > >
From: joelgeraldine on 17 Mar 2010 09:09 yj;:!� "Bob Vance" <rjvance(a)ihug.co.nz> a �crit dans le message de groupe de discussion : OMFu8n9vKHA.404(a)TK2MSFTNGP02.phx.gbl... > > Can I have an UpDate query to delete all content of all fields in > tblHorses > tblOwners > tblInvoices > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home Edition Ver 5.1 Service Pack 3 > >
From: joelgeraldine on 17 Mar 2010 09:19
ykkklmmmm�����** "Bob Vance" <rjvance(a)ihug.co.nz> a �crit dans le message de groupe de discussion : OMFu8n9vKHA.404(a)TK2MSFTNGP02.phx.gbl... > > Can I have an UpDate query to delete all content of all fields in > tblHorses > tblOwners > tblInvoices > -- > Thanks in advance for any help with this......Bob > MS Access 2007 accdb > Windows XP Home Edition Ver 5.1 Service Pack 3 > > |