Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Remove the Popup Message box when running Action Queries

How to

How to Remove the Popup Message box when running Action Queries

by  mgolla  Posted    (Edited  )
I have seen this same question asked many times. How can I get rid of that annoying Popup box that tells me I am inserting records into the table.

There are two ways to do this.

The first is thru VBA. To turn off the message box put the following code before you run the SQL statement.
[color blue]
DoCmd.SetWarnings False[/color]

After the SQL statement put this code:[color blue]

DoCmd.SetWarnings True[/color]

That will eliminate the annoying popup box everytime.

The second is thru the access options.

Goto [color red]Tools[/color]->[color red]Options
[/color]

Then click on the [color red]Edit/Find[/color] tab and where it says [color red]Confirm[/color] uncheck the check boxes.

That should take care of removing those annoying pop up boxes

Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top