ACCESS FEED: RE: [MS_AccessPros] Error 3061 Too Few Parameters

Minggu, 08 September 2013

RE: [MS_AccessPros] Error 3061 Too Few Parameters

I believe you are missing the delimiters around your date value

strSQL = "SELECT * FROM [diagnosis] WHERE (CDate(StartDate))>#" & DateOfVisit & "#"

Duane Hookom MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: patty.mapes@gmail.com
> Date: Sun, 8 Sep 2013 12:09:31 -0400
> Subject: [MS_AccessPros] Error 3061 Too Few Parameters
>
>
>
> I have the following code, failing on the last line:
>
>
> DateOfVisit = CDate(Forms!Select_Diagnosis![VisitList])
>
>
> Set db = CurrentDb
> Set rs = db.OpenRecordset(Domain)
> 'select all events
>
> strSQL = "SELECT * FROM [diagnosis] WHERE (CDate(StartDate))>" &
> DateOfVisit
>
>
> If someone can see my error, I will be very grateful.
>
> Thank you,
>
> Patty
> --
> Patricia Mapes