R
Richard
I have a form that has 2 hidden fields, date and time.
When I submit the form, the data is successfully updated
in the database. If I resubmit the same form within the
same session, I get a database error:
"Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide
default values for all form fields that are used in the
query."
This is telling me that the Date and Time hidden fields
are empty. The html code for these fields are the form is:
<input type="hidden" name="PickDate" value="<%= Date() %>">
<input type="hidden" name="PickTime" value="<%= Time() %>">
And ideas why this would work the first time in a session,
and not subsequent times?
When I submit the form, the data is successfully updated
in the database. If I resubmit the same form within the
same session, I get a database error:
"Description: Data type mismatch in criteria expression.
Number: -2147217913 (0x80040E07)
Source: Microsoft JET Database Engine
One or more form fields were empty. You should provide
default values for all form fields that are used in the
query."
This is telling me that the Date and Time hidden fields
are empty. The html code for these fields are the form is:
<input type="hidden" name="PickDate" value="<%= Date() %>">
<input type="hidden" name="PickTime" value="<%= Time() %>">
And ideas why this would work the first time in a session,
and not subsequent times?