stevekos07
Registered User.
- Local time
- Today, 07:09
- Joined
- Jul 26, 2015
- Messages
- 174
I have a staff roster that I would like to add a feature that will allow the user to roster a member on a regular basis, either weekly, every 2 weeks, once every 4 weeks etc. as well as the option I have now for selecting the next roster date. I would like to have a combobox with options labelled as such. What code would I need to enter the staff ID into a table with a date/time entry set at various ranges according to the option selected? (I hope I am making myself clear).
Would it be as simple as applying an expression to each option (e.g. Date()+7 for one, +14 for another etc.)?
I am thinking maybe a Select Case in VBA. Am I on the right track? How would I write the code?
Table: tblStaffRoster
Field: NextRosterDate
Would it be as simple as applying an expression to each option (e.g. Date()+7 for one, +14 for another etc.)?
I am thinking maybe a Select Case in VBA. Am I on the right track? How would I write the code?
Table: tblStaffRoster
Field: NextRosterDate