Discussion Locked

Quiet Queries in Access 97?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm creating an application in Access 97, and I've come across something I hadn't done before. I need to create a macro button that will run a make-table query transparently, without showing the user the subsequent dialog boxes to delete the pre-existing table, create the new records, and paste them into the table. Can someone tell me what functions I need to use to disable the warnings in the dialog boxes?

Thanks in advance,

1 reply

by dklippert

In the Macro set the Warnings On argument to no.
In VBA it would be DoCmd.SetWarnings False

This discussion is closed to new replies.