H
Hey
I'm trying to run an append query and I'm having trouble. If I hardwire the
criteria it works fine. But as soon as I try to use a separate form I made
requesting invoice numbers from and to it bombs out with "The Microsoft Jet
database engine does not recognize "[Forms]![frmAnything]![AnyNumber]" as a
valid field name or expression."
Example: query listing ALL invoices works fine. Limit query to invoice
number 14533 will work fine as long as I put 14533 into the criteria. If I
leave that off of criteria, but input [Forms]![frmAnything]![Anynumber] into
criteria it gives me the error message. Whether I have that frmAnything
open or not.
On older queries, even if I don't have the source form open for the
criteria, it requests the specific controls when I try to run it and then
runs the query. It won't on this new one? It gives me the above error no
matter how I try to use the numbers (> first number, "between" the numbers,
etc). Yet, same numbers manually input into the criteria work fine.
Even if I switch it to another pre-existing form that asks for say client
number instead of invoice number (that works on other queries fine)...it
gives me this type of error.
I tried running same database under Access2003 and same problem.
Has Access (or, Jet) gotten screwed up? The database?
Help!
criteria it works fine. But as soon as I try to use a separate form I made
requesting invoice numbers from and to it bombs out with "The Microsoft Jet
database engine does not recognize "[Forms]![frmAnything]![AnyNumber]" as a
valid field name or expression."
Example: query listing ALL invoices works fine. Limit query to invoice
number 14533 will work fine as long as I put 14533 into the criteria. If I
leave that off of criteria, but input [Forms]![frmAnything]![Anynumber] into
criteria it gives me the error message. Whether I have that frmAnything
open or not.
On older queries, even if I don't have the source form open for the
criteria, it requests the specific controls when I try to run it and then
runs the query. It won't on this new one? It gives me the above error no
matter how I try to use the numbers (> first number, "between" the numbers,
etc). Yet, same numbers manually input into the criteria work fine.
Even if I switch it to another pre-existing form that asks for say client
number instead of invoice number (that works on other queries fine)...it
gives me this type of error.
I tried running same database under Access2003 and same problem.
Has Access (or, Jet) gotten screwed up? The database?
Help!