Hi all.
I have used the code within faq702-1177 many times over the years, in order to create a user search form. It has been invaluable.
My problem now is that my users require the form to enable them to search, on the same form, between two dates, as well as by text variables. MyCriteria is a string, so wheras the code will allow a search for a specific date, it will not allow a search on a value > MyCriteria or < MyCriteria.
I'm no expert in SQL, and my VBA is incredibly rusty. Is there a solution to this problem which isn't immensely complicated.
Any help, as ever, greatfully received.
I have used the code within faq702-1177 many times over the years, in order to create a user search form. It has been invaluable.
My problem now is that my users require the form to enable them to search, on the same form, between two dates, as well as by text variables. MyCriteria is a string, so wheras the code will allow a search for a specific date, it will not allow a search on a value > MyCriteria or < MyCriteria.
I'm no expert in SQL, and my VBA is incredibly rusty. Is there a solution to this problem which isn't immensely complicated.
Any help, as ever, greatfully received.
