Take out prompting in append query in VB 1

[pronate]

Hi,

I am trying to use the Docmd.RunSql method to run a append query.

But everytime Access will prompt me for confirmation. Is there a way to do away with the confirmation dialog box? The same goes for make table query and update query.

Cheers and thanks!
Sam

 

[BillPower]

Use the Setwarnings Method to tell Access not to warn the user that an action query is about to be run.

Docmd.Setwarnings False ' Turn warnings off
Docmd.RunSql ' Run the action query
Docmd.Setwarnings True ' Turn warnings on again

 

[Darrylles]

Hi Bill,

I clocked this as helpful - standard, useful and regular, but I forgot about setwarnings.

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." AND "A pointer to a solution is better than the solution - you'll remember the solution via a pointer". darrylles@totalise.co.uk