| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open Access recordset via Query in Excel VBA???
I thought those were ENUM's.
Hexman On 29 Mar 2006 05:44:01 -0800, "Kletcho" wrote: You needed values for each of those properties instead of the name of the property. Set rstIn = db.OpenRecordset("SortPPX", dbOpenSnapshot, dbSQLPassThrough, dbReadOnly) should have read Set rstIn = db.OpenRecordset("SortPPX", True, False, False) or whatever it is you wanted for those properties. They are optional though and most times you don't need them. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Access Recordset Rows to Excel | Excel Programming | |||
| How to populate Excel Range from Access RecordSet? | Excel Programming | |||
| Acquiring a single recordset from Access into Excel | Excel Programming | |||
| Copy recordset from an Access "make table" query | Excel Programming | |||
| open range (within workbook) as ado recordset - excel vba | Excel Programming | |||
Threaded Mode
