Change query parameter with vbscript

[juneau730]

I've searched the wonderful world of Google for a simple answer and wasn't able to find one.

Is there a simple way to have a standalone (manually executed) vbscript to change an Access query parameters?

I have the same parameter in three queries, which is Like"XXX"

I need to replace the XXX with a manually input three letter code

 

[Joe4]

OK, here is what you do.

In our one record "Settings" table, we will have a location specific field (let's call it "Site_Code") where we enter the values, like "PHO" for your example.
Then, add this table in to your query where you are pulling all the information, but do NOT create a join between this Settings table and the main data table.
Then, in the criteria row under the "NT Name" field, we would enter:

Like "*" & [Settings]![Site_Code] & "*"

and that should filter the the records the way you want.

So all each location would need to do is to set the "Site Code" field value on the Main Form, and it should propagate to the queries and do what you want.
Like I said, I often use the "Settings" table as the source of my Startup Form, so it is easily accessible/seen.

 

[juneau730]

That works! Thanks so much Joe4!

 

[Joe4]

You are welcome!

 

[stumac]

I would recommend using more than the 3 letter site code if possible:

Imagine you get a new use John Phelps working in the PHO site - they would then appear in both the ELP and the PHO query.If the VHA is always there then include that.