active query messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a runtime access application is there a way to globally turn off active
query messages appearing to the end users or do they need to be turned off
individually.
 
Kerryn said:
In a runtime access application is there a way to globally turn off active
query messages appearing to the end users or do they need to be turned off
individually.
Click to expand...

I'd be leery of that. I suppose you could include
Application.SetWarnings False

in your startup code, but I don't think I'd ever use it.
 
In a runtime access application is there a way to globally turn off active
query messages appearing to the end users or do they need to be turned off
individually.
Click to expand...

It's best to leave warning messages on in general; if you're executing
the action queries from a Macro or from code, you can put a line
Setwarnings False before the query, and be sure to put Setwarnings
True after it.

Or, you can use VBA code to run your queries; create a Querydef object
and use its Execute method:

Dim db As DAO.Database
Dim qd As DAO.Querydef
Dim prm As Parameter
Set db = CurrentDb
Set qd = db.Querydefs("MyActionQuery")
For Each prm In qd.Parameters
prm.Value = Eval(prm.Name)
Next prm
qd.Execute, dbFailOnError
Set qd = Nothing

John W. Vinson[MVP]
 
Back
Top