Mark,
Here's a suggestion ---
Create these tables ---
TblWorkstation
WorkstationID
WorkstationName
etc
TblTask
TaskID
TaskDescription
TblWorkstationTask
WorkstationTaskID
WorkstationID
TaskID
WeekDayToBeDone
Note: WeekDayToBeDone Is an integer. Sunday =1, Monday = 2, Tuesday = 3,
etc.
For data entry build a form/subform. Base the main form on TblWorkstation
and the subform on TblWorkstationTask. You will have multiple records in the
subform for the tasks that are performed on any workstation more than once
per week. Set the Linkmaster/LinkChild properties to WorkstationID.
For displaying the tasks to be done today, also use a form/subform. In the
mainform, you need two unbound textboxes. Name the first textbox
"TodaysDate" and put the following expression in its ControlSource:
=Date()
Name the second textbox "TodaysWeekDay" and put the following expression in
its ControlSource:
=WeekDay(Date())
For the subform, create a query based on all three tables and include the
appropriate fields to identify the workstation and the task. Be sure to
include WeekDayToBeDone from TblWorkstationTask.
For the LinkMaster property, type in [TodaysWeekDay] and for the LinkChild
property, type in [WeekDayToBeDone].
When this form opens, it will display a list of tasks for each workstation
for today.
I have a week calendar form and report module. It could be used to display
the schedule of tasks for your workstations in a calendar layout. As the
module name implies the form and report look like a page torn off a
calendar. I can implement my calendar form and report module in your
database for a very reasonable fee. If you are interested, contact me at my
email address below and I will send you a screenshot.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1000 Access users have come to me for help. My fees are very
reasonable.
