Search:     Advanced search
Browse by category:
Glossary | Contact Us

Database Knowledge Base / MS Access / Where can I obtain a list of Access Basic Errors and their associated messages

Where can I obtain a list of Access Basic Errors and their associated messages

Add comment
Views: 224
Votes: 3
Comments: 0
All Versions: From Access itself, simply write a function that loops around each error number, e.g.
For e = 1 to 9000
  Debug.Print e; " - "; Error(e)
Next

Bear in mind a lot of these are "User Defined Error" or "Reserved Error", you may want to filter these out with an "If" or "Select Case" structure in your function, alternatively you can write each number & message to a text file or Access table .
Others in this Category
document When compacting an Microsoft Access database how do you control the ownership of the database?
document How can I make my combo and list boxes faster?
document How do I access the recordset of a SUBform. I know how to clone the set of a form, but this doesn't work for subforms.
document How do I emulate the "Record X of Y" that Access displays in the navigation buttons
document How do I run an internal DOS command from within Access Basic, if I try x=Shell("copy file1 file2",1) I get a message "File not found".
document How we can perform MINUS (Oracle) Or EXCEPT (Maxdb) in MS Access?
document What is Data Mapping
document What is an Ad Hoc Query?



RSS