Recent content by argel

who can help me ?

Thanks for the answer! I'm new in Access. How can I adapt that code to my form? I can send you my access file, if you want.

Hi guys! I'm building a search form that has one keyword ("search_box"), 2 combo box ("cc_loc_combo_box" and "cc_deq_combo_box") and one option group ("status_box") search. I'm trying to intersect all the searches. If I intersect the "cc_loc_combo_box" with the keyword search it works, however...

I don't really know... I'm working in Mozambique and, despite of the OS be formatted to portuguese, because of the region the type of date is dd-mm-yyyy. If I made a search based on date range like I was doing, I can't get the right results. It always gave me error message. With the simple query...

Thank you for the answer! Before I saw it, I made a simple query with date range according to the data introduce on the form, just like yours, and solved the problem! Thank you very much!

Still not working ... Thanks a lot for the help anyway!

Can you write the code with more detail? Including the place to write the Format function. I'm not sure if I'm doing the right way. Sorry!

Where should I put that line of code? when you say "yourdate" is the text box or the format "dd-mm-yyyy;@" ? Thank you !

When I open your file, the software automatically change the format to "dd-mm-yyyy;@" and the search still not match ... :banghead::banghead::banghead::banghead::banghead:

Even if I upload with the date format it keep send error unless I change the format to dd-mm-yyyy, I really don't know why... :banghead: Can you send me the file that you change? In order to see if it works for me now. Thank you for the help and for being so patient !

In this form I really need to the search by equipment or by date. My ORDER BY is now equal to every search. I miss it at the time I uploaded the file.

I had already this format problem when I uploaded the table from the excel. " That type of date it's not allowed in my system (Portugal), don't know why. If you go to table,for example, "LISTA_EQ", on the field "MOBILIZAÇÃO" you'll see that the date format is " dd-mm-aaaa;@. I had to put it...

Sorry! I should told you!:rolleyes: Is in the Form "SEARCH_MOB" . Where says "De" is "Date from" and "Até" is "Date To".

I'm using the 2013 version. But on the format file it says 2007-2013

Thank you for the help! Can you take a look to my db that I upload above? I've been trying put as you say but I can't... I'm new on this world.