Results 1 to 2 of 2

Thread: Auto Enter

  1. #1
    Join Date
    Jan 2007
    Posts
    7

    Unanswered: Auto Enter

    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 Possible?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    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?

    This should hopefully give you a starting point!

    - GeorgeV
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •