Removal of Confirmation Messages

[ElliotCLIC]

In Access 2003 i have a problem where i do not want to display any confirmaion messages. i have unticked everything in tools, options, edit / find. When i create a table that has to overwrite an existing table i still get a confirm table deletion message.

how do i prevent this appearing?????

 

[SuicidED]

Hi
DoCmd.SetWarnings False

then switch it back on again

DoCmd.SetWarnings True

 

[jebry]

Hi!

If you are doing this in code then you can do this:

DoCmd.SetWarnings = False
Your Code Here
DoCmd.SetWarnings = True

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[Remou]

I guess you unticked everything under Tools->Options, Edit/Find tab, heading Confirm?