Using ActiveX Calendar to pupulate dates

  • Thread starter Thread starter MARK
  • Start date Start date
M

MARK

I have a simple query that uses the Between [Start Date] and [End Date]
criteria. I have been asked by the users to incorporate a calendar.

I tried this without success. Can anyone help?

Between [forms]![CheckHoursName].[CmdCalendar1] And
[forms]![CheckHoursName].[CmdCalendar2]

With CmdCalendar1 being the first calendar on the form and CmdCalendar
2 being the 2nd calendar on the form. The form already populates a
parameter for employee name.

Any help is greatly appreciated!

Mark
 
Ok, this is what I figured out for myself, I don't know if it's a dumb way to
do it, but it worked for me.
I made a new form called "Dates".
I put two Active X Calendar Controls on the form.
I put a command button underneath.
I chose Miscellaneous: Run query
I chose the Query I'm trying to do this for.

In the Query I 'm working with under Date Criteria I wrote this:
Between [Forms]![Dates]![Calendar0] And [Forms]![Dates]![Calendar1]

Save everything.

Try it.

It seemed to work for me!
I don't know if I'm missing something and my program will go crazy, but it
seems to work so far.
 

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

Date Range 1
Parameter dates 1
Calendar Query Changes Problem!!!! 1
< and > for Date Search 7
Parameter Query Using Calendar Control 4
date time range criteria 2
use calendar control in unbound form 2
Query criteria: reformat date from Calendar Control to yyyy/mm/dd 1

Back
Top