+ Reply to Thread
Results 1 to 3 of 3

On Error Restart Application and continue function

  1. #1
    Registered User
    Join Date
    09-29-2014
    Location
    TIjuana, Mexico
    MS-Off Ver
    MSO 2010, MSO 2013
    Posts
    53

    On Error Restart Application and continue function

    Hello, I'd like to know if there's a way to make Access to continue executing the function where it left after I made it close the application (I found a procedure that already does the quit application command), but how do I tell Access to resume the function where it was?

    Thanks in advance

  2. #2
    Forum Contributor
    Join Date
    01-18-2010
    Location
    Bentley, NM
    MS-Off Ver
    Excel 2010
    Posts
    229

    Re: On Error Restart Application and continue function

    I wonder if you could set a variable or something. Right before the app exits set Variable1 = 1. Make sure to set Variable1 to something other than 1 if the app does not exit and continues with the function. Then when you re-open the database IF Variable1 = 1 Then continue with the function otherwise operate as normal.

  3. #3
    Registered User
    Join Date
    09-29-2014
    Location
    TIjuana, Mexico
    MS-Off Ver
    MSO 2010, MSO 2013
    Posts
    53

    Re: On Error Restart Application and continue function

    Hi maw230, in the end I just needed to end the function and return to the form, no restarting was needed, that solved my problem. Thanks anyway.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trying to use the application object with the match function, getting error 2015
    By cmurda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2014, 03:42 PM
  2. Having macro continue to run when Excel isn't the active application
    By CptPeanuts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2012, 04:42 PM
  3. Application Error 1004 on Search Update Function
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-30-2011, 08:40 AM
  4. Object Required error on Application.Match function.
    By ctckark1 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-12-2011, 11:01 AM
  5. Application Worksheet Function Error
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-22-2010, 09:24 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1