Search results

Dear Uncle Gizmo, I make search form like attach picture, In header have combobox to select columns for searching and in next text box for typing the keywords, in western characters fields or English characters fields working well, but in field that contain words in our language not working...

Please help, I have database that contain fields in English and Khmer language (Cambodian Language), I could't search records in Khmer Language fields, but for English fields working, Please help. Thank you. hope full.

Thanks a lot missingling very useful link page for coding.

Hi ClearlyDarkly, Your code error when I put in key press event. Please look in attach file. Thanks.

Hi CJ London, A great help, thanks a lot, I put your code on change event when I type 2nd letters... why the first letter disappeared? when I continues typing, display only last letter in text box, how should I do, if I want to display all letters or hold words as I type in text box?. Thanks.

Hi All, Who could help me to make a text box live search (mean: search as you type) in header of continue form and a button to clear the text box will show all record after click. I would like to search fields such as: [ServiceName],[UnitName],[StaffName],... the database in attach file...

Hi all, sorry! may be I was wrong on explanation, I have continuing relationship One to Many between 3 tables that relation fields are [ServiceName], [UnitName] and [StaffName]. I would like to know in 1 Service how many unit?, but I would'n like to know how many staff, but when I made...

Hi The Doc Man, I did the same you told me in the field [UnitName], first I group it by press sigma letter and in below I count by using the formula Count(*), but still appear text not number and make another fields repeat value or text, what I should do now? Thanks.

Hi all, Please could you tell me! there are some uniquecount/countUnique formulas something like that can be use in query to count unique text? because I have a table that contain Unit Name (Text) some name are repeated, but I want to count only one time for that name in query, what formula can...

Wow, Thanks you very much for great advice, it now work. Thanks Sneuberg.

Hi, Sneuberg, Try to type Keywords in the form, please give me ideas how to make this search form work without errors in columns [daysleft], [Status]...[Unitnumber], Thanks.

Hello Sneuberg (Steve), Now it work, Thank you very much for your great help to me. Thanks

Thanks Steve, errors still there, but may be not compactable expression builder formulas with search form by keywords, Do exist any ways beside expression builder formulas in query? Thanks

The Formulas are: 1). DaysLeft: ([IssueDate]+([YearNumber]*365))-Now() First formula I would like to know expired date for licensing. 2). Status: IIf([DaysLeft]<0,"Expired",IIf([DaysLeft]<30,"Expired Soon","")) The 2nd formula I wand access alert about status of giving licensing. Thank a lot...

Dear all, Who can help me, I have Form search by keywords, the source data from query that contain expression builder from formula when I type search keywords the columns that contain formula appear error name#?, Please help, I need calculation fields, because is the importance data for me...

Hi, I am a beginner on Ms Access, Thanks.