Connection object vs. Opendatabse on Databaseobject
I guess the original sql was in ADO. NOT too strong in this department.
It was a query that I designed in ACCESS then copied into VBA.
The issue with the RS.MOVELAST is I am pulling more than one "event" over
time. Where the old sql would return 200 records (200 individual "events" at
their last instance), now I would get thousands of records (200 individual
events for each occurrance).
Where can I get an idea of the DAO functions available? I do not seem to
have the help files loaded on my PC. A table that showing functionality and
query types would be great.
Thank you for you help.
"NickHK" wrote:
James,
So you mean you changed from DAO to ADO ?
Last() is a DAO/Jet3.5 function from what I can tell.
You could RS.MoveLast, then read your data.
NickHK
"James McDowell" wrote in message
...
I have SQL that has worked using the Database Object and Recordset
objects.
I have switched to a connection object in place of the database object so
that I am able to define the user and password for the DSN (please do not
suggest going DSNless, can't get it to work). In my original SQL I used
the
line "Last(myDATABASE.myTABLE.myDATE) AS LastOfmyDATE". The SQL worked
fine
when I used a Database object, but I'm not sure why the connection object
does not accept the "Last" functionality. The table has the MyDATE fiels
defined as date/time and I found out earlier today that the connection
object
requires the SQL to be changed to enclose dates in single brackets. Not
sure
if it has any bearing on the subject.
I am pulling records and I need to be able to only pull the last instance
Can anyone suggest a replacement for the last.
Thank you,
Jim
|