Error-Handling help needed

[vbJupiter]

How do you do an Access/VBE split screen? I want to be able to watch the code execute as I enter data into the form.

I have redesigned a database, essentially building a new one from scratch. I have all of the forms created and they are working beautifully. Now, I'm error-handling to create user-friendly messages. I have a superb Access programming book, but it only briefly mentions error handling and doesn't describe at all how to do it. Most of my forms are pretty simple, and I've been able to complete all of the error-handling tasks using the Form Error event as well as coding other events with the error message number. However, the main form is complex and includes a function in a standard code module and a custom sub routine.


TIA!
AA

 

[gemma-the-husky]

sounds like you've done it all.

you can either trap errors with an on error goto etc, as you probably have done.

You can have a general form error, set with the form event, to trap any other unexpected errors.

You can still test the error with the err object (err.number and err.description). There are some access constants though that you need to hanle the error, as the format for form errors is slightly different. Check out acdataerrcontinue in help, and go from there.

 

[vbJupiter]

Thank you Gemma. I'm glad I have this figured out now. I can't believeI've been able to get along without this knowledge so far Woe is me for all the time I've wasted troubleshooting in the dark! It's cool how you can view the locals window in addition to the immediate window as well. I will be relying a lot less on debug.print from now on

AA