"Enter Parameter Value" error

[Shaun Rucker]

I am working on normalizing a database that has a switchboard that leads to
multiple forms that have individual queries behind them. Each query (and in
turn, form) uses many of the same fields; however, the designer created a
different field for each query. For instance, instead of just "Amount",
there are 8 different Amount fields (one for checks, one for wires, one for
posting documents, etc.) So, I am re-aligning everything to use the same
fields wherever possible.

Now for my problem. On one of the queries, I changed it to align with my
new field names. I also changed the name of the query and form. On the
switchboard, there is a button to open each form. I went in to the Visual
Basic code for the button that opens this form and changed it's name; all I
changed was the name and i copied and pasted it to ensure accuracy.

But, now when I click the open button, it gives me a pop up box that says,
"Enter Parameter Value: qry Write Off.Date" and has a space to enter text. I
know usually, this means that the form is trying to pull up a field that
doesn't exist or that isn't in the query. However, I made sure that only
valid fields are on the form and query. There are no fields that should not
be there and that are not valid. If I click "OK" on the pop up, it goes to
the form and everything is peachy. However, I need to get rid of this error.


Help please!

 

[G. Vaught]

Recheck your query for Expr1 entry. You can also check the Parameters
located under the design query menu, it may have been entered there. Check
also in the form that the query that runs the form does not have a filter
using that field that is called up.

 

[Shaun Rucker]

It doesn't. There is not such "expression". I have 23 fields in my query
and 23 fields on m form. Each points to a single field from the query.

 

[Douglas J. Steele]

Sounds as though you're using Date as the name of a field in your query (or
the underlying table). You shouldn't: Date is a reserved word, and shouldn't
be used for your own purposes.

If you cannot (or will not) rename the field, at least put square brackets
around its name in the SQL for the query. Go into the SQL view (you can get
to it through the View menu when the query's open), and change

[qry Write Off].Date

to

[qry Write Off].[Date]

 

[Shaun Rucker]

I do have a field called "Date". Oddly enough, I tried changing it to
"Date Received" and it made all of my other forms react the same as this
one. If I clicked on one of the buttons to open a form, it would give
me the same error message as the form in my original question. When I
changed it back to "Date", the other forms went back to working
perfectly. Putting brackets around the "Date" field in the SQL
statement made no difference.

I guess to add clarification, my query was called "qry Write Off" and I
changed it to "qryBP to GL"; the form was called "frmWrite Off Table"
and I changed that to "frmBP to GL Table".

So, with the error message asking for "qry Write Off.Date", it makes it
look like there is a field from the original query that it is still
looking for. However, it is not. I changed each field in the query and
have checked multiple times to ensure that there are no other fields. I
have also ensured that each text box on my form is pointing to a valid
field from the query.

Sounds as though you're using Date as the name of a field in your query (or
the underlying table). You shouldn't: Date is a reserved word, and shouldn't
be used for your own purposes.

If you cannot (or will not) rename the field, at least put square brackets
around its name in the SQL for the query. Go into the SQL view (you can get
to it through the View menu when the query's open), and change

[qry Write Off].Date

to

[qry Write Off].[Date]

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I am working on normalizing a database that has a switchboard that leads to
multiple forms that have individual queries behind them. Each query (and
in
turn, form) uses many of the same fields; however, the designer created a
different field for each query. For instance, instead of just "Amount",
there are 8 different Amount fields (one for checks, one for wires, one
for
posting documents, etc.) So, I am re-aligning everything to use the same
fields wherever possible.

Now for my problem. On one of the queries, I changed it to align with my
new field names. I also changed the name of the query and form. On the
switchboard, there is a button to open each form. I went in to the Visual
Basic code for the button that opens this form and changed it's name; all
I
changed was the name and i copied and pasted it to ensure accuracy.

But, now when I click the open button, it gives me a pop up box that says,
"Enter Parameter Value: qry Write Off.Date" and has a space to enter text.
I
know usually, this means that the form is trying to pull up a field that
doesn't exist or that isn't in the query. However, I made sure that only
valid fields are on the form and query. There are no fields that should
not
be there and that are not valid. If I click "OK" on the pop up, it goes
to
the form and everything is peachy. However, I need to get rid of this
error.


Help please!