creating Time Book Need help

[KWhamill]

I'm developing a time book in Access 2007 for my peers. Most of the
functionality is biult and works fine. the stumbling block is the Interface
or the form. the users want an interface very much like what the have now.
What they have now: a spread sheet with dates across the top and employees
down the left. all they input is the absence code (AL Annual leave, SL Sick
leave, &c) for that day.
what we are adding: the shift start and end times, unit, & position.
So in a perfect world I would have a grid, with 14 days (one payperiod)
across the top, employees down the left and Shift start and end, Unit,
Position and Absence code for each employee for each day.
I have had the hardest time making this do even the simple absence code. I
simply cannot figure out how to make it work. Help is much appreciated at
this point.
Any ideas?

 

[Peter Hibbs]

Tom van Stiphout and I both made suggestions to your previous post on
the 18th to this question. Presumably neither of those were acceptable
so I think it unlikely you will get further replies.

Peter Hibbs.

 

[golfinray]

You need a form in datasheet view. That will look like a table or an Excel
sheet.

 

[KWHamill]

Used to be i could find my old posts simply by searching for my User ID. but
that doesn't seem to be the case any more. I assumed that post had fallen off
the face of the web.
The Flex Grid: I've never used a flex grid before so can you explain how
this works?

 

[Peter Hibbs]

OK, in that case I suggest you have a look at the Flex Grid Demo
program first at :-

http://www.rogersaccesslibrary.com/...p?FID=21&SID=5debzz2c87c6957859f13b1d2zcccfb4

to see if it will do what you want. You will need to write a fair bit
of VBA code to do this but there is a time sheet example in this demo
which sounds similar to what you are trying to do.

HTH.

Peter Hibbs.

 

[KWHamill]

OK so the flex grid does pretty much what i want it to do. It actually does
far more. all I want it to do is allow me to enter and edit Absence Codes and
Shift times &c.
I don't have a license for VB6 and our IT isn't going to supply me with a
copy.
The idea of combing through the code in sample sounds daunting although i'm
sure i would learn alot from it. Is there an alternative?