Results 1 to 4 of 4
  1. #1
    Rendon115 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2019
    Posts
    10

    Watching movement between folders

    I am going to need help with this one for sure. Short version is we have two job folders at the office, one for completed jobs, and one for active ones. I currently am tracking them via manual entry, but ideally once a day, id like to have access check to see if one job moved from active to completed and update the link in the table. The jobs are also their own folder.
    So Active_Folder -> Job1_Folder -> Job1_Data
    As an example

    How I go about doing this I am unsure, maybe using Dir() of each job folder to see if it exists and then if they dont exist in one, check in the other? I might have to do that both ways though, since sometimes we re-activate old jobs. There's also ~2000 or so currently

    If you have any idea where I could start, please let me know.


    Thank you,

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Are you describing physical file folders(as in a file cabinet) OR tables in a database representing file folders on a computer/network?
    I suggest:
    -you give a fuller description of what you are trying to achieve in simple terms and example
    -you show us your table(s) set up.

    Typically, if you want to show a change in state/status, you would record a record identifying the record, the current state and date stamp. Then by comparing records in that table you can determine the various states the record was in and when it changed.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    have a program do it. (excel or access)
    when the user finished, click a button,
    it records the finished item to a list, (or table)
    then moves the file/folder to the COMPLETED drive.

  4. #4
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    Quote Originally Posted by Rendon115 View Post
    How I go about doing this I am unsure, maybe using Dir() of each job folder to see if it exists and then if they dont exist in one, check in the other?
    Thank you,
    Oh yes, you are in the right direction!
    You can use the event "Timer" of a form to check the folders periodically.

    See how in attachment.
    Start the "folder watcher", move some folders between their parent folders and wait. You will see the changes in the listbox.

    Cheers,
    John
    Attached Files Attached Files

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

Similar Threads

  1. Simulating mouse movement and clicking....
    By rpeare in forum Programming
    Replies: 10
    Last Post: 07-29-2018, 07:21 PM
  2. Replies: 2
    Last Post: 05-24-2016, 04:54 PM
  3. Replies: 3
    Last Post: 07-11-2013, 07:08 AM
  4. Replies: 2
    Last Post: 02-17-2012, 04:09 AM
  5. Replies: 1
    Last Post: 03-29-2009, 08:27 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