Queries..

devolved_one

New member
Local time
Today, 22:41
Joined
Mar 21, 2000
Messages
8
Is it possible to run a Delete Query from VBA with out it prompting the user to delete the data in the table you are deleting from!?

Thanks.
 
Simply turn the warnings off before the query code and then turn them back on after:

DoCmd.SetWarnings False
Query Code
DoCmd.SetWarnings True
 
You can also run a dbengine(0)(0).execute("DELETE blabla FROM blabla WHERE etc") etc etc.

This will just delete the record(s) in the recordset in your sql statement above. It does not prompt the user.
 

Users who are viewing this thread

Back
Top Bottom