[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