VBA, What am I doing wrong??

What am I doing wrong??

Author	Message
Perr #1 / 2	What am I doing wrong?? Hi there you all!! A question: I'm trying to make a query in the OpenRecordset statement as follows but VB answers that there are "Too few parameters, Expected 1." Do you have any idea what I'm doing wrong?? ([CmboProjectName] is a ComboBox in my Form) Set Dbs = CurrentDb Set ActRst = Dbs.OpenRecordset("SELECT * FROM Activity WHERE (((Activity.ProjectName) = [CmboProjectName]. [Value]))", dbOpenDynaset) Thanks Perry
Fri, 25 Mar 2005 19:17:50 GMT

Ed Terlou #2 / 2	What am I doing wrong?? Perry try this, Set ActRst = Dbs.OpenRecordset("SELECT * FROM Activity WHERE ProjectName = '" & [CmboProjectName] & "'", dbOpenDynaset) a string need to be inclosed by single quotes Ed Quote: > Hi there you all!! > A question: > I'm trying to make a query in the OpenRecordset statement > as follows but VB answers that there are "Too few > parameters, Expected 1." > Do you have any idea what I'm doing wrong?? > ([CmboProjectName] is a ComboBox in my Form) > Set Dbs = CurrentDb > Set ActRst = Dbs.OpenRecordset("SELECT * FROM Activity > WHERE (((Activity.ProjectName) = [CmboProjectName]. > [Value]))", dbOpenDynaset) > Thanks > Perry
Fri, 25 Mar 2005 20:27:55 GMT

Page 1 of 1

[ 2 post ]