Search results

Ok fixed!!! Thanks for your help. I found the syntax error and now it all works like a charm. Really apreciate your time and effort to help me. Thank you, T C

I get a syntax error after trying that. I'm a VBA noob so i dont rly know why it gives me the error.

Yeah i just did another thest and indeed everything less than 13 doesnt show up. Instead it automaticly changes 1-3-2011 to 3-1-2011. If i dont use the # it will give me an error saying the Datatypes dont match. Any way to fix the USA format? Thanks in advance, T C Edit: Ok thanks...

Yes i've created a query for the report. Could it be something with my code? Here is the code i got to filter the report: Private Sub Knop20_Click() Dim strAfdeling As String Dim strInvnr As String Dim strDatum As Date If IsNull(Me.zk_afdeling.Value) Then strAfdeling = "Like '*'" Else...

Hi Trevor, Thanks for your fast reply. I tried it with no luck. It still gives me the same problem. The strange thing is, all the other dates get filtered normally except the ones starting with 1 and 11...... Greets, T C

Hi there, Im currently working on a project where i want to Filter a date in a report. I've got a table that contains a column Date. I can filter it on any date and it works normally, except the dates that start with 1 or 11. Example: 13-4-2011 <---- works 1-4-2011 <----...