Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This worked for me.
Sub MyQuery() Dim db As Database Dim qdf As QueryDef Set db = OpenDatabase("c:\temp\db1.mdb") Set qdf = db.QueryDefs("Query1") qdf.Parameters("[Div]") = "Pants" Set rst = qdf.OpenRecordset() Debug.Print rst("Div") End Sub Hth, Merjet |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Type Mismatch: array or user defined type expected | Excel Programming | |||
Type mismatch using rnge as Range with Type 8 Input Box | Excel Programming | |||
Help: Compile error: type mismatch: array or user defined type expected | Excel Programming | |||
type mismatch | Excel Programming | |||
Type mismatch? | Excel Programming |