Hello,
I have found a very weird glitch and i cannot figure it out for the life of me. I have a table with a 'Drill_Date' field, which is Date type and formated using short date. I have an entry there for the 5th of October, and it shows up as 5/10/2009 in the table. Good.
When i use the query builder and search for the record with Drill_Date = #5/10/2009#, it finds the record. Good.
In VBA , when i code it so that the record gets displayed based on a Calendar object, the record is not found.
The one thing i noticed is this: If my query searches for #10/05/2009#, then it finds the record. If i search for #5/10/2009# it does not. It seems that the VBA queryies that run change how the date is compared... It seems to take the smallest number out in front for it to find the record.
Does anyone have any idea how to get around this problem??