By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Surpress dialogbox?

P: n/a
Hi!

How to avoid the confirmation dialog in:

DoCmd.RunSQL "INSERT INTO....etc",false

Me.Name
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Geir Baardsen wrote:
Hi!

How to avoid the confirmation dialog in:

DoCmd.RunSQL "INSERT INTO....etc",false

Me.Name


DoCmd.Setwarnings False
DoCmd.RunSQL "..."
DoCmd.Setwarnings True

Make sure you turn it back on, if an error occurs set it back in in the
error trapping otherwise you no longer get confirmations for dleting
records, etc.

or

db.Execute "insert into..."

IIRC there's a Application.SetOption called something like "confirm
action queries" but I haven't tried that one myself so the exact text
and whether or not it works I don't know.

--
This sig left intentionally blank
Nov 13 '05 #2

P: n/a
Trevor Best <no****@besty.org.uk> wrote:
IIRC there's a Application.SetOption called something like "confirm
action queries" but I haven't tried that one myself so the exact text
and whether or not it works I don't know.


Application.SetOption "Confirm Action Queries", False
Application.SetOption "Confirm Action Queries", True

Works for me :o)

Regards,
Keith.
www.keithwilby.com
Nov 13 '05 #3

P: n/a
White Bilky <ke*********@AwayWithYerCrap.com> wrote in message news:<Xn************************@10.15.188.42>...
Trevor Best <no****@besty.org.uk> wrote:
IIRC there's a Application.SetOption called something like "confirm
action queries" but I haven't tried that one myself so the exact text
and whether or not it works I don't know.


Application.SetOption "Confirm Action Queries", False
Application.SetOption "Confirm Action Queries", True

Works for me :o)

Regards,
Keith.
www.keithwilby.com


Works for me too. Thanks!

Me.Name
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.