About Jeff Allen Expertise I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.
Experience I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.
Organizations IWA-HWG
Education/Credentials I have a BA in English with minors in Web Design and Scientific and Technical Writing
Expert: Jeff Allen Date: 9/15/2006 Subject: data type mismatch
Question I am receiving this following error message for this particular section of code. I am working on some ASP pages for an Access database. The only problem I can see is possibly that the FormID is listed as Autonumber in the Access database and I think the replace funtion is looking for a string variable. Any suggestions on what the problem may be? Line 57 is in bold.
[B]Error Message:[/B]
Technical Information (for support personnel)
Error Type:
Microsoft JET Database Engine (0x80040E07)
Data type mismatch in criteria expression.
/hawksnest/form22/approver.asp, line 57
%>
<%
Dim rsAccept__MM_ColParam
rsAccept__MM_ColParam = 1
If (Request.QueryString("FormID") <> "") Then
rsAccept__MM_ColParam = Request.QueryString("FormID")
End If
%>
<%
Dim rsAccept
Dim rsAccept_numRows
