AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Expert: Scottgem Date: 7/18/2008 Subject: access 2003 db
Question QUESTION: hi,
I have an extra criteria for my database that i hope you could help me with I need to be able to sort my volunteers out by am and pm so for example I have created a combo box on my tbl Tasks that the user select am or pm after that i have a combo box for the day of the week so after the user has finished selecting the final assigned to combo box should be filtered by both time of the day and day of the week. I have structured my database the way you previously suggested.
DaysWorkedID
Assignedto
EmployeeID
Date
Days
ANSWER: First, Date is a reserved word in Access and shouldn't be used for an object name. Second, I'm not sure I understand that structure. My understanding was that a volunteer is scheduled to work certain days out of the week, not certain dates. Can you elaborate.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: hi,
another criteria has been added to the database that i need to be able to split the volunteers into working am and pm as well as the day of the week so if i want a volunteer that works monday i can select from monday am or pm. I have added these criteria to my database but on my tasks page iam not sure how to set it out so that my combo boxes filter the day then the the time am/pm so that the user for example can select monday then from am/pm to get the filtered amount of names that work that day and time. If you could help me with how i could do this on my tasks form.
thank you very much for your knowledge and time
jodie
Answer That doesn't really answer my question. My initial suggestion was a table like this:
tblDaysWorked
DaysWorkedID (Primary Key Autonumber)
EmployeeID (Foreign Key)
WorkDay (either Sunday, Monday etc. or 1,2 etc.)
I don't see where a date is applicable, unless you are recording actual dates. In which case the dynamic changes. My assumption is that you were recording scheduled days of the week. To add the AM/PM I would add a field to the above table: PartOfDay. I would store in that field a 1 (AM), a 2 (PM) or a 3 (all day).
On your form to select employees I would have an option group to select either AM, PM or All day.
If you are going by actual date instead of day of the week, then you would have to checnge the selection criteria accordingly.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: MS Office Access 2007 VBA
