I'm not sure if the prior reply answered your question, though I
suspect you are referring to the updated confirmation message boxes
that are appearing when you run update / append queries.
There are three scenarios you might have. Instructions are based on
the Access 2000 interface an may be slightly different given the
version you are working on
1. If you are just sick of seeing them on your screen when you run
an update query manually do the following:
a. Locate "Tools" on the menu bar"
b. Select Tools -> Options from the dropdown menus
c. Select the Edit/Find tab on the dialogue box that appears
d. Clear the "Confirm Action Queries" check box
This is a workstation/login, not database specific setting
2. If you are running the queries via VBA code:
a. Use the "DoCmd.SetWarnings False" syntax before the code executes
the query (this turns off all message boxes) and use the
syntax "DoCmd.SetWarnings True" (this returns the database to
normally reporting messages)
3. If you are running the queries via a Macro:
a. Insert an action (from the dropdown list) called "SetWarnings"
before the query is executed in the macro's list of events. The
default argument in the lower half of the macro window is "No" which
turns off all message boxes. Then set another action after the
queries are run in the macro for "SetWarnings" and have this
action's argument be "Yes" to return the database to reporting
messages.
It is important to note that "SetWarnings" usually disables error
reporting so you will need to make sure your code executes properly
prior to using it or you will miss your error messages.
Good luck!
--- In AccessDevelopers@yahoogroups.com, "bitschon" <[EMAIL PROTECTED]>
wrote:
> I want to turn off all screen status bar updates while I am doing
> inserts into a table. How can I do it?
>
> Thanks,
> John
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
