Search results

I did that, then I had to move the Loop before the end with...NOW, I get runtime error 424 (object req) on the Set rs line: Set rs = db.OpenRecordset(Me![Invoices_tbl_subform].RecordSource, dbOpenDynaset) I tried Set rs = 'Me![Invoices_tbl_subform].Form.Recordsource Same...Ahh!!! HEre is...

Ugh... Here is the code now...the button works great, but I get a compile error on the Do Until .Eof line. I do have the DAO reference installed.: Dim rs As DAO.Recordset ' Dim db As DAO.Database ' Set rs = db.OpenRecordset(Me![Invoices_tbl_subform].RecordSource, dbOpenDynaset)...

I am using Access 2000 for the following code...read the commented lines Dim rs As DAO.Recordset ' is it DAO or something else? Dim db As DAO.Database 'as above Set rs = db.OpenRecordset(Me![Invoices_tbl subform].RecordSource, dbOpenDynaset) 'my subform, but I keep getting error messages. I...

Yes it is...should it not be?

On a subform I have a button that has code for its click event. This button reappears for each record. (btnPrintInvoices). There are 4 other forms just like this, these too will be need to be called at the same time (the loop) I also have a public function for this event and for each other...

I need to be able to return a list of records from 3 tables that are related: Contacts, ContactsLanguages(one to many relationship to contacts) and ContactsInterests (one to many relationships to contacts). I need to be able to search by 6 different fields. 4 from the contacts table (Name...