Recent content by niloc77

Hi Bob, The filter seems ok but I seem to have an issue with the code for the date. I have modified to the following, previous was dd\/mm (wrong order) Const strcJetDate = "\#mm\/dd\/yyyy\#" But still gives me a false result. Do you think the date code is ok Thanks Colin

Hi Bob, That seems to have done the trick, I will give it a good run through tommorow also. Once again, thank you very much and thanks for sparing me the time with my issue. Kind regards Colin

Hi Bob, Tried that and get the following... Error 3075: Extra ) in query expression '(Date of GP Referral]>=#01/01/2012#) AND ([Date of GP Referral]<#03/02/2012#) AND ([Attendance Type]='FU' And [Clinical Diagnosis]<> ) Or ([Attendance Type]='FU+PROC' And [Clinical Diagnosis]<>)'. Thanks Colin

Thanks Bob, I'm a bit of a novice i'm afraid, I need to add the following filter to the code below. Filter... [Attendance Type]="FU" And [Clinical Diagnosis]>"" Or [Attendance Type]="FU+PROC" And [Clinical Diagnosis]>"" Date filter vba..... Private Sub DateReportDiagFU_Click() On Error...

I have a report that uses a date filter (vba) to generate a report. The report also contains a separate filter within the report property sheet and the Filter On Load is set to "Yes". my problem is the vba filter is overriding the Filter On Load. Any idea or help on how to fix this. Thanks...