IT WORKED!
Thanks so much for your help,
Ron
Ron Wan
Last Activity: Mar 12 '08, 01:06 AM
Joined: Jul 27 '07
Location:
-
I fixed that but still get an error
Dim MyRS As Recordset
Set MyRS = Me.RecordsetClo ne
MyRS.MoveFirst
Run-time error 7951 You entered and expression that has an invalid reference to the RecordsetClone property.
The form with the recordset on it is actually a subform. The command button is on the main form. When I change Me.Recordset to Forms![MySubform] it returns a can't find the form...Leave a comment:
-
Yes I did. Here it is:
Dim MyRS As DAO.Recordset
Set MyRS = Me.Recordset.Cl one
MyRS.MoveFirst
I get this error: "Object variable or With block variable not set (Error 91)"
Do I need to check another reference to the reference library and if so what?
Thanks,
RonLeave a comment:
-
Thanks for the reply. So I should use a Do Loop instead of For Each?
I tried it and I had to add the DAO reference to get past the [Dim MyRS As DAO.Recordset] line then [Me.RecordsetClo ne] returns an invalid reference error also. Do I add more references in the references dialog box? if so what?
Thanks,
RonLeave a comment:
-
For Each loop syntax problem
I am inexperienced at this (posting and writitng code).
I am using an Access2000 datasheet form with checkboxes to select PDF documents for printing. The PDFs are given filenames based on the doc_id assigned as the primary key in the doc table when the doc is entered into the database. What I can't do is use a form to select which docs to print with AdobeReader. I have been trying For Each loops but can't get the syntax and proper variable...
No activity results to display
Leave a comment: