[MS_AccessPros] Re: Error 3061 Too Few Parameters

 

I resolved the

Error 3061 issue, although I still cannot get my strSQL to sort.

 

Your insights were very helpful.

Thank you,

Patty

On Sun, Sep 8, 2013 at 12:09 PM, Patricia Mapes <patty.mapes@gmail.com> wrote:

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

--
Patricia Mapes

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (28)

Recent Activity:

• New Members 4

Visit Your Group

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

.

__,_._,___