Search results

Hi Gasman, I just used the last suggestion in the forum, I stop combining codes as you suggested.

Thank you very much. It worked. When the word is not available it pop-up "Not Available" and this is enough. Just for my curiousity, is it possible to have a pop-up of the word itself. For example: If I search for the word "Hello" and it is not available.... The pop-up should be..."Hello...

Hi, I used the last message code of cheekybuddha. You are right , "cmdS" and control (textbox?) "S" are on Form1 Search button is the cmdS Below is the code I used: And this is error:

Hi Gasman, I'm not getting it, sorry as mentioned I new in this field. Can you pleases assist me by step. I want to do it by step. First I want to establish a code to search a "word" that is available in the field . I tried several combination but still end error, please help to correct the...

Hi, 1. There was a pop-up error on first line that you provided like missing bracket, wrong spelling so I revised it as below: strCriteria = "[BaseNumber] Like '*" & [Forms]![Form1]![S} & *'" OR [BaseTitle] Like '*" ] The revised code can filter the search word but...

Hi Gasman, Thanks for the reply I'm still new in access, still learning and currently using limited functions...In this case I use the Macro and put value as below: Can you be specific where should I use DLookUp() or DCount() in this Macro, or any code that will help me to simply it.

Hi, I created a Search box and search button that is working fine when the word to search is available. But when the word to search is not available the Form page will be displayed in blank and to return to original page I have to tick the "toggle filter"(below screenshot). Can some please...

Solved. thank you

Hi, I have a Search box and Search button that works fine when searching a particular word. The clear button works fine as well but the issue is the word stays in the search box. Can anyone please help on how to clear the text as well after the clear button is launched, below is the code that...

hi DBguy, Thank you it works.. I corrected the typo in the field name. I did not notice it as well :)

Hi DBguy, Tried option 1 but not working as well as option 2. At below, asking for Calculated parameter and empty field display at top with the date not in ascending order.

Hi DBguy, I thought everything is fine as I see that empty fields are at the bottom with the below codes. SELECT Table1.ID, Table1.Date, Table1.Type, Table1.Caculated, Nz([Caculated],#12/31/9999#) AS Expr1 FROM Table1 ORDER BY Nz([Caculated],#12/31/9999#); I noticed that if the month are same...

Hi DBguy and Pat Hartman, I tried the suggestion of DBguy, thank you it works. For this particular query I have not tried the suggestion of Pat Hartman, however it gives me an idea on how to deal with other task for my project. Thank you once again to both of you, appreciated.

Hi DBguy, In my project, the empty values indicates that the product has not yet delivered. once the product is delivered the empty values will be updated with the date of delivery. I did that option already by replacing the empty dates by future dates just to display it at the bottom part...

Hi Everyone, The sorting of Date in Ascending order displays the null value at the top. As per my project requirements, in ascending order the null values should display at the bottom? Can someone help me on how to do it?

Thank you all for the response and examples. Its solved my query.

Hi everyone, I am using Access 2010 and base on my research the option to link a calendar is not an option to this version. If there is other way, can someone please advise on how can I add the calendar in 2010 Access? Thank you

Hi Everyone, Thanks for accepting my request to be part of the Accessworld. I'm new in Access and interested in learning more