VBA Error Handler

[BentleyD]

I have scouered everywhere to find the VBA Error Handler. I need something
compatable with Access XP

 

[Jim Vierra]

Do you mean "On Error GoTo <label>" "On Error Resume Next"?

Access is a form of VBA and uses the same error handling techniques. Access
Forms since, I beleieve, XP have had an error event that does some of the
work by handing you the error in a code snippet. There is not really
anything directly related to it in Outlook or in other Office apps as far as
I know unless you are building a UserForm which is basically a dialog.

What particular type of Access XP error handling are you talking about?

 

[bentleyd]

It is a devlopment helper distributed in the Office XP Development CD which I
can not find in the downloads section. Here is the documentation web page:
http://msdn.microsoft.com/library/d...en-us/modcore/html/derefode_help_codecomm.asp

 

[Jim Vierra]

It doesn't do aanything unusual. It just inserts code templates into the
VBA.

Have you tried to load it in Office 2003. It might work. I don't have the
XP Developer version. I have the 2000 version but have never used these
tools. I have had error handlers for MSAccess VBA for quite awhile that I
reuse.

It looks like a handy little tool.

 

[Stephen Bullen]

Hi,

It is a devlopment helper distributed in the Office XP Development CD which I
can not find in the downloads section. Here is the documentation web page:
http://msdn.microsoft.com/library/d...en-us/modcore/html/derefode_help_codecomm.asp

FWIW, MZ Tools (www.mztools.com) includes a very similar utility.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk

 

[Jim Vierra]

That's an excellent utility for code building. It's only missing an object
progid grabber and registry walker utility. Wonder if it can convert the
old XP Dev templates.