PDA

View Full Version : Stop user prompt



EricM
06-14-2006, 06:08 AM
I have a switchboard that when you click the first option it will run a macro. The macro prompts a user for a begin and end date. It then takes this critera and creates a new (temp) table. When the macro is ran A window pops up asking if you want to delete the existing (temp) table after selecting yes it will then popup saying you are about to paste X number of rows into new table.
How do I get it to not show these prompts and always answer Yes?

mdmackillop
06-14-2006, 11:53 AM
From help

The following example turns the display of system messages off:
DoCmd.SetWarnings False