Error codes (Access XP)

Topic

New Reply

While writing something this morning, I got the familiar

Run-time error XXXX

I solved the problem, but the error message is about as much use as a chocolate teapot. Is there a central list of these codes which can be downloaded, so that it is easier to debug in the future?

Thanks

Reply | Quote

Replies

I don’t know of a complete and really useful overview, but here are some tips:

– Activate the Visual Basic Editor (Alt+F11)
– Activate the Immediate window (Ctrl+G)
– Type OpenForm and press F1.
– This opens the online help with the relevant bits available (long live HTML help – NOT)

– Type trappable in the Answer Wizard tab of the help window and press OK.
– The Trappable Errors subject lists generic VBA error numbers. Click on an error for more info.

– Type number error in the Answer Wizard and press OK.
– Select Number Property (DAO), then click Trappable Microsoft Jet Errors.
– This lists DAO errors. Click on an error for more info.

– Type ADO error in the Answer Wizard and click OK.
– The ErrorValueNum subject lists ADO errors.

The attached database contains an empty table. If you run the procedure FillErrorTable in the basErrors module, the table will be populated with a list of error numbers and the accompanying error message.

Reply | Quote

Great

I think i’ll need an hour or so to look at that. I’ll try over the weekend.

Thanks

Colin

Reply | Quote

Great

I think i’ll need an hour or so to look at that. I’ll try over the weekend.

Thanks

Colin

Reply | Quote