Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Pendleton, Indiana, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Run Macro on certian date (2000)

    I have macros that I have created to run a set of queries and reports. they have to be run at the beginning of each month, is there a way I can have these macros run based off of let say the system clock., so @ say Oct 1st 7:00AM the macro that I need for Oct will run. Thanks for any help.

    Trent

  2. #2
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Run Macro on certian date (2000)

    If you have a start up form in the database, you could write code that would check the date and time when it opens and run the macro based on the date.

Posting Permissions

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