Passing values

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have Access 2003. I recently installed SQL Server PE, i
think it's version 8. I have created a database in the
Server and have opened a project and all of my tbles are
available.

For over two weeks I have be trying to get things to work
similar to what my access db did. I've tried function
queries, storedprocedure queries, and views and I cannot
figure out how to pass a value from a form to the query.

Of course the old way was [Forms]![FormName]![FormField].

What I do is, on a form, allow the user to make up to 15
account selections with a dollar threshold. Each account
and dollar amount are selected from their respective combo
box and that combo box value is then moved to a text box.
A query is then run that uses these values, through the
criteria field, to pull the data from an appropriate data
table. Then a report opens showing the user the results
of their search.

After all of this my question is how do I pass these
values to a query using a Project? I cannot seem to get
any of the queries to accept the values from the form.

Any help will be appreciated. I have read help topics
until my eyes have dried up.

Thanks

Ken
.

Relevant Pages

  • 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)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)
  • Re: Cluster synchronize
    ... queries per unit time. ... CPU is the ONLY bottleneck. ... increase in query capacity. ... queries that perform sequential I/O or queries performing random I/O. ...
    (microsoft.public.sqlserver.clustering)