Search results for query: *

I am missing something. I am using VBS in ASP querying a ACCESS2000 database. MyVar = DCount("*","tblCHGLOG) returns DCount not defined.I assumed DCount was some Jet function. Thanks again for any advise.

I am trying to use the count function. SELECT COUNT(*)FROM tblCHGLOG Where is the world is the count? How can I specify a variable for it to be placed into for later processing. Thanks in advance

I have a table tblChangeRecords with lots of fields. Most are two words. I want to reference the record via an ordinal. Below is a query to the database. How do I reference ordinal 1 for instance. "SELECT * FROM tblChangeRecords" Thanks in advance

Yes it gives and unknown database error when trying to access it.

I am using Visual InterDev and Access97/access2000. I have the following database connection I add to all .asp pages via an include. I want to switch to 2000 and have problem with connection. <%Dim objConn 'declare your variable to hold your connection Set objConn =...

I am using Visual InterDev and access97/access2000. I have the following database connection I add to all .asp pages via an include. I want to switch to 2000 and have problem with connection. <%Dim objConn 'declare your variable to hold your connection Set objConn =...

Ok what if I want to do a range of dates. Like indate1 and indate2. I find help your wuite refreshing. I have tried for three days to wokr this out. I am a mainframe assembler programmer.

I am using VBA ASP pages to access an ACCESS database. I am having problems using dates. My code is as follows, indate comes from a form. indate=trim(request.form(&quot;indate&quot;)) set RS objConn.execute(&quot;Select * FROM Dumps WHERE Date = #indate#&quot;) Any help would be great. This...