Results 1 to 3 of 3
  1. #1
    stephen c is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    30

    Execution of code dependent on outside file status

    Hello!


    An outside JAR program sits in a specific folder.
    That folder also contains a file C:/mypath/app.bat.end
    When the JAR runs, it deletes that file. Once it has completed, it replaces the file.
    There are 20 of these JAR apps, each in their own folder.

    I need to loop through a table to determine which JARs are selected, and launch them. I've figured that out. I need to use the presence or absence of this file as the way to "hold off" Access from launching all of them essentially at once. Basically what I'm after is, in english:

    Go to mypath. Look for app.bat.end.
    If you do not see it, look again.
    If you do, go on to the rest of the code.

    Any guidance on how to do this would be appreciated!

    Stephen.

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    http://allenbrowne.com/func-11.html




    Sent from my iPhone using Tapatalk

  3. #3
    stephen c is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    30
    Perfect! Thank you! I think I now have enough to get where I'm going (for now) Many thanks!

    Stephen.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 08-23-2016, 04:52 PM
  2. Replies: 1
    Last Post: 05-10-2016, 11:45 AM
  3. Replies: 6
    Last Post: 01-26-2015, 02:11 PM
  4. Replies: 4
    Last Post: 06-20-2013, 10:26 PM
  5. Inconsistent Code Execution
    By Paul H in forum Forms
    Replies: 2
    Last Post: 09-19-2011, 10:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums