When working with errors that have descriptions that contain place holders
for object names, is there a way to retrieve the object name involved?

I have a custom error handler that displays a custom error message by
passing several parameters into a function to return a consistently formated
string for the error message...and avoid having to change millions of lines
of code if the message needs to be modified. When I pass in error such as
3200, I would like to return a complete message with the missing information.
The standard error message function uses AccessError() to get the error
description.

The record cannot be deleted or changed because table '|' includes related
records.

Use the Source property of the Err object
See the Object Browser for more info.
--
Dave Hargis, Microsoft Access MVP


"dch3" wrote:

> When working with errors that have descriptions that contain place holders
> for object names, is there a way to retrieve the object name involved?
>
> I have a custom error handler that displays a custom error message by
> passing several parameters into a function to return a consistently formated
> string for the error message...and avoid having to change millions of lines
> of code if the message needs to be modified. When I pass in error such as
> 3200, I would like to return a complete message with the missing information.
> The standard error message function uses AccessError() to get the error
> description.
>
> The record cannot be deleted or changed because table '|' includes related
> records.

Thank you and thank you for warning the Earth on its impending
self-destruction.

"Klatuu" wrote:

> Use the Source property of the Err object
> See the Object Browser for more info.
> --
> Dave Hargis, Microsoft Access MVP
>
>
> "dch3" wrote:
>
> > When working with errors that have descriptions that contain place holders
> > for object names, is there a way to retrieve the object name involved?
> >
> > I have a custom error handler that displays a custom error message by
> > passing several parameters into a function to return a consistently formated
> > string for the error message...and avoid having to change millions of lines
> > of code if the message needs to be modified. When I pass in error such as
> > 3200, I would like to return a complete message with the missing information.
> > The standard error message function uses AccessError() to get the error
> > description.
> >
> > The record cannot be deleted or changed because table '|' includes related
> > records.

The earth is not going to self destruct.
I am going to ordr Gort to destroy the earth if its inhabitants become a
threat to the universe.
--
Dave Hargis, Microsoft Access MVP


"dch3" wrote:

> Thank you and thank you for warning the Earth on its impending
> self-destruction.
>
> "Klatuu" wrote:
>
> > Use the Source property of the Err object
> > See the Object Browser for more info.
> > --
> > Dave Hargis, Microsoft Access MVP
> >
> >
> > "dch3" wrote:
> >
> > > When working with errors that have descriptions that contain place holders
> > > for object names, is there a way to retrieve the object name involved?
> > >
> > > I have a custom error handler that displays a custom error message by
> > > passing several parameters into a function to return a consistently formated
> > > string for the error message...and avoid having to change millions of lines
> > > of code if the message needs to be modified. When I pass in error such as
> > > 3200, I would like to return a complete message with the missing information.
> > > The standard error message function uses AccessError() to get the error
> > > description.
> > >
> > > The record cannot be deleted or changed because table '|' includes related
> > > records.