Thread: Macro - Prompts
10-19-07, 09:31 #1Registered User
- Join Date
- Oct 2007
Unanswered: Macro - Prompts
I have created a single Macro which contains a number of RunMacro’s that run 6 individual macro’s….
Hope it make sense so far!!! A single Macro, running 6 separate macros.
Each Macro runs a query, but each query requires a date… the user is prompted to enter a date (Between [start date] And [end date]).
I want to enter the date once and leave my machine to process the work; otherwise I have to be waiting by the machine, for it to prompt me every time.
If I create a date table and enter the Start and End Date… how do I link that into the queries so it doesn’t need to be entered every time?
10-19-07, 10:33 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
One way I often do it is I'll have a form with a "StartDate" and "EndDate" field on the form and then in the query(s) I'll put criteria in for the date field: Between Forms!DateForm!StartDate and Forms!DateForm!EndDate.
Here's an example: http://www.dbforums.com/showpost.php...2&postcount=36Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)