I have created a Search form using the code at this URl :
http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242
it works except I cant use it to search by date, which I need to do.
It will only search in U.S. format, MM/DD/YYYY, as I am in Australia I need to search in the following format DD/MM/YYYY.
I have checked the local machine settings and the short date is in the right format, it just seems to be either Access or the code.
Could someone please help me with this issue?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242
it works except I cant use it to search by date, which I need to do.
It will only search in U.S. format, MM/DD/YYYY, as I am in Australia I need to search in the following format DD/MM/YYYY.
I have checked the local machine settings and the short date is in the right format, it just seems to be either Access or the code.
Could someone please help me with this issue?