Restart Access using VBA?

Question

Hi. I'm using the old MSAccess which is Access 2003. I want to know if it is possible to restart Access using VBA. I've tried searching over the web but I can't find anything useful. This is to trap some errors wherein it is required to restart the application to run smoothly.

Hoping for your response.

Answer 1

Okay, so that makes sense.  What appears to be happening is that you have an unhandled error which then you go to debug and instead of sliding the yellow area down to the next line so it will bypass it and continue running you click the STOP DEBUG button and then you lose a global variable which apparently has your connection to SQL Server (or some other data source) open.

So what you need to do is to handle the errors and if you stop to debug, you can just, over on the left hand side of the VBA window, on the yellow line, drag the yellow arrow which points to the code that needs fixing down to the next executable line of code or down to the exit spot of the procedure.  Then click F5 to continue running and then go back and fix it.

To fix your code you showed, just use

If Val(Nz(txtValue, 0)) < 0 Then

...etc.

Answer 2

Seems like restarting is not an easy task. Well I just need it so that I, as a developer, will not manually restart the application. It saves my time clicking or pressing keys. Lazy stuffs right? lol

Thanks for the reply.

Regards,

Michael

Answer 3

Sounds like we should fix your code (it is that which is the problem, and restarting just obscures that).

Answer 4

I'm not sure I get what you mean by restarting because of some errors.  What errors are you experiencing?  You shouldn't have to restart Access to fix that so it would help if you gave specific error messages.

I'm using ADODB Recordset to filter and search specific records. By using "On Error Goto" Statement, I'm able to trap errors, like null strings, invalid computations, etc. Then when I resume or execute next call for query, it always show errors wherein the query will not work. Restarting the application helps.

Answer 5

I'm not sure I get what you mean by restarting because of some errors.  What errors are you experiencing?  You shouldn't have to restart Access to fix that so it would help if you gave specific error messages.