PDA

View Full Version : Not show update/delete/insert popup



ukemike
03-25-2005, 09:10 AM
Hi,
I have a question.
I have a loop that is running and inserting columns from one table into another. Im using DoCmd.RunSQL(). The only problem is that everytime a record is about to be inserted a pop comes up saying something on the lines of "A record is about to be updated. do you wish to continue". Is there anyway i can hide this? Or is there any other function i can use other then DoCmd.RunSQL() so this does now show up?

Thank you
Mike

Groundhog
03-25-2005, 02:30 PM
Try -

'This command switches off ALL warning messages, NOT only Action Queries
'And insert the following line following the DoCmd.RunSQL MySQL command:

Application.SetWarnings False

'If you wish to eliminate ONLY the Action Queries confirmation from your code

Application.SetOptions "Confirm Action Queries"

geekgirlau
03-29-2005, 08:00 PM
The usual method is something like the following:


Application.SetWarnings False
Docmd.RunSQL x
Application.SetWarnings True