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
|
|||
|
|||
creating Time Book Need help
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? |
#2
|
|||
|
|||
creating Time Book Need help
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. On Wed, 21 Apr 2010 09:55:01 -0700, KWhamill wrote: 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? |
#3
|
|||
|
|||
creating Time Book Need help
You need a form in datasheet view. That will look like a table or an Excel
sheet. -- Milton Purdy ACCESS State of Arkansas "KWhamill" wrote: 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? |
#4
|
|||
|
|||
creating Time Book Need help
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" wrote: 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. On Wed, 21 Apr 2010 09:55:01 -0700, KWhamill wrote: 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? . |
#5
|
|||
|
|||
creating Time Book Need help
OK, in that case I suggest you have a look at the Flex Grid Demo
program first at :- http://www.rogersaccesslibrary.com/f...3b 1d2zcccfb4 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. On Wed, 21 Apr 2010 14:10:02 -0700, KWHamill wrote: 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" wrote: 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. On Wed, 21 Apr 2010 09:55:01 -0700, KWhamill wrote: 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? . |
#6
|
|||
|
|||
creating Time Book Need help
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? "Peter Hibbs" wrote: 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. On Wed, 21 Apr 2010 09:55:01 -0700, KWhamill wrote: 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? . |
Thread Tools | |
Display Modes | |
|
|