Multiple selection in calendar control

[Mariebob]

Hi everyone,

I am trying to manage the holidays of the employees in access and I wondered
if there was an easy way to do it, like a multiple-selection calendar control
or something like that.

Anyone has any idea?

thanks

 

[Steve]

How about three comboboxes for Month, Day and Year then use the DateSerial
method to bring them together as a date.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Mariebob]

Well, I was looking more for something clickable, I mean, having ONE calendar
and click every date a person is on vacation... instead of having to select
each date separatly...

 

[Steve]

You should have tables that look like:
TblEmployee
EmployeeID
EmployeeName

TblEmployeeVacation
EmployeeVacationID
EmployeeID
VacationDate

You can then create a form/subform where the main form is based on
TblEmployee and the subform is based on TblEmployeeVacation. Add an unbound
calendar control named MyCalendar to the subform header. Add code in the
AfterUpdate event of the calendar that goes to a new record in the subform,
sets VacationDate to MyCalendar.Value. Each time you click a date on the
calendar, you will add a vacation date to TblEmployeeVacation.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[Mariebob]

Nice!

You're a genius!!! Thanks a lot!

You should have tables that look like:
TblEmployee
EmployeeID
EmployeeName

TblEmployeeVacation
EmployeeVacationID
EmployeeID
VacationDate

You can then create a form/subform where the main form is based on
TblEmployee and the subform is based on TblEmployeeVacation. Add an unbound
calendar control named MyCalendar to the subform header. Add code in the
AfterUpdate event of the calendar that goes to a new record in the subform,
sets VacationDate to MyCalendar.Value. Each time you click a date on the
calendar, you will add a vacation date to TblEmployeeVacation.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)