Access 2010 Query Parameter

Question

I am using Access 2010 and have repeatedly attempted to create a parameter prompt for the query, such as [Enter Order Number:] in the criteria box for the OrderID field.  IThe error messge is "You either have an error in your expression or you have attempted to use and undeclared parameter. " I have entered it exactly as the numerous samples I have looked at.

Answer 1

Under Design you should see VIEW on the ribbon and it's pulldown list SQL View.

Answer 2

ummmm.  The only options I have are design and datasheet views.  Thanks for your help.  ;-)

Answer 3

I never did find the option to view the SQL statement.  Where did they hide that?

In 2007 it in under Query Design - VIEW - SQL View.

Answer 4

This is a desktop database.  It has been 6 or 7 years since I have done in database programming and Access 2010 has changed things quite a bit.  While looking for the option to view the SQL, I found a button under Design titled "Parameter".  I clicked on it and wasn't sure what it wanted me to enter, but I put in my prompt and the data type, and gosh darnit, if didn't just work!

I never did find the option to view the SQL statement.  Where did they hide that?

Answer 5

Please open your query in SQL view and copy and paste the SQL text into a message here.

Is this a Web database, or a desktop database?