Solved

Employee Time Sheet

Posted on 2004-10-08
12
442 Views
Last Modified: 2012-06-21
I have a worksheet set up to track employees sign-in and sign-out times from the start of their shifts including the lunch breaks to the end of thier shift.
But my problem is that this sheet is disigned to track 12+ employees, but in order for me to to that I have to create 12+ sheets - which is a no-no given all that scrolling and switching bettween sheets.
I want to be able to create a drop-down list with all the employees there, that when I click on a specific employee the worksheet will change all its values based on this particular employee's work hours.
To be more especific when I enter data on "Mike" it will stay that way only for him even if I click on "John" to check his work hours.
If you need a copy of my worksheet, just tell me how to paste it here, or give me an e-mail to send it to you...
If anybody know of a template or already have this type of sheet, can you please help?

Thanks in advance!

-Sarcigon
0
Comment
Question by:Sarcigon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
12 Comments
 
LVL 1

Expert Comment

by:perennial
ID: 12266746
Are you in the right section? Sounds like you need help in Excel. If in Access, how is your table structure?
0
 

Author Comment

by:Sarcigon
ID: 12266865
Yes, I was in EXCEL, but someone suggested me to this forum instead, I think it's kind of dificult to do in Excel. I want to explore all possibilities.
Below there's a link to my sheet.
Thanks
-Sarcigon

http://www.geocities.com/sarcigon/EmployeeTimeSheet.xls

0
 
LVL 1

Accepted Solution

by:
perennial earned 25 total points
ID: 12266985
Assuming that you will type in the hours manually.

Create two tables:

Table 1: tblEmpInfo

EmpID >>(Primary)This can be auto number
LName
FName
SSNo
...So on as you need

Table 2: tblClockInOut

EmpID
WorkDate >>Date record..could have it default to current date
ClockIn
LunchOut
LunchIn
ClockOut

...add fields as needed

Create a relationship from tblEmpInfo to tblClockInOut as one-to-many.

Design a form, use tblEmpInfo as your main form and use tblClockInOut as your subform.

Let me know if you need more details.

perennial

0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:Sarcigon
ID: 12288433
Perennial, How do I create a reltionship between those tables?
That question might sound stupid, but I'm that good on Access, the little knowledge I have is in Excel.
So bear with me, because I'm novice in this Application Development thing.
Your understanding is greatly appreciated.

-Elvin
0
 

Author Comment

by:Sarcigon
ID: 12310160
This is what I have created so far...
But I can't get it to add the times and to roll the days like in Excel.
I get errors everytime I tried to put in a formula.
Below ther's a copy of my sheet, is done but is dead.
Can anyone help!!!!!!!?????????


http://www.geocities.com/sarcigon/EmployeeTimeSheet.mdb
0
 
LVL 54

Expert Comment

by:nico5038
ID: 12329219
Hmm, daunting task.
You'll have to drop "thinking in excel sheet format" and start designing tables.
In this case you'll need a tblPersonnell and a table (tblTimes) with the recorded times.
Before doing so you'll need to be sure that there's no recording needed for overwork. The present form doesn't allow that and also working on saturdays and sundays can't be recorded.

Nic;o)
0
 

Author Comment

by:Sarcigon
ID: 12329326
I already have two tables done, do I have to delete them and make new ones?
I know I'm kind of thinking in Excel mode, sorry.
But when I was sent to this forum from Excel I actually thought it was gonna be easier.
Did you get the sheet I created?
Do I have to re-create them?
I'll take the overwork out like you suggest.
When you create a table does it have to be with the prefix "tbl"..?
0
 
LVL 54

Assisted Solution

by:nico5038
nico5038 earned 25 total points
ID: 12329415
Prefixing is easy when you're also having queries with a prefix "qry" you can keep them easily separated later when coding.

Time in a table can be done in several ways.
Having a fixed number of timeslots allows a table like:
PersonID(*), DateRecording(*), StartTime1, EndTime1, StartTime2, EndTime2, etc

The most flexible and "normalized" way would however be:
PersonID(*), DateRecording(*), StartTime(*), EndTime1

The (*) indicates the fields defining the unique key of the row.
The flexible way is the best as it won't "ruin" your application when the company decides to go to work in multiple shifts.

On the form you can use now a mainform bound to the person data and a combobox to allow the choice of a certain week.
These fields can be used to link a subform with to show the rows for that person and the selected week.
Getting a total hours can be done now with a field in the footer in the "excel" mode like:
=SUM(fieldname)

Nic;o)
0
 

Author Comment

by:Sarcigon
ID: 12366651
How do I show the day only in in the access date format, I can't figure that out.
Access only aloww me to use short, medium and long date.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 12367591
Use the format property "input mask" under the Data tab and/or the Format() function.

Nic;o)
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question