Solved

Error Number Meaning? What is Error 0?

Posted on 2004-08-25
9
163 Views
Last Modified: 2010-05-02
I have put some error handling into my app.  The bad news is that I can't get in anymore.  I get the error message from my error handler Error number 0, Error message: A critical error has occured.

What is going on?  Is there a place I can find out what the error numbers mean?  Something more specific.
0
Comment
Question by:mlcktmguy
  • 2
  • 2
  • 2
  • +2
9 Comments
 
LVL 85

Expert Comment

by:Mike Tomlinson
ID: 11899554
If you post some of your code that has the error handling in it, perhaps we can spot the problem.

Idle_Mind
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 11899576
I appreciate the offer but I was able to locate the error in the code.

I am interested in finding a somewhere that lists the error numbers and the reasons behind them?  I have a book that listed the file handling errors and the reason they would be generated.  I built this into the error handling routine but don't know where to find a description to relate to the other error numbers.
0
 
LVL 85

Accepted Solution

by:
Mike Tomlinson earned 60 total points
ID: 11899589
They are all in the help file under "Trappable Errors".

Idle_Mind
0
ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

 
LVL 2

Expert Comment

by:x50Fade
ID: 11899909
Just a thought...this might not be a self raised error that you are catching...?
0
 
LVL 18

Assisted Solution

by:JR2003
JR2003 earned 65 total points
ID: 11901286
Error 0 means you have NO error.
Have a look at your code.
Is it possible you are going into your error catch routine when there is no error???

You should have something like this in each function. The GoTo SkipTrap skips the error trapping if there is no error.:

Private Function GeneralFunction()

   On Error Goto Trap

'Code main body of function here:
'
'
'
'
'
    GoTo SkipTrap
   
Trap:
   
    Screen.MousePointer = vbDefault
   
    Dim iResult As VbMsgBoxResult
    With Err
        iResult = MsgBox("Error: " & .Number & vbNewLine & _
                "Description: " & .Description & vbNewLine & _
                "Source: " & .Source, vbAbortRetryIgnore Or vbExclamation, "Error")
        If iResult = vbRetry Then
            Resume
        ElseIf iResult = vbIgnore Then
            Resume Next
        End If
    End With

SkipTrap:

End Function
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 11901774
One thing is missing from JR2003 code and probably from your code too.

Just before the Trap: label, you need to exit the function or method:

    Exit Function
Trap:
0
 
LVL 18

Expert Comment

by:JR2003
ID: 11903049
emoreau,
It is NOT missing from my code.
There is a line saying "GoTo SkipTrap" just before the "Trap:" label!
JR
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 11903483
You are right JR2003. I didn't saw that.
0
 
LVL 1

Author Comment

by:mlcktmguy
ID: 11903717
Since thisis really a two part question I am going to split the points between Idle Mind and JR2003.  
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

772 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