SQL causing message box for each operation

gellerche

Registered User.
Local time
Today, 06:04
Joined
Jun 19, 2001
Messages
73
I'm using SQL for DELETE, INSERT, and UPDATE in my database from a button in my form. The SQL works fine. The problem is that every time I delete, insert, or update a row, a message box pops up asking "You are about to <name of operation> <number of rows affected> rows. Are you sure you want to do this?" This happens EVERY TIME the SQL is executed. Is there a way to run SQL WITHOUT the message box coming up?

Thank you
 
Go into your main tools and click Options. Then go into Edit/Find and unclick all options in the Confirm Box.
 
Carol:

Thank you so much! I was tearing my hair out trying to get something so irritating out of my program. It's now runs much smoother.

Steve
 
You can also use DoCmd.SetWarnings False (turns off the warning message) and DoCmd.SetWarning True. This will allow you to turn them off more selectively
Chris
 
Chris:

Thank you as well. I'll have to consider which method works best for the client I'm working for.

Steve
 

Users who are viewing this thread

Back
Top Bottom