Suppressing Messages?

[J.Windebank]

Hi everyone, I am finally almost finished with my application, and have one last question, I think.

I have one command that runs insert and update queries, but I am wondering if there is some way to turn of the prompts on a project level, not on an individual PC level?

I can't turn it off on a PC level as I still need to keep prompts on for Delete Queries, but really would like to remove it from the Append and Upgrades.

Access 97.

Thanks,

Jordan

 

[Nouba]

Look into your help file under SetWarnings

 

[J.Windebank]

Perfect, thank you.

 

[R. Hicks]

If you would use the "Execute" method to execute your queries ... you would not receive the confimation messages.

You can find informtion on this method in Access help files.

HTH
RDH