Please Help - Need up designing a form to capture monthly activities

[marsha D. Carpenter]

I think I have may have already posted something similiar to this. But I cannot locate the post. I need an example that displays how to capture time spent each day per activity for each month. Any valid advice would be much appreciated!

I need to capture for each inspector for each day and for each week and month time spent of each of the activities.

 

[MarkK]

Advice that jumps to mind is get way more specific about what you need. A working solution is going to need to address the issues with much greater specificity than what you've offered here.
What inspector? What Activities? What resolution of time? To the minute? The second? What's the purpose? QA? Payroll?
Hope this helps.

 

[marsha4jesus]

Daily/Monthly Activity Calendar

My newest and latest project assigned one day and due the next is this.
The railroad inspectors for my employers' Multi-Modal division want an Access DB application that tracks time spent in one hour increments, on a daily basis, by their inspectors, time spent on 14 different activities. Like a monthly time sheet. Each day, they need to document how much time was spent on what activity. At the end of the month, they want to report on this activity for each inspector/employee, using charts and graphs. I have determined that I need a table which stores an ID for each employee and other info. Another table containing a row for each day for each employee with 14 columns, one for each activity, and a column designating the date of the activity. and another column to indicate which employee the record is for. After that, I'm stuck! I haven't programmed in 4 years and again I'm under pressure to generate this report by the 29th. With Monday, the 27th being a holiday. My boss told me it could actually be done in a day! So.... any assistance you could provide would be very much appreciated. If I can fuigure out how to attach docs, I will attach the Excel documents I have which they currently use. I just checked, and I first need to download winzip to zip these .xls files. So......I'm on a dial-up here at home cause I can't get anything else out here in the boondocks. thank so much!

 

[Rich]

Your boss is a joke, tell him you need to mormalis(z)e the db first. Access is not a spreadsheet, which is what you are trying to use it as at the minute

 

[marsha D. Carpenter]

When my boss told me the project could be completed in a day, I asked if he was joking and he replied no. So....... I just started July 1st and I am on probation for the first six months. I don't know if they are trying to send me packing or not.Please help!


This is my response to Lagbolt's resposne:

My newest and latest project assigned one day and due the next is this.
The railroad inspectors for my employers' Multi-Modal division want an Access DB application that tracks time spent in one hour increments, on a daily basis, by their inspectors, time spent on 14 different activities. Like a monthly time sheet. Each day, they need to document how much time was spent on what activity. At the end of the month, they want to report on this activity for each inspector/employee, using charts and graphs. I have determined that I need a table which stores an ID for each employee and other info. Another table containing a row for each day for each employee with 14 columns, one for each activity, and a column designating the date of the activity. and another column to indicate which employee the record is for. After that, I'm stuck! I haven't programmed in 4 years and again I'm under pressure to generate this report by the 29th. With Monday, the 27th being a holiday. My boss told me it could actually be done in a day! So.... any assistance you could provide would be very much appreciated. If I can fuigure out how to attach docs, I will attach the Excel documents I have which they currently use. I just checked, and I first need to download winzip to zip these .xls files. So......I'm on a dial-up here at home cause I can't get anything else out here in the boondocks. thank so much!

 

[marsha D. Carpenter]

need help generating a timesheet applicattion

Attached is a copy of the Excel files which I must duplicate in ACCESS. Please someone help! This is due on the 29th, Mon. the 27th is a state holiday. I only have dial-up at home. I have looked at several calendar apps and I have gotten some ideas.

I am thinking that the user enters a month and year for which they want a timesheet. Then a form is generated with the activities as column headers, and the days as rows,one for each day of the month.

Thanks in advance everyone![/B]

 

[MarkK]

Like Rich says, don't duplicate Excel in Access. They're different tools for different jobs.

If the only tool you have is a hammer, everything looks like a nail.

Consider a table structure like this. Maybe your tActivity has 14 records. The central table is the tEEActivity. And maybe rather than start and end you just want a Duration field.
Your tEE and tActivity won't change much, but you'll be adding records to the join table all the time.

[B]tEE[/B] (Employee)
EEID (PK)
First
Last
DOB
HireDate
PayRate

[B]tEEActivity[/B]
EEActivityID (PK)
EEID (FK)
ActivityID (FK)
Start (date/time)
End (date/time)

[B]tActivity[/B]
ActivityID (PK)
ActivityName

 

[marsha D. Carpenter]

need help generating a timesheet applicattion

Ok! Thank You! What would the data entry form that captures the data look like? Please walk me thru this! Thank you!

 

[MarkK]

Build your main data entry form around the tEEActivity table. Put combos on the two foreign keys so they display meaningful data. An example rowsource for one of those will look like...

SELECT EEID, First & " " & Last as Fullname FROM tEE ORDER BY Last;"

Once you have that going it should look pretty intuitive. Lemme know.

 

[marsha4jesus]

Thanks a bunch! I have designed the tables as you described. I have the form designed and am currently use it to capture the data. I have to add some edits. Next, I will allow the user to display a monthly calendar with the activities contained within the calendar. Next, I will generate the pretty reports using charts and graphs, which I need to figure out how to do cause I've never developed charts/graphs in VBA before. But thanks to this forum and people like you, I feel more confident that I can accomplish this task! Thanks yall!

 

[boblarson]

I think I have may have already posted something similiar to this. But I cannot locate the post.

That's because you keep posting things in the three categories which CANNOT have questions posted in. Do NOT, I repeat, DO NOT keep trying to post in the Access FAQ, Code Repository, or Sample Databases areas. They are moderated areas which DO NOT ALLOW QUESTIONS TO BE POSTED THERE. I've told you by Private Message and it doesn't seem to be getting through.

So, one more time - DO NOT POST QUESTIONS IN THE ACCESS FAQ SECTION, THE CODE REPOSITORY SECTION, AND THE SAMPLE DATABASE SECTION. COMPRENDE?

 

[marsha4jesus]

yes SIR!! This posting that you are referreing to is old and resolved. I do not know why you are responding so hatefully after the fact. I am sorry, again! I sent a request on how to use the forum and no one responded. I posted a thread last night regarding chart/graph generation. Hopefully I posted this in the correct area! Thank you and again, I am sorry!

 

[marsha4jesus]

Also, I see the posted response threads here. Was this posting not in the correct area as well? Please forgive me! I am confused especially now since I see that This particular thread was responded to positively by users.