Recent content by catherinebush

OMG - That was it! Thank you so much! I can't believe I missed that!!!

I have tried everything, I am obviously a newbie to VBA. Here is the most recent routine. Private Sub Command24_Click() Dim rs As DAO.Recordset Dim db As DAO.Database Dim strSQL As String Dim mypath As String Dim strRptName As String strRptName = "EligibleEmployees" mypath =...

Thanks pbaldy. I must admit I am not that well versed so I am trying everything, and it takes awhile to tweek things so that they work. I am willing to try anything. I have over 2000 records that need to be stored for posterity sake in individual files in a system called NOLIJ. I really...

Pbaldy and Pat for your quick responses. FYI - I have tried several different versions of the wherecondition and could not get it to work. I will try the hidden control in my form and will let you know when I succeed!

I am new to this group and to this forum. I am trying to loop through a query, then save each record in the query to a pdf. Query - ReceivedExportQuery Report - EligibleEmployees I want to save each record as the employee name. I have read through most of the threads and have written the...