Hiding Message Boxes?

[HowardChr]

I have my program set up so that when a button called "Clear" is clicked, it
clears all Yes/No fields from a seperate table. The problem is that when
that button is clicked, it is coming up with 2 seperate message boxes making
sure that is what they want to do. The first one says: "are you sure you
want to run that query", and the second says "You are about to update 1 row".

Is there a way to code this so those message boxes are either automatically
defaulted to Yes, or to have them run on the background? I dont' think my VP
of IT would appriciate having to click 2 more times on each form.

Current code:

DoCmd.OpenQuery ("clear")

Thanks in advance!

['69 Camaro]

Hi, Howard.

Is there a way to code this so those message boxes are either
automatically
defaulted to Yes, or to have them run on the background?

Yes. Use the Execute method with the dbFailOnError argument to tell you
when failure occurs (and rollback the transaction), but remain silent
otherwise. Example:

CurrentDb().Execute "UPDATE MyTable SET Col1 = False;", dbFailOnError

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.
"HowardChr" <u33744@uwewrote in message news:715734f56a300@uwe...

>I have my program set up so that when a button called "Clear" is clicked,
it
clears all Yes/No fields from a seperate table. The problem is that when
that button is clicked, it is coming up with 2 seperate message boxes
making
sure that is what they want to do. The first one says: "are you sure you
want to run that query", and the second says "You are about to update 1
row".

Is there a way to code this so those message boxes are either
automatically
defaulted to Yes, or to have them run on the background? I dont' think my
VP
of IT would appriciate having to click 2 more times on each form.

Current code:

DoCmd.OpenQuery ("clear")

Thanks in advance!

[UrbanSpaceman]

Use CurrentDb.Execute instead:

CurrentDb.Execute "clear", dbFailOnError

"HowardChr" <u33744@uwewrote in message news:715734f56a300@uwe...

>I have my program set up so that when a button called "Clear" is clicked,
it
clears all Yes/No fields from a seperate table. The problem is that when
that button is clicked, it is coming up with 2 seperate message boxes
making
sure that is what they want to do. The first one says: "are you sure you
want to run that query", and the second says "You are about to update 1
row".

Is there a way to code this so those message boxes are either
automatically
defaulted to Yes, or to have them run on the background? I dont' think my
VP
of IT would appriciate having to click 2 more times on each form.

Current code:

DoCmd.OpenQuery ("clear")

Thanks in advance!

[HowardChr]

Does this go inside my SQL statment, or in the VB code?

UrbanSpaceman wrote:

>Use CurrentDb.Execute instead:

CurrentDb.Execute "clear", dbFailOnError

>>I have my program set up so that when a button called "Clear" is clicked,
it

[quoted text clipped - 16 lines]

>>
Thanks in advance!

[HowardChr]

Sorry.. that did work.. Thanks again!

UrbanSpaceman wrote:

>Use CurrentDb.Execute instead:

CurrentDb.Execute "clear", dbFailOnError

>>I have my program set up so that when a button called "Clear" is clicked,
it

[quoted text clipped - 16 lines]

>>
Thanks in advance!

[rizzyboy]

HowardChr wrote:

Sorry.. that did work.. Thanks again!

UrbanSpaceman wrote:

Use CurrentDb.Execute instead:

CurrentDb.Execute "clear", dbFailOnError

>I have my program set up so that when a button called "Clear" is clicked,
it

[quoted text clipped - 16 lines]

>
Thanks in advance!

You are getting confirmation messages about an action query. You can
turn off the confirmation: Tools>Options>Edit/Find, then uncheck the
Confirm>Action Queries checkbox. I prefer to leave it checked and
turn the confirmation off in code: Just before the action query, use
"Docmd.SetWarnings False" Just after the action query, use
"Docmd.SetWarnings True" .