calendar

ianatkins

Registered User.
Local time
Today, 21:01
Joined
Oct 25, 2002
Messages
16
Hello,

Ive got a problem with an active x calendar. (running access 97)

I want a query to run with the criteria of the value of the calendar, which is in a form.

Ive tried the following criteria on the date field:
[forms]![calender]![ActiveXCtl10.value]

and
[forms]![calender]![ActiveXCtl10]

Is this the right idea or is there something else I need to do?

Any help would be great!

thanks again
ian.
 
If that is not working try making a text box on the form that is the value of the calendar. When you press the date on the calendar have the text box automatically populated with the calendar value and have that textbox visible property set to no.

From there use the text box as the criteria in your query field.
 
Have you renamed the activeXcontrol to another name ?
Not that this is a problem, but I need to ask.
When you right click on the calendar and select properties check the name - say call it MyCalendar for example. Then it is simply a case of referencing the control like any other

in the query criteria you need

[Forms]![CalendarFrm]![SelectedDate] (Cut from my DB)

where the CalendarFrm is the name of my form and SelectedDate is the name of the calendar.

Also another way to easily get the correct reference is to open your calender form in normal mode (not design)
Then open your query in design mode and right click in the criteria of the field you want to query and select build.
This will open a window and you can select - forms - all open forms - your calendar form - calendar name. When you select this, the stuff is automatically put into the query criteria in the correct context.

Dave
 

Users who are viewing this thread

Back
Top Bottom