G
Guest
in VBA how do I use a sql statement to obtain data? How do I create a record set?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Adrian Jansen
Recordset occurs as both DAO and ADO. You probably want DAO, use
Dim rs as DAO.Recordset
Also your SQL needs a semicolon to end:
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Employee;")
--
Regards,
Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control
Dim rs as DAO.Recordset
Also your SQL needs a semicolon to end:
Set rs = CurrentDb.OpenRecordset("SELECT * FROM Employee;")
--
Regards,
Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control