D devolved_one New member Local time Today, 22:41 Joined Mar 21, 2000 Messages 8 Mar 29, 2000 #1 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.
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.
M mikec Registered User. Local time Today, 22:41 Joined Dec 17, 1999 Messages 22 Mar 29, 2000 #2 Simply turn the warnings off before the query code and then turn them back on after: DoCmd.SetWarnings False Query Code DoCmd.SetWarnings True
Simply turn the warnings off before the query code and then turn them back on after: DoCmd.SetWarnings False Query Code DoCmd.SetWarnings True
I iommi New member Local time Today, 22:41 Joined Mar 10, 2000 Messages 6 Mar 30, 2000 #3 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.
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.