I think you can just write
Set recsetEmployees =
dbEmployees.OpenRecordset("Select * from employees where age > 30",
It looks like you are using a data control. I find them more trouble
than they are worth, except for very simple database access. They are
good for beginners and allow you to get something going quickly but you
soon grow out of them when you try to do anything more complicated.
From: Mark Mchugh [mailto:mark_mch@stripped]
Sent: Wednesday, 16 November 2005 2:17 AM
To: mysql list
Subject: DAO with mysql 5.0
I am using the following code
Set dbEmployees = OpenDatabase("", dbDriverComplete,
Set Data1.Recordset = recsetEmployees
is there anyway to have a DAO recordset that i can
define the sql?
i.e. "Select * from employees where age > 30"
Yahoo! FareChase: Search multiple travel sites in one click.