DoCmd.RunSQL generates warning screen 2

[Soundsmith]

I'm generating a series of SQL UPDATE commands to locate records. The commands take the form of:
DoCmd.RunSQL "UPDATE qryPikNames SET ok = True"

Each time the command runs I get a MsgBox:
"You are about to update nnnn rows" and an "Are you sure" selection.

How can I avoid these? I need to simply run the SQL commands with no questions asked.
Also, it takes a relatively long time to run the command against 2600 records. Any ideas for speeding it up?

Thanks.


David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com

 

[Psychpt]

you could set warnings to false before the docmd
and restore it to true after, but I suspect there is an easier way especially if you're not satisfied with the performance now.

what are you trying to do?

 

[jimmythegeek]

Either of these methods will work:

Dim db as Database
Set db = Currentdb
db.Execute "UPDATE qryPikNames SET ok = True"
db.Close

OR

Docmd.SetWarnings False
DoCmd.RunSQL "UPDATE qryPikNames SET ok = True"
Docmd.SetWarnings True
Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[Soundsmith]

Thanks to both of you. As it turns out, all i needed to do was set the Confirm flag off in Tool/Options, but SetWarnings was the approach I was looking for and didn't find. I'll probably try the db.Execute in another selection, to see how much difference there is between them.
Also, I simplified my follow-on UPDATE queries and it made a significant difference. The time was apparently taken there, not in the initial UPDATEs. Again, I appreciate the help. David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com

 

[jimmythegeek]

Remember that if you set the Set Warnings off in the options, then NO warnings will be used. If you want to use the RunSQL method, I would suggest setting the warnings to off (false) ONLY when you need to, them turn them back on. Jim Lunde
compugeeks@hotmail.com
Custom Application Development