Recent content by copsy1979

Hi, tried this but it throws up error message compile error syntax error Any suggestions?

Hi, I have succesfully created reports to be filtered using a date range and a client code but am struggling with the code required to filter by a text field. The process I use is as per "Allen browne" where you create a form to enter the required criteria. The coding I have in the "preview"...

thanks, that seems to have worked.

sorry ... a newbie to the forums. This is the code that works. Private Sub Preview_Click() Dim strReport As String 'Name of report to open. Dim strField As String 'Name of your date field. Dim strWhere As String 'Where condition for OpenReport...

Well it does work if I keep the code. But I idealy want to only enter one date. First 2 reports required a start and end date so code is set up for this. This report I want to enter a particular date : e.g 31/01/08. This means with using the code I enter the same date twice : in both start...

hi, I have successfully filtered 2 reports with start and end dates, using AllenBrown method of txtenddate form and code. I am now having trouble changing the code to allow it to filter by one set date. I have created the form and query correctly but when I run the report and enter a set...