Calendar Help

  • Thread starter Thread starter denelson
  • Start date Start date
D

denelson

I have a Form... I want to have two unbounded text boxes... One is
called Beginning Date and the other Ending Date. What I want to do is
when the user clicks the 1st text box a calander will pop up allowing
the user to click on a date which will then close the calendar and put
the date in the text box. The same for the 2nd text box. Now with that
all done, I have a submit button below it all which will run a query
using the dates in the beginning and ending text boxes as the
parameters for the query... I can do all this without the pretty form
by doing a simple parameter query, but now i want to take it to the
next level. Thanks.
 
Hi,
for the calendar part there are many options. You can use a build in active
x control, or avoid that and do a custom form solution.
Check this for a good tutorial:
http://www.fontstuff.com/access/acctut09.htm
Then to reference you start date end date controls in the query criteria you
would use:

BETWEEN [Forms]![YourForm]![StartDateControl] AND
[Forms]![YourForm]![EndDateControl]

The form has to be open when the query runs so the values can be pulled
correctly.
HTH
Good luck
 
Back
Top