[thelist] MS Access to SQL Server: METAFILE Images (LONG!)
Janet Nabring-Stager
jnabring at yahoo.com
Fri Sep 28 10:04:49 CDT 2001
You all are great :)
But sadly, it's still not working :(
For the record, someone posted about SQL and Access. I am using a
database in Access. This is what I have to work with.
I've tried the <%=FormatDateTime(rs.datefield,vbLongDate)%>, but it's
throwing an error message. That error message is: "Microsoft
VBScript runtime error '800a01b6' Object doesn't support this
property or method:'Date_of_Issue'/search.asp, Line 177
Line 177 is: <% Do While Not rs.EOF %> <option value="<%=
FormatDateTime(rs.Date_of_Issue,vbLongDate) %>">
Originally, Line 177 was: <% Do While Not rs.EOF %> <option
value="<%= rs("Date_of_Issue") %>"> (and this worked to populate the
dropdown from the Access database).
I also tried: <% Do While Not rs.EOF %> <option value="<%=
FormatDateTime(rs("Date_of_Issue"),vbLongDate) %>">
This threw MS VBScript runtime error '800a000d' Type
Mismatch:'FormatDateTime'/search.asp, line 177
So, I thought it was because I didn't have the adovbs.inc file
included, so I copied it (just to be 100% certain!) into my folder
and had the beginning of my code now read:
<%Option Explicit%>
<!-- #INCLUDE file = "adovbs.inc" -->
<!-- METADATA TYPE="typelib"
FILE="C:\Program Files\Common Files\System\ado\msado15.dll" -->
Now, this error comes up:
Microsoft VBScript runtime error '800a0411'
Name redefined: 'adOpenForwardOnly'
/adovbs.inc, line 14
So I thought there could be a conflict between the msado15.dll and
the adovbs.inc files, so I took out the reference to the msado15.dll
file and we're back to this error:
This threw MS VBScript runtime error '800a000d' Type
Mismatch:'FormatDateTime'/search.asp, line 177
Am I completely missing something (which is all too entirely
possible?) I really do appreciate the help and apologize for the
long message, but I didn't want you all to think I was making you do
my work for me - I really did try to make this work!
TIA-
=====
Janet Nabring-Stager
http://www10.ewebcity.com/jnabring
__________________________________________________
Do You Yahoo!?
Listen to your Yahoo! Mail messages from any phone.
http://phone.yahoo.com
More information about the thelist
mailing list