Supress Info box when running Queries 1

[geaker]

I have a form that the user selects the report/query/form they want. If the button kicks off a query is there a way to supress the 'The table will be delteted......', You are about to paste.......', or other message the user must respond to. I have tried sendkeys without much luck.

Thanks,
Gerald

 

[scriverb]

Use this:
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryYourQuery"
DoCmd.SetWarnings True

Should do it for you. Bob Scriver

 

[geaker]

Bob,
Worked great.

Thanks