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
|
|||
|
|||
Attendance sub form
I am having trouble(i'm a newbie) finding a way to generate a form to enter
data for a group of active employees by date. The only way I can see to do it now is to scroll individually through eash employee's record, and update that way. I would like to enter a date, and add records for that date for all employees in the same form. Any help would be greatly appreciated. |
#2
|
|||
|
|||
You could use a continuous subform on a main form. Add a text box on the
main form for the date. Then set the link master child properties of the subform control to the text box and the date field in the subform. Each new record in the subform will default to the date from the text box on the main form. -- Duane Hookom MS Access MVP "mchicke" wrote in message ... I am having trouble(i'm a newbie) finding a way to generate a form to enter data for a group of active employees by date. The only way I can see to do it now is to scroll individually through eash employee's record, and update that way. I would like to enter a date, and add records for that date for all employees in the same form. Any help would be greatly appreciated. |
#3
|
|||
|
|||
I think my problem may be deeper. I have a query set up of all 'Active'
associate which returns their Name and ID#. I am then trying to link to the Attendance table with the fields ID#(the relationship to return names) Date, Time in and time out. I would like to be able to edit all active associates for a new date all at once, instead of moving record by record of each employee in the main form and entering the data in the subform. The problem may lie in my tables or queries? "Duane Hookom" wrote: You could use a continuous subform on a main form. Add a text box on the main form for the date. Then set the link master child properties of the subform control to the text box and the date field in the subform. Each new record in the subform will default to the date from the text box on the main form. -- Duane Hookom MS Access MVP "mchicke" wrote in message ... I am having trouble(i'm a newbie) finding a way to generate a form to enter data for a group of active employees by date. The only way I can see to do it now is to scroll individually through eash employee's record, and update that way. I would like to enter a date, and add records for that date for all employees in the same form. Any help would be greatly appreciated. |
#4
|
|||
|
|||
On Wed, 26 Jan 2005 07:35:04 -0800, "mchicke"
wrote: I think my problem may be deeper. I have a query set up of all 'Active' associate which returns their Name and ID#. I am then trying to link to the Attendance table with the fields ID#(the relationship to return names) Date, Time in and time out. I would like to be able to edit all active associates for a new date all at once, instead of moving record by record of each employee in the main form and entering the data in the subform. The problem may lie in my tables or queries? Probably this can be handled at the form level. Use a mainform (which might be unbound) with a textbox for the desired date, and a Subform based on your attendance table using this textbox as the Master Link Field and the date as the Child Link Field. (By the way, do NOT use Date as a fieldname; it's a reserved word and Access will get confused). You can then have the subform as a continuous form with the associateID bound to a combo box allowing you to select each associate's name and enter their times. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Link subforms to show active record | Timboo | New Users | 4 | December 23rd, 2004 10:59 AM |
Dates in a listbox connected to a form... | RusCat | Using Forms | 13 | November 25th, 2004 03:31 AM |
modal windows | AT | Using Forms | 3 | November 21st, 2004 06:49 AM |
Strange stLinkCriteria behaviour on command button | Anthony Dowd | Using Forms | 3 | August 21st, 2004 03:01 AM |
auto entry into second table after update | Tony | New Users | 13 | July 9th, 2004 10:42 PM |