Database Discussion - I could use some access help

Print Page | Close Window

I could use some access help

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16580
Printed Date: 29 March 2026 at 4:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: I could use some access help

Posted By: wingking
Subject: I could use some access help
Date Posted: 16 September 2005 at 10:52pm

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

Replies:

Posted By: wingking
Date Posted: 17 September 2005 at 1:52am

never mind folks, I see my own mistake now. sheesh I better go to bed.