Re: Error Message different in MDB and MDE

From: Albert D. Kallal (PleaseNOOOsPAMMkallal_at_msn.com)
Date: 09/13/04 

Date: Sun, 12 Sep 2004 21:54:04 -0600

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:OirLisSmEHA.1520@TK2MSFTNGP10.phx.gbl...

> No, It's not the disappearance of the 'debug' and 'end' buttons
> that threw me. It's the fact that it's a completely different
> /message/. And the fact that the difference is totally undocumented.
>
> I actually have users that report the error description in some
> circumstances, and I use the error description to locate and fix
> data-dependent exceptions. How's this grab you: I thought I
> could do that.
>
> It may not be clear from the example, but Access has actually
> discarded my custom error message, and substituted a different
> one.

Hum...that is not clear?? Are you saying that if you trap the divide by zero
error, you get a deifernt results?

In other words, if we use:

Private Sub Detail_Click()

   Dim i As Integer

   On Error GoTo Myer

    i = i / 0

    Exit Sub

Myer:

   Dim im As Integer
   Dim strT As String

   im = Err.Number
   strT = Err.Description

   MsgBox "error number = " & im & vbCrLf & _
          "Description = " & strT

   Resume Next

End Sub

I find that the above reuslts in teh same mesage in a mdb, a mde, and also
when run as a runtime?

And, if you wanted to remove the "Microsoft access" title in the msgbox, and
use "your" application name,
you can use (assuming you set the application title in the startup options).

   MsgBox "error number = " & im & vbCrLf & _
          "Description = " & strT, , CurrentDb.Properties("AppTitle")
:
Perhaps some value, or some other thing is triggering yet another error
message, and you loosing the current err number/description?

I am using a2003...but I don't think results would be different for
a2000-a2003 versions. 

-- 
Albert D. Kallal   (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.attcanada.net/~kallal.msn