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  

Making a Time book Form



 
 
Thread Tools Display Modes
  #1  
Old April 18th, 2010, 08:33 PM posted to microsoft.public.access.forms
KWhamill
external usenet poster
 
Posts: 32
Default Making a Time book Form

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?

  #2  
Old April 18th, 2010, 09:52 PM posted to microsoft.public.access.forms
Peter Hibbs
external usenet poster
 
Posts: 871
Default Making a Time book Form

Have a look at the Flex Grid Demo program at :-

http://www.rogersaccesslibrary.com/f...3b 1d2zcccfb4

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 Sun, 18 Apr 2010 12:33:01 -0700, KWhamill
wrote:

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?

  #3  
Old April 19th, 2010, 03:03 PM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Making a Time book Form

On Sun, 18 Apr 2010 12:33:01 -0700, KWhamill
wrote:

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'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?

  #4  
Old April 27th, 2010, 06:21 PM posted to microsoft.public.access.forms
KWhamill
external usenet poster
 
Posts: 32
Default Making a Time book Form

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
 




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 02:11 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.