Pass criteria in Microsoft Query

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a macro I wrote that executes 4 queries to an ODBC Database.
Each query runs on different table in the database but uses the same
search criteria. How can I pass the saved variables to the 4 queries
so the user doesn't have to enter them 4 times.

Thanks for the help
.

Relevant Pages

  • Re: Bandwidth Monitor
    ... I'd probably setup IIS to log to a ODBC database (like SQL Server) and then ... run queries on that to find the bytes used by directory. ... Michael ...
    (microsoft.public.dotnet.framework.aspnet)
  • Putting a Delete Query on a Form button
    ... I want to create a button that executes a Delete query, ... but Access won't even show my delete queries in the ... dropdown box. ...
    (microsoft.public.access.forms)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)