Daily Work Schedule

[JonesZoid]

Hi All

I'm very new to Access, so am currently a big fan of excel for my requirement. But i feel now access is the way forward, as it will probably do a lot more for me.

I currently have Columns A,B,C in excel for my engineers ID, Name, Mobile (Currently 44 engineers in total) and the remaining columns have the dates for the whole year (As far as excel will allow). I assign work a week in advance by putting the site name in the cell of the Day of the work and engineer(s) assigned. I will attach a little example.

So - i'm sort of hoping i can do this much easier in Access. I can then think about adding things like holidays, sickness, timesheet submission etc.

Can anyone help - even just a small example db would be an advantage to ellaborate on myself and learn.

Yours Hopefully

Craig

AKA - JonesZoid

​

 

[Poppa Smurf]

Craig

Have a look at the attached database. The form frm_standby_dates is used to enter the data, you will need to modify it for your requirements. The form frm_rpt_standby_date is used to set the start and finish dates for the reporting period to set the dates you will need to click a date on the calendar then click Set Begining date or Set Ending date as required. This generates a report in a calendar format. You will need to change the report to suit your requirements.

Allan

 

[JonesZoid]

Thanx for your response - but being new to this, it didnt really seem to do much. I need to create the view that i had in excel - which is all 44 engineers down the left side of excel, a row at the top with the dates, and then the grid would be populated with where the engineer is working that week.

With excel the dates would stop as it got to the end of the columns available in excel, so i would have to create a new sheet and start a fresh.

With Access i an hoping to have the same view (as original excel attachment, but bigger of course)- but add in other features like Holiday and sickness counting....etc

Hope this helps to explain my requirements..

JonesZoid