Passthrough query: how to avoid warning

Question

When I launch a pass-through, I get a dialog box that says:

"You are about to run a pass-through query that may modify data in your table..."

Supposedly, I can hit HELP to find out how to disable this message, but hitting HELP just brings me to the generic Office help front page, and I can not find any keywords to discover the secret.

Answer 1

On Wed, 22 Sep 2010 18:16:50 +0000, Phil Smith at NHS wrote:

>

>In this case, this is about manually launching the query.  No forms, no code, just doule clicking on the query form the list.

You can use DoCmd.SetWarnings False in a little VBA procedure or just

type it into the Immediate Window (Ctrl-G).  This turns off warnings

in all of Access for this session - remember to turn it back on when

you're done.

Armen Stein

Microsoft Access MVP

www.JStreetTech.com

Answer 2

In this case, this is about manually launching the query.  No forms, no code, just doule clicking on the query form the list.

Answer 3

As noted in the other thread, the Execute method may be better for what you want - it doesn't prompt:

CurrentDb.Execute "MyQueryName", dbFailOnError

---

John W. Vinson/MVP