View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
 
Posts: 812
Default DAO Parameter Type Mismatch

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