Calendar In Datasheet subform

[Tom Rector]

Access XP 2002

I have progressed some from my last post. I have a calendar working
in main form, although I can't make it open with current date. I have
tried all the suggestions I can find in this group, none seem to work
with this version.

But I can deal that for a while.

What I am desparate for is a way to show a drop down calendar in a
datasheet view subform.

Main table = DATES
fields( ctrlnumb, subject, dateopen, dateclose, orig, opr,
duedate)

Minor Table= ACTIVITIES
fields (ctrlnumb, office, datein, dateout, finish, action)

Main Form =DATES (form view /with a calendar control
working=dateopen)

Subform =Activities Subform datasheet view

Linking field(s) are "ctrlnumb" (has nothing to do with dates, do
not want to link or compare based on dates.)

I need "Datein" and "Dateout" fields in subform to use a drop
down calendar in the "datasheet" view, that will post a date to the
field(s). I have made both fields "combo" type,I have tried to insert
a Calendar Control 10.0, but can't make it work on datasheet.
I don't think calendar control under View/Insert/Active X/Calendar
Contol 10.0 will work with the datasheet view, or aleast I can't get
it to work.

Any suggestions, or directions would be appreciated

Tom Rector
(e-mail address removed)

 

[MikeB]

www.byerley.net/AccessCalDemo.Zip

You should be able to use the code from the demo to get where you want to go...

 

[Tom Rector]

Mike thanks for the help, 'almost worked' but the calendar will not
post the date into the TEXT2 field 'when' the subform is open in the
main form.

Calendar will post fine in the sub form only when subform is open by
itself.

Thanks Tom

 

[MikeB]

Fix for that is up:
www.byerley.net/AccessCalDemo.Zip