• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Is It a Parameter or a Typo?

You've created a simple select query without parameters, but when you run it, Access displays an Enter Parameter Value dialog box. Regardless of what you enter, the query doesn't work properly.

This problem is almost always caused by a typo in a field name. Field names and parameters both appear inside brackets. If you misspell a field name, especially in an expression used with a calculated field, Access can't find the field and therefore assumes you want to display a parameter dialog box. Go through every expression in the query and see whether you can find (and fix!) the typo.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint