Delete codes

[Guest]

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"

 

[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"

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

 

[Guest]

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...

 

[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...

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.