Pop up window for users

[Guest]

Hi,
I have a query where i'm asking the users to enter dates (BETWEEN ##/##/###
AND ##/##/####) and they get associated/related records to appear. I'm trying
usuccessfully to do this one thing that i have done in the past and can't
seem to remember.
1) Simply have the queryied date field automatically pop up with custom test
of what to enter and the format to enter it in. There was a character, i
thought was a %, that you can wrap around your query criteria to have this
happen. I prefer this so the user stays out of the query design window and
doesn't screw up the query.
ANY HELP IS MUCH APPRECIATED. Thanks in advance.

 

[Guest]

You can try this:

strPrompt = "Start Report ##/##/####"
dtStartReportDate = CDate(InputBox(Prompt:=strPrompt, Title:="Report
Date"))
strPrompt = "End Report ##/##/####"
dtEndReportDate = CDate(InputBox(Prompt:=strPrompt, Title:="Report Date"))

Although this gives you two boxes to fill in.

John H W

 

[Guest]

You can add this to the criteria of your query.

Between [Start date] And [End Date]

The [] is the popup message you will presented with

Mark Garner