Eliminating Dialog Boxes When Running SQL from VBA

[oakleaf8]

If I run SQL in a VBA pushbutton from a form to Update, Ammend and/or Delete Records to tables from a pushbutton form, I get dialog boxes I don't want.

I want (with one click), my form data put amended to, updating or deleting appropriate records without having to respond to each of those boxes. Possible?

 

[RoyVidar]

[tt]docmd.setwarnings false
' perform your sql
docmd.setwarnings true[/tt]

Roy-Vidar

 

[TheAceMan1]

How are ya oakleaf8 . . . . .

To [blue]permanently turn off warnings[/blue], in the database window:

[purple]Tools[/purple] - [purple]Options[/purple] - [purple]Edit/Find Tab[/purple]. In the [blue]Confirm section[/blue], remove check from [blue]Action queries[/blue].

See Ya! . . . . . .

 

[oharab]

or the final way:

currentdb.execute "YOUR SQL" ,dbfailonerror

If you don't want an error message to show if the sql fails, get rid of the end bit.

hth

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------
Want to get great answers to your Tek-Tips questions? Have a look at F