How to document error analysis and debuging in Access

[snoopy]

Hi there,



I do some error analysis for debug an Access DB. My question is are there some regulations or frameworks, which could support my work. It would be grateful if someone could give some advises.

Thanks

[rpeare]

I'm not sure what you're asking if you're looking for an error trap this is what I use:

at the beginning of my code, after variables have been declared:

ON ERROR GOTO ERRHANDLER

then at the end of my code, before the end sub:

Exit Sub
ERRHANDLER:
debug.print err.number & " " & err.description
End Sub

if I want my script to continue after the error I also include after the debug.print statement:

resume next

[orange]

I have no idea what exactly you are asking either.

For info on how to debug, see http://www.cpearson.com/excel/debug.htm

If it is a question of inserting ErrorHandling code, then download the free vba utility MZTools for vba