How do I set up a macro to run a specific date in many queries?

M

MLC in Miami

I have set up a switchboard in Access that will open a report in view only
mode. The data is generated through various queries, many of which have a
data range. Indtead of having to type in the data range five times (once for
each different query) I would like to only enter it once and have a macro in
place to let all queries "know" the date range. How do I create the macro and
put it into the switchboard?
 
C

Chris Reveille

Add to unbound date fields to your form. FormDate and
ToDate. In your queries for the date criteria put
between [forms]![nameofform]![FromDate] and
[forms]![nameofform]![ToDate]

Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Need Help with a VBA subroutine 0
Finding the proper style field and the numbered paragraph value within the style 0
Finding the right style field in VBA 0
Can I run a macro in a stored database from an open database? 1
How do I clear a form? 0
Macro to Format Multiple Sheets based on "Master" Format 0
query to show where no data in a stated column 0

Top