udate query running on form close

G

Greg Clements

i have an update query i want to run when i close a form,
i want to know if there is a way to bypass the 2 pop up
screens that ask question about running the query, i was
going to try the sendkeys command running in the form
before closing it but the pop ups still occur, i know
this has to be something simple, I am just missing it,
any help would be great!.
 
J

Jason

You know... I've tried this before too, and I don't remeber whether or not I was very successful at the attempt. If you haven't tried this

Stored Procedure.
 
P

PC Datasheet

Greg,

Modify your code to this:

DoCmd.SetWarnings False
DoCmd.OpenQuery "NameOfYourUpDateQuery"
DoCmd.SetWarnings True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Office 2000 now pops up EULA window & closes doc after acceptance 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Pop up window?? 5
Running an Update query before closing a form 2
Pass information from form to QUERY CRITERIA 1
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
trying to close a form 1

Top