Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Timed Search for File (Access 2002)

    I have the requirement to periodically search a folder for the existence of a file with a specific name. Ideally, this should be a background task. The user wants the rest of the application to function while this background search is periodically triggered.

    I have seen reference to the Form Timer event. Is this what I should be looking at or is there a better alternative? Does anyone have any examples that I can use as a guide?

    Thanks.
    Carol W.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Timed Search for File (Access 2002)

    You are on the right track with the Form Timer.

    Just use the Dir command to test if a file is in a particular directory, or did you already know that.

    HTH

    Cheers,
    Pat

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timed Search for File (Access 2002)

    Pat:

    Thanks for the reply. I did not know about the Dir function but I do now!

    Will the timer event allow for the application to keep running while the event is periodically triggered? I've never used this event.
    Carol W.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Timed Search for File (Access 2002)

    There is a timer attached to each and every form.

    What you could do is to start up the form with the Timer and just minimize it, it will keep running while you can go into another form, query, report, etc, etc.

    As soon as you close the form with the timer, the timed event stops of course.

    Cheers,
    Pat

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Faifax, Virginia, USA
    Posts
    542
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timed Search for File (Access 2002)

    This thread may be of interest also.

  6. #6
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timed Search for File (Access 2002)

    Thanks again, Pat. I probably would have thought of that eventually! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
    Carol W.

  7. #7
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Timed Search for File (Access 2002)

    Peter:

    Thanks for the link.
    Carol W.

Posting Permissions

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