I am trying to search trough as database.
I want the user to input the info to search for under the DueDat column. It runs but then comes up with a error that says somthing like invalid vale in date in expression what should i do?
Printable View
I am trying to search trough as database.
I want the user to input the info to search for under the DueDat column. It runs but then comes up with a error that says somthing like invalid vale in date in expression what should i do?
Show some code that way we may be able to help
Hi,
check first that the value that you are passing is a valid date before doing your search.
You can use:
if not isdate(expression) then
msgbox "Invalid date"
else
'code for search
end if
HTH,
Preeti