Making a Time book Form

  • Thread starter Thread starter KWhamill
  • Start date Start date
K

KWhamill

I'm creating a time book in access to record Shift work and time off and such
things. so far everything seems Ok but the Form. i need the Form to lay out
as a Biweekly calender, dates across the top employees down the left side.
The User puts in a Payperiod Number and the rest of the Form populates on
Refresh and the user can make adjustments. I can't seem to find away to make
it work. Does any one have any suggestions?
 
On Sun, 18 Apr 2010 12:33:01 -0700, KWhamill

That sounds a lot like the results of a Crosstab query until you
mentioned you need to edit the data. Perhaps you can intercept the
double-click, open a small window for editing, and requery the main
form.

Another possibility is to use a "Temp" table with EmployeeID and 14
date fields. After the payperiod is entered, the temp table is filled
with an Append query, the form binds to this table and editing is
built-in. Upon Save you copy the data back to the "real" tables.

-Tom.
Microsoft Access MVP
 
I like this idea but I'm not Savy enough in VB for the first idea.
AS for the Temp table I feel like i've tried something like this before for
another reason and although i can set up the table I seem to recall i had a
problem deconstructing the table later. not really sure what to do
thank you for your suggestion
 
Back
Top