Discussion Locked

Access Update/append pop up

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I've created a Database with mutiple queries which populate tables within the database, I would like to suspend the pop up windowsgenerated by Access, basicaly "appending X records to Mdb" which are basicaly interupting the run of things. Any ideas????

6 replies

by grybyx

If you are the only user, then in the Tools menu, choose Options. Then, under the Edit/Find tab, uncheck any of the check boxes in the Confirm group that apply. For example, to stop the harassing "appending X records to Mdb" pop-ups, uncheck the Action Queries check box, which disables messages anytime you run an action query, of course.

If other users are or will be accessing the database, use the SetOption method in Visual Basic. This method can do a lot, so search for "SetOption" in Help,and read more there.

by grybyx

There is also the DoCmd.SetWarnings method, but be warned: After issuing DoCmd.SetWarnings(False), Access stops issuing warnings altogether, including critical warnings, even when you would actually like to see them. You'll need to issue DoCmd.SetWarnings(True) at the end of your code to allow Access to resume issuing warnings in other areas of your application.

by seagull data services

If you're doing it in code use

docmd.setwarnings [True=allow warnings|False=no warnings]

You should also include the line

docmd.setwarnings false

in your error handler, just in case. 8o)
Hope this helps

This discussion is closed to new replies.