Turn confirmation on and off

[medic133]

Within my db, I run a delete query. Access prompts the user twice for confirmation before deleting the records. I want to turn this confirmation off shortly after the db opens and then turn it back on before the db closes. I know I can do that on individual computers through Tools/Options/Edit/Confirmation on the menu bar, but my db will be used by more than one computer. Is there any way of doing this in code? I've looked under the many options with the RunCommand function, but I don't see anything that looks like its what I want. Please include any code I might need if the solution involves the RunCommand because I've never used that function before. If it matters, I don't know if you would call it a server or mainframe or what that the database may finally reside on. Thanks in advance!!

 

[dazzer123]

DoCmd.SetWarnings = False
Or you can create a macro that will do the same thing

 

[Zukkster]

Remember to

DoCmd.SetWarnings = True

after you have run your delete query ... otherwise you never see a warning again until you log off and log back on