Custom Calendar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I really like the Active X calendar included with Access, at least in terms
of it's look. However, it doesn't offer the functionality I'm looking for.
What I would like to be able to do is choose a user from a drop-down box,
then click click on a date within the calendar. At that point, I'd a small
form open up for that day where I could then enter which client that person
worked with, which project the hours were spent on, and the number of hours
worked for that day. I would like to be able to enter data for several days
without having to manually save the data from one date before moving on to
the next date. Is this possible?

Thanks,

Tara
 
I think you will find that it will do what you want. What you need to do is
add VBA code to the On_Click() event of the calendar. Unfortunately this
property isn't displayed under the properties section when your looking at
the form in design mode. What you need to do is go to the VBA section (Alt +
F11) then go to the form under Microsoft Access Class Objects then select the
calendar control from the drop down menu where is says "(General)" and then
select the On_Click event from where it says "(Declarations)"

Hope this helps
Brett
 
Back
Top