Calendar Options

[Sharon Hague]

Hi All

I have created a database to log all employee absence and overtime details throughout the year.

At present I have various forms reading from tables which contain date fields.

I have inserted a calendar through Active X Control. Is it possible so that once I select a date from the calendar it automatically enteres this date into my date field on my form?

Can anybody help?

 

[ColinEssex]

Check this out Sharon, there's some examples here to download.

Col

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46021&highlight=calendar

 

[Mile-O]

Search on my name, I've posted loads of examples using the ActiveX Calendar control.

 

[Sharon Hague]

Hi Colin

Thanks for your reply.

After changing the name of the fields it works a treat and was just what I was looking for.

Cheers.

 

[Sharon Hague]

Colin

I have another query now!!

I used your module in my database form and changed the name of the form and field so that it would work with a form I have produced, which it does.

I applied this to a field called Date From so now in my module's details it reads ctl = Forms!AbsenceDetails!DateFrom, however in the same form I also have a Date To field which I also need the calendar to pop up to select a date.

How do I change the module's details to be able to do this?

Please advise.

 

[Mile-O]

You might be better off with this - one form and a hell of a lot less code.

 

[Sharon Hague]

Thanks Mile-O-Phile

Its worked a treat.