Solved

Error Handling Routine not being invoked

Posted on 2011-02-24
17
337 Views
Last Modified: 2012-05-11
See code below
Note the statement ;On Error GoTo Form_Load_Err:

I am testing the VBA and have removed a table that is in the query qryFillSuppGroup2.  The system crashes with an error 3078 (which is an appropriate error).

The question is : Why is my error routine not invoked?

I am new to this!

Private Sub Form_Load()

On Error GoTo Form_Load_Err:

DoCmd.OpenQuery "qryFillSuppGroup2"
Exit Sub

Form_Load_Err:

MsgBox "ERROR...."

End Sub

Open in new window

0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 5
17 Comments
 
LVL 75
ID: 34973976


On Error GoTo Form_Load_Err
Remove colon                         ^^

mx
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34973978
try removing Exit Sub
0
 
LVL 75
ID: 34974001
Actually ... the Colon is not really a problem ... and, the code does work for me as is ....

mx
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 34974025
Something else is going on.  Do you have code elsewhere..

And if you remove the Exit Sub ... you will *always* get the Error message - even when there is no error.

mx
0
 

Author Comment

by:Patrick O'Dea
ID: 34974042
See attached.
Click form Mainmenu.

Then click "Master Screen".

The system will crash.

Why is the On Error not invoked?
DerekImport--3-.zip
0
 
LVL 75
ID: 34974115
No crash.  "pop" appears as expected.

mx
0
 
LVL 75
ID: 34974144
Tested on both A2003 and A2010 ...

mx
0
 
LVL 75
ID: 34974175
I Decomplied, Compacted & Repaired ... see if you still have issue.

mx
DerekImport-MX01.zip
0
 

Author Comment

by:Patrick O'Dea
ID: 34974265
...

Let me simplify.

I have placed the line x=x/0 and this is not being caught by the On error.

Surely a divide by zero should be caught?
DerekImport--4-.zip
0
 
LVL 75
ID: 34974341
The  error *is* caught on my systems ...  see image.
Possibly there is a problem with your Access installation ?
Did you try the MX01 version I uploaded ?

mx
Capture1.gif
0
 

Author Comment

by:Patrick O'Dea
ID: 34974502

Thanks again ,

I tried your MX01 problem but still have the same error.

Incidentally, how do I de-compile??

I had an error a few days ago that did not make sense too.
I wonder is my Access version (recent 2010) okay?
Perhaps, my "Access Options" need to be looked at??

See brand new database5 attached.

Nothing in it except one form with one button which calls VBA.
This VBA error handling does NOT catch the divide by zero.

Any thoughts?



Database5.mdb
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 34974554
The only options I can think of are on the  right side of the Image ... VBA>>Tools>>Options.

Mainly ... Break on Unhandled Errors ..

mx
Capture1.gif
0
 
LVL 75
ID: 34974580
Decompile - For Reference:
>>>>
But first, if you have not already:
Open the VBA Editor and from the menu ...Tools>>References ....
If you see any listed as **Missing: <reference name>, including the asterisks and the word Missing, the
you need to fix that first.

Then, follow this procedure:

****
0) **Backup your MDB BEFORE running this procedure**
****
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
Close the mdb after the Compact & Repair.
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Close the mdb.
6) Open the mdb:
    a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
    b) From the VBA Editor Menu at the top of the window:
       >>Debug>>Compile
        Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.

7) Close the mdb
8) Compact and Repair one more time.

*** Executing the DeCompile **EXAMPLE**:
Here is an **example** of the command line syntax  (be SURE to adjust your path and file name accordingly) before executing the decompile:

Run this from Start>>Run, enter the following command line - **all on one line** - it may appear like two lines here in the post:
Also, the double quotes are required.

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile "C:\Access2003Clients\YourMdbNameHERE.mdb"

For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:

http://www.trigeminal.com/usenet/usenet004.asp?1033

mx
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 34974633
Oh dear,,

You are 100% correct.

I changed this option a few days ago while tring to resolve a previous problem.

All in fine.

Thanks again and apologies for the time wasting.
0
 
LVL 75
ID: 34975214
No time wasted.  So, how were the options set then ?

mx
0
 

Author Comment

by:Patrick O'Dea
ID: 34975376
I had it set to "Break on All Errors".

Ironically this setting was made to investigate the other query (which you have just solved).

It has been an evening of me trying to make complications where the actual problem is trivial.

Still, I'm learning!

Thank you and goodnight from Ireland!
0
 
LVL 75
ID: 34975441
ok ... no problem.

mx
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question