467,858 Members | 1,637 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,858 developers. It's quick & easy.

How to run queries on a subset of records in a table?

I have inherited a complex database that has many dozens of queries that derive data from a people
table.

I now need to be able to run these queries (from within a significant number of forms) not on the
full dataset, but on a subset of the data in the people table.

I want to avoid having to put criteria in all of the individual queries or forms, or having to
change the data source for all the queries.

Is there anyway I can restrict the recordset without having to modify all the queries individually?
Nov 12 '05 #1
  • viewed: 2015
Share:
1 Reply
Consider a query by form (QBF). The QBF is a form in which you can enter
multiple variable parameters that are sent to your queries when the queries
are activated. The QBF is an unbound form with unbound text boxes on it
that are used to supply parameters to the queries. Multiple queries can be
fed off this form. The queries refer to the unbound controls/text boxes on
the QBF by there names so that when you fill the text boxes and activate the
queries, then the queries are filtered by whatever was placed in the text
box(es). In the criteria rows of your queries, you would place expressions
similar to this: [Forms]![frmNameOfUnboundForm]![txtNameOfUnboundTextBox]

Denny G


"Roger Green" <rc*****@mun.caNOJUNK> wrote in message
news:bj**********@coranto.ucs.mun.ca...
I have inherited a complex database that has many dozens of queries that derive data from a people table.

I now need to be able to run these queries (from within a significant number of forms) not on the full dataset, but on a subset of the data in the people table.

I want to avoid having to put criteria in all of the individual queries or forms, or having to change the data source for all the queries.

Is there anyway I can restrict the recordset without having to modify all the queries individually?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Dom Boyce | last post: by
3 posts views Thread by Stephen | last post: by
3 posts views Thread by Kenneth | last post: by
2 posts views Thread by zwasdl | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.