Icon: Trouble Errors

In a program as complex as Access, there are many ways to make a mistake!

What will happen?

Error Codes

Access has a number of error codes that it can display instead of a value when something is wrong.

Error Message Boxes:

If your typing is not EXACTLY right, you may see one of several possible error messages. Some of these messages are helpful, but others just announce that there is a problem... somewhere! For most of these errors, Access refuses to accept your expression.

Invalid syntax
Probably a missing operator, punctuation, bracket ([), quote(") or ampersand (&), but there are many other mistakes that generate this error message.
Message: The expression you entered contains invalid syntax.  

Invalid bracketing 
At least this message actually points out where the error is!
  Message: Invalid bracketing  
Undefined function
Mis-spelling a function is a really big error!
Message: Undefined function

Enclose function arguments in parentheses
Leaving off the first parenthesis generates this error.
Message: Enclose function arguments in parentheses

Message: Invalid String
Access refuses to accept what you typed for the expression. Your expression probably left out a closing double-quote.

Wrong number of arguments
Missing a required part of a function
  Message: Wrong number of arguments

Missing a closing parenthesis, bracket, or vertical bar
Not so helpful!
Message: Expression is missing a parenthesis, bracket, or vertical bar.

Unexpected parameter dialog appears.
Dialog: Parameter - missing value
This is not a planned parameter dialog! It is caused by an error.

In this example, either the field name FullName is mis-typed or there is a record for which the query cannot calculate FullName.

Lessons Databases Appendix

Teachers: Request permission to use this site with your class
Copyright 1997-2012 Jan Smith   <jegs1@jegsworks.com>
All Rights Reserved

Icon: DonwloadIcon: CDWant a local copy with no ads? - Download/CD

Want to help?

~~  1 Cor. 10:31 ...whatever you do, do it all for the glory of God.  ~~

Last updated: 30 Apr 2012