Question on SetWarnings False

[AtLarge]

In my DB I have an AutoExec macro that calls a function.

In the function I begin with DoCmd.SetWarnings False but it still runs and shows all the activity. I also added it to the end of the function too but it doesn't help. Why can't I just have it execute and run in the background without the user seeing everything that's going on?

I also added the Beep to signal it finished but I do not get the beep? The sound is turned on as I can play MP3's so I know it's working.

At the end of the function I have the DoCmd.Quit to exit Access and that works fine.

Any suggestions? TIA

 

[Galaxiom]

Disabling warnings just turns off the warnings. You need to turn off the screen repaint.

http://msdn.microsoft.com/en-us/library/aa221212(office.11).aspx

Another idea is to open the objects you are working on in Hidden mode.

 

[AtLarge]

Oops. Thanx for the link too!