Errorhandling

[tomvdduin]

Hi all,

I want to make a table that can be used as an errorlog. I thought to save info as the current user, formname, procedure name etc. Does somebody has some experience?

greetz

Tom

 

[mp9]

In the error-handling routines that you want to populate the error log you'll need to add a line something like

DBEngine(0)(0).Execute ("INSERT INTO YourErrorLogTableNameHere (FieldName,AnotherFieldName, YetAnotherFieldName) VALUES ('Value', 'AnotherValue', 'YetAnotherValue');")

Within this construct you could use things like Screen.ActiveObject to return the active object name, Me.ActiveControl to return the name of the active control, CurrentUser to return the username of the guy who screwed up, Err.Number to return the error code and Err.Description to return the full text of the error message.

HTH to get you started.

http://www22.brinkster.com/accessory/

 

[tomvdduin]

OK, thanks, that's what I want to know. I'll let you know when I found difficulties

greetz

Tom