Search results

I'm make a little change to the db... New question!! following my selection (check box), can i make it to list down the first name in the list box. no need to open FRM_SearchResult form. Hopefully u understand my English.

Thanks for ur help and advice.:D

Hai.. rexb I also a beginner in ms access. my English also bad. never mind here i attach the db example that i create following ur question. hopefully.. it's answer ur question.

I have a Table like Table.jpg and then I make form like Form.jpg. Can anyone help me how to make a search using check box. For example : If I check the soccer and badminton check box, it will show the name with that criteria in list box. here I attach the image and database....

tq.. I'm get the answer.

i have a question 2.. i used this code to save my report in folder with specific name. when i click the button..... the file save and report preview also open. what should I do if I don't want that report to preview.

4 form? how about report? there is no On Key Press in report.

How to make the first letter is cap

Thanks... it working as i need.

U can see the attachment to understand what i mean.

Thanks 4 ur help I make it using design view. Sorry...:( Thanks.. again.

sorry... can u show me how to put it in sql.

I make a query like this: SELECT Table1.Date, Table1.Place, Table1.Person, "I meet " & [Person] & " at " & [Place] & " on " & [Date] AS Story FROM Table1; for the date it come out with 2/11/2009 format... how to change it to 11/Feb/2009. Please... help me. I'm also attach the database.

Re: :c yahoooo!! Thanks. :D

:c :( NEVER MIND I UNDERSTAND. anyway thank again 4 ur help. u done have 2 be my private tutor (i know u busy). u just give the answer when i ask that's all. ok!! :cool:

Thanks. it seem so easy. but difficult for me to understand. can u teach me more about the code? Dim strWhere As String (what is code for?) strWhere = BuildFilter If Left(strWhere, 7) = " WHERE " Then strWhere = Right(strWhere, Len(strWhere) - 7) (why there is a number.) End If...

Hai... i got new problem. I try to put a button (Report) to open the report at the current query. But it open all data. here i attach the db.:confused:

Hopefully u can share with me any knowledge u get about ms access next time.:D

hmmm... everyday i looking for new knowledge in the internet about ms access. when i found something new... i will try to play around with it.. easily if i found with db example. i think... the big problem is my English. sometime i take a long time to understand the meaning of some word. :o

is there any way that i can learn VBA easily. actually i don know about VBA. i just take someone else code and then used it (copy and paste):o.