Append & delete queries

[jmar93]

Hi,

I am developing a access 2007 database that as an append query and a delete query. When they run they prompt you to answer "yes" that you want to update or delete the records. Is there a way to set it up to update without prompting and requiring a response?

thanks,
Jeff

[JConsulting]

Hi,

I am developing a access 2007 database that as an append query and a delete query. When they run they prompt you to answer "yes" that you want to update or delete the records. Is there a way to set it up to update without prompting and requiring a response?

thanks,
Jeff

you can set warnings to false before you run them, then back to true when they are done....but how are you running them now?

Currentdb.Execu te "YourQuery" will do the same without having to deal with warnings, but again, that requires an interface and a click on a button or some other event to launch them.

J

[jmar93]

Thanks, I think this has solved my problem.

thanks again,
Jeff