Results 1 to 8 of 8
  1. #1
    n9uns is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    6

    Pause macro, update tables manually, resume macro

    Hi all,

    I'm working on a macro that opens an excel workbook and pastes query results to certain areas in a tab of said workbook. Somewhere in this process, I have an OpenTable step followed by a function that opens two workbooks. I need the macro to pause while the user does their thing with the two workbooks and OpenTable, then resume after the user is done. Any ideas?

    Thanks

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    How about displaying a Msgbox?

  3. #3
    n9uns is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    6
    I'm open to a MsgBox and actually considered it but doesn't the MsgBox sit on top of other applications preventing the user from making the necessary changes?

    Thanks

    Quote Originally Posted by aytee111 View Post
    How about displaying a Msgbox?

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    They can move it out of the way if that is the case. Worth a try!

  5. #5
    n9uns is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    6
    As long as the user can work in access with the messagebox up then I will give it a shot. Thanks.

  6. #6
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    When you said "while the user does their thing with the two workbooks" I assumed that was Excel. Access doesn't have workbooks so I must have misunderstood. No you can't have a MsgBox up and continue to work in Access. You need a trigger of some kind, maybe the user can click on a button.

  7. #7
    n9uns is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    6
    I misspoke, my apologies. I was trying to say as long as the user can work in access. Are you referring to a button on a form or something similar?

    Quote Originally Posted by aytee111 View Post
    When you said "while the user does their thing with the two workbooks" I assumed that was Excel. Access doesn't have workbooks so I must have misunderstood. No you can't have a MsgBox up and continue to work in Access. You need a trigger of some kind, maybe the user can click on a button.

  8. #8
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Yes. You can pause Access for x number of seconds, but you won't know when the user is actually finished and wants to move on to the next step. The user will have to trigger that themselves, such as a button that they click on to say - continue with the rest. The button will start up the second part, which in fact will be a second macro. If the user is involved in this then it isn't automated anyway.

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

Similar Threads

  1. How do you add a pause in a macro
    By RickK in forum Macros
    Replies: 2
    Last Post: 06-02-2016, 03:36 PM
  2. To pause macro until function is finish
    By mercapto in forum Programming
    Replies: 7
    Last Post: 04-07-2014, 01:37 PM
  3. Pause macro so CMD can run
    By shank in forum Macros
    Replies: 4
    Last Post: 01-16-2014, 06:07 PM
  4. Replies: 4
    Last Post: 01-10-2014, 01:20 PM
  5. Manually record a macro
    By Triscia in forum Macros
    Replies: 3
    Last Post: 09-27-2013, 09:29 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