If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding controls to a calendar in a form
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. -- Rick N |
#2
|
|||
|
|||
Adding controls to a calendar in a form
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. "Gumby643" wrote: 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. -- Rick N |
#3
|
|||
|
|||
Adding controls to a calendar in a form
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! "Prismaddict" wrote: 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. "Gumby643" wrote: 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. -- Rick N |
Thread Tools | |
Display Modes | |
|
|