I could use some access help

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I inherited a application to work on. unfortunetly it is using access as a db and I forgot more than I ever knew about access, yes that means I know less than nothing.
here is the problem I am getting a type mismatch when tring to add a field. it is a general date field in access.
below is the related code. it is two pages, a forms page and a add page.
please see if you can tell me how to convert the request so access sees it as a date.

form page

autime = FormatDateTime(Date, 0)
autime = autime & " "
autime = autime & FormatDateTime(time, 3)
aucsttime = Request("aucsttime")
if len(trim(Request("aucsttime"))) > 0 then
timenow = timenow
else
timenow = autime
end if

Response.Write "<INPUT TYPE=""HIDDEN"" NAME=""aucsttime"" Value=""" & timenow & """>"

    Response.Write "<TR>" 
    Response.Write "<TD>" & gsLabelOpen & "Start Time" & gsLabelClose & "</TD>" 
    Response.Write "<TD><INPUT TYPE=""TEXT"" NAME=""aucsttime"" SIZE=""40"" MAXLENGTH=""255"" value=""" & timenow & """></TD>" 
    Response.Write "</TR>"

post page
aucsttime = Request("aucsttime")
rsAuc("aucAvailDate") = aucsttime

thanks in advance for any help