Search results

I understand what you are saying. I don't really want forms though. All I want are 2 input boxes for Start and End date. If I have to have a form I'll build one. I guess I'm asking can I get out of this without the hassle of forms?

I'm still confused. I've read so many threads and I think what I want to do I can't without forms... but I don't know forms at all. I was just hoping to specify the dates in the query just to test without having to create a form. I have specified the dates and this works. Can I link the...

Thanks vbaInet. I haven't made the form yet, but I just inserted Between <StartDate> and <EndDate> in the query. This is now outputting the report for right clients during the right date period ... Hooray! But, I wasn't sure what to put in the criteria for CustomerID. At the moment it outputs...

Thanks! Option Compare Database Private Sub BirthsPDFOutput() Dim db As DAO.Database Dim rs As DAO.Recordset Dim dtmStart As Date Dim dtmEnd As Date Dim MyFileName As String Dim mypath As String Dim temp As String Dim strStart As String Dim strEnd As String Dim strMessage As String...

Can anyone help?

Thanks jdraw. The report works ok and outputs the individual reports but generally we only filter by date. That is it would generate output for all entries in a given date range. The code posted runs, but the first CustomerID for the date range contains all the results anda PDF with only the...

OK I've done some research and my code is below.... I have gotten myself confused and I'm hoping for some help. 1. I want the code to save to PDF the output of the report between certain dates (user inputed once). 2. I want individual files produced by the field [CustomerID] At the moment...

Hi Everyone, Hoping someone wouldn't mind donating some time. I know the basics of VBA but I am trying to help out my father-in-law and I'm in over my head. He uses Access 2007 for a business database he runs. Here is the situation: There is a report that when run asks for a date range (start...