RE: [MS_AccessPros] Error 3061 Too Few Parameters

 

Patty-

 

Put brackets around [StartDate] … assuming you have a field called StartDate in diagnosis.

 

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

 

 

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Patricia Mapes
Sent: Sunday, September 08, 2013 6:10 PM
To: MS_Access_Professionals@yahoogroups.com
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

 

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 5

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___