see all in a combo box
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
I have a form where the user can select a Product from a combo box, a site
from another combo box, then they have to enter a beginning and ending date
in two other fields. This form passes the data to a query then produces the
records asked for. Everything works great. The user now wants the ability to
select all products at a specfic site or a specific product at all sites
within the dates given. Is there an easy way to do this or do I have to write
code? If so what. I was hoping they could just leave the field blank that
they want all values. Any help would be greatly appreciated.
.
Relevant Pages
- Search a table by unsing a form
... My clients want the ability ... It is kind of like an and/or type of query but they need to be able to ... Prev by Date: ...
(microsoft.public.access.forms) - Query to search entire record, not one field?
... My clients want the ability ... It is kind of like an and/or type of query but they need to be able to ... Prev by Date: ...
(microsoft.public.access.queries) - Restricting Record Add
... When I put code in the form to limit the ability to add records I am using ... I would much preferably do the limit coding within the query rather ... than the form if anyone has suggestins on how I could do that. ... Prev by Date: ...
(microsoft.public.access.modulesdaovba) - Re: Identifying fields out of order
... Click on "Create Query in Design View" ... tblSeq AS Prev, tblSeq AS Next; ... Our SQL now would look like: ...
(microsoft.public.access.queries) - RE: how to change a query to use a different table through code
... I've never had to work with a terminal server and don't know ... front end that is universal for each user, and the ability to base a query ... little bit quicker than running a dynamic sql string. ...
(microsoft.public.access.modulesdaovba) |
|
