Forum Home
Press F1
Thread ID: 31401	2003-03-20 22:56:00	Barefaced request - A small Access program please	John W (523)	Press F1

Post ID	Timestamp	Content	User
129735	2003-03-20 22:56:00	A small Access program please. Here is the situation. I run a small workshop 4-5 staff on the floor. I want to do away with Timesheets, replace them with a program that records when the Time & Date when they start a new job, allow the staff to enter there initials, Job number. When they are called off the task, or assigned another task, they currently have to find there present job number, click on a macro button that records the end time for that task, then restart a new task with another button. So, on my Excel spreadsheet, they have three button (macros), Start or Restart a New job, Save the File, End this Job. But, with the W/shop staff not being PC literate, mistakes are occurring, like staff clicking on a New Job, without clicking off the current one, staff clicking off the Wrong Job etc. Im not that familiar with Access, but I know enough about its associations to prevent what I occurs at present, also that every entry is automatically saved. At days end, I want to total the hours spent on the Job versus idle time on a Staff by day basis. If you would like to communicate directly, here is my Email address city.mech@xtra.co.nz Many thanks	John W (523)
129736	2003-03-20 23:50:00	Hi there John One other option is to modify the macros you currently use with excel. You could add prompts so that when another job is started, it would prompt for confirmation that the previous job has either been completed or put on hold, before a new job is started/entered into excel. BTW, spamers just love people who publish there e-mail address on forums. Expect a few unsolicited e-mails soon. Craig	Craigb (688)
1