Delete codes

J

Justin

Hi,
I have a question. How can i merge these codes:

CurrentDb.Execute "DELETE * FROM Table 1"
CurrentDb.Execute "DELETE * FROM Table 2"
CurrentDb.Execute "DELETE * FROM Table 3"
 
P

pietlinden

Hi,
I have a question. How can i merge these codes:

CurrentDb.Execute "DELETE * FROM Table 1"
CurrentDb.Execute "DELETE * FROM Table 2"
CurrentDb.Execute "DELETE * FROM Table 3"
Click to expand...

You can't. You're deleting records from 3 different tables. Where
did you get the notion that you could?
 
J

Justin

In the SQL, you can make it:

Delete Table1.*,Table2.*,Table3.* From Table1, Table2, Table3

So I thought maybe i can make this operation in VBA too. But not. Thanks
anyway.

Sorry for English...
 
P

pietlinden

In the SQL, you can make it:

Delete Table1.*,Table2.*,Table3.* From Table1, Table2, Table3

So I thought maybe i can make this operation in VBA too. But not. Thanks
anyway.

Sorry for English...
Click to expand...

make a dummy database and try it. never heard of doing it like that.
I'd rather have multiple statements that I can understand/modify
easily... doesn't mean what you're trying can't be done.
 
Top