Adding controls to a calendar in a form

[Gumby643]

Hi all,

I'm a newbie who is finding out his knowledge is much more limited than is
his imagination

I'm trying to create a form in which I will have a check box on each date of
a calendar to simply indicate whether an employee had worked that day, but I
can't figure out how to include multiple check box controls on one calendar.

 

[Prismaddict]

I feel your pain Rick, watch for "Clueless and Frustrated" because I'm having
about the same issue. I have found a pretty good calendar generator that will
allow you to input data for a particular date
http://www.fabalou.com/Access/Forms/calendar_entry.asp
the only catch is I'm trying to input data for 30 people across 6 weeks. If
you download this calendar you can insert your "check box" on the
dates_subform and it will work. Read the warning however because if you
remove the little "date" text box on the Dates_subform it will screw it up.
The problem I'm having is the "check box" (I'm using a 1/4 combo box) points
to the field where it will put the data through the Combo box control. In the
Dates table it has Value1 and Value2 and you can point the data to Value 1
when you constuct your check box (where do you want the data stored?). My
problem is I can't figure out how to make that combo box (check box) a
selectable variable for lack of a better term. I want to be able to select an
employee from a pulldown and have that selection identify where my combo box
data will go. It sounds simple enough but apparently it's not. Just looking
on the net, people are getting a lot of money for "access calendars" I'm
surprized MS doesn't have a template or something to do this type of
operation. Good luck! Karl
ps If you look at the Calendar form in design and get the properties for the
"choose Month" pull down, look at "On Change" it will show the code used to
make the Calendar if you want to incorporate it somewhere else.

 

[joestros]

Prismaddict,

I am trying to do the same sort of thing for student attendance. I want to
select a date, and then have a list of students appear with check boxes next
to each name where I can mark present or absent, then add them up for the day
and store the data somewhere. It is a lot harder than I thought. Any
insight on how you did it would be appreciated. Thanks!