Time Sheets Help!

[Laney]

Hello all,

I am trying to figure out how to get a time sheet to work in Access. Does anyone have any suggestions on what they've done in the past to help?

Please let me know if you have any information that can help me.

I appreciate it!

Thank you,

 

[Mile-O]

A good place to start is usually to do a search of previous posts.

 

[namliam]

LOL - nice way to start out at a forum

 

[Laney]

Hmmm ...

LOL - nice way to start out at a forum

I thought it was a forum to help people. Sorry if it's not. Trying to figure this out and it's driving me nuts.

 

[Laney]

A good place to start is usually to do a search of previous posts.

Thanks Mile - I was already looking through them.

 

[namliam]

Re: Hmmm ...

I thought it was a forum to help people. Sorry if it's not. Trying to figure this out and it's driving me nuts.

Well it is, but asking such a general question doesnt give anybody anything to start from. Look thru the search list, read up on whats allready there. If you then have any specific questions ppl will be more than happy to help you...

Regards

 

[Laney]

Re: Re: Hmmm ...

Well it is, but asking such a general question doesnt give anybody anything to start from. Look thru the search list, read up on whats allready there. If you then have any specific questions ppl will be more than happy to help you...

Regards

I've been looking through them. Looks like most of them have the same type of answer you just gave me. hahahha !

 

[WayneRyan]

Laney,

That is a very general question.

I was involved in a project that had a table for employees, a table
defining which of (many) projects that people could work on,
budgets down to the task level, and expenditures tracked over
the life of a project.

Basically, the software would "see" (by the login procedure) that
an employee logged in. The timecard screen would be presented.
They would select a pay-period date for the session.

Within the form, the users would select a project-task
combination, enter their hours, s/w would check to see if funding
available, and record the entry.

There are the usual validation checks to ensure that noone works
25 hours a day, etc.

That's a general answer, how about some specifics?

Wayne

 

[Laney]

Nevermind!

How about I just figure it out myself since everyone's so smart @$$ed and hateful on this board. Good God!

 

[Autoeng]

I always thought they were smart asses myself! I wouldn't blame you at all if you went to www.tek-tips.com or www.utteraccess.com and never came back here.

 

[Laney]

Probably will ...

Thanks for the tip.

 

[WayneRyan]

Laney,

Me too?

Wayne

 

[Autoeng]

Laney:

I don't think anyone was trying to be hateful or less than helpful but your post is very generic in nature and difficult to address. If you had an idea of the system that you would like to pursue and the constraints that you will have to impose almost everyone here would be happy to assist you getting started. From there you can start to narrow down your questions to the specific problems you are having which is a lot easier to address.

I hope you don't feel that the people here are hateful as you had 3 of the best we have to offer respond to your question indicating that it was just too vague to offer any real assistance at this point. You will probably get much the same responses at the other boards I directed you to until you begin to narrow the problems down.

 

[Laney]

Change the word ...

Guess I should have just put namliam instead of "everyone". I thought about changing it but everyone's seen it so no need to now lol

I'll put more on later concerning what I am attempting to do here. Sorry I didn't put the entire thing up first post. Haven't ever posted here before.

Thanks for the help from the ones who were nice and tried to help.

 

[Autoeng]

I'm sure namliam's comment was not meant to be taken as you did as he is a very helpful person. I kind of read it as a jab at Mile but I'll let him confirm or deny his intent.

 

[Mile-O]

I kind of read it as a jab at Mile but I'll let him confirm or deny his intent.

You know me, I'm an advice guru.

Yeah, as has been said the initial question didn't dwell on specifics. A time sheet to one person or in one company could be completely different to another person or another company. Some time sheets only deal with specific hours (e.g. 08:00 to 20:00 Monday to Friday) whereas others may have to contend with multiple departments on a 24 hour basis. And then you have other contractual obligations that may need included: allowing scope for annual leave, overtime at differing rates, and public holidays.

Once you decide on your particular business rules then you can start your database - not before.

So, deciding on rules and specifying them will allow use to offer solutions, structures, and other suggestions to create the time sheet you want and not the time sheet we think you want.

I gave the link to the search as there have been loads of questions regarding time sheets - some specific, some vague, but all of which illustrate that time sheets differ from person to person.

 

[Autoeng]

Aw shoot Mile, just whip up a sample db of each and post it. Ya know ya want to.

 

[Mile-O]

Aw shoot Mile, just whip up a sample db of each and post it. Ya know ya want to.

lol, no sample dbs when I'm home - personal projects to work on.

 

[Laney]

Aw shoot Mile, just whip up a sample db of each and post it. Ya know ya want to.

hahahha! yanut!

 

[Laney]

What I need suggestions on ...

I am trying to create a time sheet with the following.

My table information is: (tbl Time Sheets)

Employee (My brain is fried I can't think how to get the employee number to automatically generate the employee name)
--------------
Employee Number (when entered automatically generates First Name, Middle Initial and Last Name)
First Name
Middle Initial
Last Name

Time (Week Ending, Pay Period Number, Date and Day are automatically generated from a link to an excel file)
--------------
Week Ending (automatically generates Pay Period Number)
Pay Period Number (references Week Ending in the qry Pay Dates file and automatically generates)
Date (automtaically pulls in dates from Saturday to Friday for the Week Ending number)
Day (automatically generates the day when the dates are pulled in)
Regular Time
Over Time

Scheduled Towards
--------------
Client (generated from a file qry Client Codes)
Project (generated from a file qry Project Codes)
Task (generated from a file qry Task Codes)

Information on the Time
--------------
Memo (data entry (memo) section which has description of time spent)

Hourly Wage Information
--------------
Hourly Wage (which is generated through tbl Employee Payroll, when you enter Title and Job Description it automatically generates their hourly wage)
Hourly Billing Rate (which is generated through tbl Employee Payroll, when you enter Title and Job Description it automatically generates their hourly billing rate)
Hourly Overtime Billing Rate (which is generated through tbl Employee Payroll, when you enter Title and Job Description it automatically generates their hourly wage)

All costs of Office Supplies, Benefits, Vacation, Holidays, Sick time are added into these hourly rates)

This information will be generated into a spreadsheet which also pulls the hours and expenses out of the budget.

Maybe I'm doing better than I thought hahahahah I at least got this together. I'm working with this for now ... Will have to see if there's anything to make it easier for the end user when we get to that point. Is that a big mess or what? hahah!

I guess the best way for anyone to help me is to just hit me on the head so I'll be knocked out cold!