Disabling Action Queries Confirmation

[homeguard]

Hi, i have a line of code that goes something like "DoCmd.RunSQL "INSERT INTO tblEvent..."

Does anyone know how to make it automatically disable the confirmation? i dont want to go around and change the settings on everyones computer everytime they use this database for the first time.

 

[HarleyQuinn]

Look at DoCmd.SetWarnings False

I'd turn it back on after using DoCmd.SetWarnings True

Hope this helps

HarleyQuinn
---------------------------------
If you never say your name out loud to anyone they can never ever call you by it - Regina Spektor

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[homeguard]

perfect thank you sir.

 

[HarleyQuinn]

You're welcome, glad I could help

HarleyQuinn
---------------------------------
If you never say your name out loud to anyone they can never ever call you by it - Regina Spektor

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[TheAceMan1]

homeguard . . .

To permanently turn off action query confirmation:

Tools - Options - Edit/Find Tab - Confirm Section - remove check from [blue]Action Queries[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997