I'm not entirely sure why, but i think the format function around the vdate 6 ,11 ,16 fixed it.
Thanks again for all your help June7. You are amazingly patient and a big help to many many people.
I'm not entirely sure why, but i think the format function around the vdate 6 ,11 ,16 fixed it.
Thanks again for all your help June7. You are amazingly patient and a big help to many many people.
The references to vdate textboxes should not be within quote marks and use # delimiter.
"Scheduling_Date=#" & [vDate1] "#")
However, I just noticed (or did we already go over this issue) your dates are shown in dd/mm/yyyy structure. Access expects dates to be in mm/dd/yyyy structure.
So, yes, converting to strings might be better as long as the date strings all have the same number of characters. This means using placeholder zeros - 01/01/2014
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.