Email Error/Bug using Microsoft Access/Outlook

[MarrowGenx]

I would like to see the errors that my client is receiving asap. I was thinking it would be possible to make the vba code to send me an email with all the relevant module and error information.

What I would like for the code to do is first check to see if Microsoft Access is open. If not, open the application. After the application is open, I would like for an email to be sent through the users account with detailed error information (i.e. module in which it occured, error number, error description, line of code (dont know if this is possible)) to my email address.

Has anyone done this and if so, can i see the code for it, so I can implement it in my DB?

Marrow

 

[FancyPrairie]

I created a library routine that logged all error messages to a table along with other pertanent info (i.e. module in which error occurred, err.number, err.description, CurrentUser, etc.). I then use the SendObject method to email me the information (could be a string or report, whatever). So, check out the SendObject method.