Not show update/delete/insert popup

[ukemike]

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]

Try -

[VBA]'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"[/VBA]

[geekgirlau]

The usual method is something like the following:

[VBA]
Application.SetWarnings False
Docmd.RunSQL x
Application.SetWarnings True
[/VBA]