DoCmd RunSQL (Action Query as a form opens)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if there was a way to make it so the software does not show
the default user input bx saying "hey man you are about to delete 532
records, is that ok?" as my form opens and executes an action query that I
have tied to that event. It is updating a temporary table so I want it to
happen no matter what. I am sure that if I do not fix this it is going to
make my users do a double take and I will get a telephone call...

Thanks for your help!!
 
Use the setwarnings to false

Docmd.setwarnings False
.....runsql
Docmd.setwarnings True

' Dont forget to set it back to true
 
You must log in or register to reply here.

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

DoCmd RunSQL issue 4
Cannot open a form using "Docmd Openform" 1
Opening form unexpectedly closes other form 0
DoCMD maximize 3
Confirm action query runtime option 1
DoCmd OpenForm? 3
query not working on form action 3
Populate a form based on a query using parameters 8

Back
Top