A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

creating Time Book Need help



 
 
Thread Tools Display Modes
  #1  
Old April 21st, 2010, 05:55 PM posted to microsoft.public.access.forms
KWhamill
external usenet poster
 
Posts: 32
Default 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  
Old April 21st, 2010, 06:37 PM posted to microsoft.public.access.forms
Peter Hibbs
external usenet poster
 
Posts: 871
Default 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  
Old April 21st, 2010, 07:05 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default 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  
Old April 21st, 2010, 10:10 PM posted to microsoft.public.access.forms
KWhamill
external usenet poster
 
Posts: 32
Default 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  
Old April 21st, 2010, 10:42 PM posted to microsoft.public.access.forms
Peter Hibbs
external usenet poster
 
Posts: 871
Default 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  
Old April 28th, 2010, 04:38 PM posted to microsoft.public.access.forms
KWhamill
external usenet poster
 
Posts: 32
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.