I am working on a Daily Log Database that professors are signing up to have IT equipment set up in their class rooms for the semester from the AV department. I was wondering if there was a way so that on the form I can create it so that it would (for Example) set up an entry for every Monday, Wednesday, and Friday, from 1/06/07 until 5/06/07.
Is this a one off process?
here are a few tips for you:
1) You can check the day of the week using the Weekday() function.
Eg. Weekday(<your date variable>, acMonday)
This will return a number from 1-7 depending on what day of the week <yourdatevariable> falls on. The acMonday declares that Monday is day 1 of the week (if it was monday it would return 1).
2) Think about what loop you are going to need - you might want to make it loop until your date is equal to 05/06/07. So for each iteration fo the loop you want the date to increment.
3) How are you going to get the date to increment for each loop?