Results 1 to 2 of 2
  1. #1
    superfury is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jun 2011

    Question VBA/Access form Detect return of software

    Is it possible to detect (in a access form/VBA) when the user returns from a program called by the Shell command? (e.g. WINWORD.EXE "blablabla.doc" ...) I want to refresh a list of files created in VBA+Access listbox when the user is done using word (saved a .doc/Word file that needs to be displayed in the list). It currently works in the Form_Activate+Form_Open functions. The script clears the list and adds the existing files of a directory (with further specifications already implemented, based on another form that's opened).

    It needs to catch the return of the Word application (user giving focus to access). It should then execute the already explained code.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    8300' in the Colorado Rocky Mountains
    Have you tried Shell and Wait?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Replies: 1
    Last Post: 03-28-2011, 02:34 PM
  2. Replies: 1
    Last Post: 03-24-2011, 07:25 PM
  3. How do I detect new records.
    By jcollins in forum Programming
    Replies: 3
    Last Post: 03-17-2011, 03:48 PM
  4. Replies: 0
    Last Post: 08-17-2010, 12:44 PM
  5. stored procedure return value to access form
    By rbw940 in forum Programming
    Replies: 0
    Last Post: 10-13-2008, 01:31 PM

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 - Senior Forums