Stop showing Append message???

  • Thread starter Thread starter nybaseball22
  • Start date Start date
N

nybaseball22

Hello. Thank you inadvance for the help.

I have a macro that runs when I open my database that automatically
runs an append query and opens a form. I just got a new computer and
put my database on it. Now when I open the database, I get this popup
message before the form will open or query will run:

"You are about to run an append query that will modify data in your
table."

Is there a way to prevent this from occuring. I think it happened
last time I got a new computer and I had to change a setting in
access, but I dont remember how to do it.

Thanks again.
 
You can use SetWarnings in your macro, or turn off the confirmation under
Tools | Options, but a much better idea is to use Execute in code rather
than RunSQL or OpenQuery.

Details in:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html
 
You can use SetWarnings in your macro, or turn off the confirmation under
Tools | Options, but a much better idea is to use Execute in code rather
than RunSQL or OpenQuery.

Details in:
    Action queries: suppressing dialogs, while knowing results
at:
   http://allenbrowne.com/ser-60.html

--
Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.










- Show quoted text -
Click to expand...

Thank you all for the tips.
 
Back
Top