Append Query

[Antonio]

I am attempting to make a form that will supply parameters to an Append Query.
The form is called “frmTIPS†and it contains an Unbound text box called
“txtDOVâ€.
The query is called “qryAMSched†and among the fields in the query is a
field called “DateOfVisitâ€.
I set the Criteria for the “DateOfVisit†field to
[Forms]![frmTIPS]![txtDOV]

However, whenever I run the query (I plan on placing a button on the form to
execute the query) I get an error message that reads
“Numeric Field Overflowâ€

Now, if I change the criteria to [Enter Date Of Visit] and have the user
manually type in the date (mm/dd/yy)…the Append Query works fine.
If I manually type in #11/5/2004#...the query works fine..
I don’t know what I am doing wrong…

 

[Joan Wild]

I am attempting to make a form that will supply parameters to an
Append Query. The form is called "frmTIPS" and it contains an Unbound
text box called "txtDOV".
The query is called "qryAMSched" and among the fields in the query is
a
field called "DateOfVisit".
I set the Criteria for the "DateOfVisit" field to
[Forms]![frmTIPS]![txtDOV]

Try setting the format property of the txtDOV control on the form to short
date, so that Access knows it's a date.

Also you might try specifying the data type in the query for the parameter.
In design view, Query, Parameters and put
[Forms]![frmTIPS]![txtDOV] as the parameter and set the datatype to
Date/Time.