Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122

    Unanswered: triggeringVBA with system time

    Is it possible to run a macro or VBA code at a specific time? To be more specific- i want to 'trigger' a piece of code to run at 3:00am or what ever time i need it to. I thought about using the system time but I also thought that Access would time-out (or something) before it would run. Does anyone have any suggestions?

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    seems unnecessary to keep A open to run something at 3 in the morning.

    did you try windows scheduler with a small dedicated A app that runs your code in the _Load() of the startup form?

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Dec 2002
    Location
    Phoenix, AZ
    Posts
    122
    good idea- thanks

Posting Permissions

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