Results 1 to 14 of 14
  1. #1
    HAPPYWITHU is offline Novice
    Windows XP Access 97
    Join Date
    Apr 2010
    Posts
    7

    Find as you type Combo boxes in MS Access


    http://www.tek-tips.com/faqs.cfm?fid=6295

    http://www.tek-tips.com/faqs.cfm?fid=6304


    Somebody, please help upon this issue.

    Prepare a sample database in access using the codes above and post it.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That is an exercize left for the reader of these links. You will learn a lot by implimenting such a project yourself.

  3. #3
    HAPPYWITHU is offline Novice
    Windows XP Access 97
    Join Date
    Apr 2010
    Posts
    7
    Quote Originally Posted by HAPPYWITHU View Post
    http://www.tek-tips.com/faqs.cfm?fid=6295

    http://www.tek-tips.com/faqs.cfm?fid=6304


    Somebody, please help upon this issue.

    Prepare a sample database in access using the codes above and post it.
    i am not arriving at the results the SQL and the code doesnt seems to work for me. Please prepare a working example.

  4. #4
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Instead of us doing your work for you, how bout you upload what you currently have and we can point out any flaws we see. Teach a man to fish > give a man a fish

  5. #5
    Evgeny's Avatar
    Evgeny is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    85
    started learning Sql and vba just 4 weeks ago and have made good progress by continuously trying, trying and trying to make it work... and when i could not in the end, i just asked the smart guys to help . Provide an example and i am sure people will help you

  6. #6
    HAPPYWITHU is offline Novice
    Windows XP Access 97
    Join Date
    Apr 2010
    Posts
    7

    Try to do it

    Quote Originally Posted by HAPPYWITHU View Post
    http://www.tek-tips.com/faqs.cfm?fid=6295

    http://www.tek-tips.com/faqs.cfm?fid=6304


    Somebody, please help upon this issue.

    Prepare a sample database in access using the codes above and post it.
    The following code doesnt work please prove that by just uploading a sample.
    the effort is to put a combo and a table. Please the code dows not work.

  7. #7
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Just ran the first one. Works fine. Upload the db you tried it on and we can help you. Else, I'm done with this thread.

  8. #8
    HAPPYWITHU is offline Novice
    Windows XP Access 97
    Join Date
    Apr 2010
    Posts
    7

    Findasyoutype

    http://www.tek-tips.com/faqs.cfm?fid=6295

    Fix my form's code using the link above.

    There are two combo boxes in my form one for Number and another one for text.

    Make those two find as you type filter combo.


    Thanks in advance.//

  9. #9
    HAPPYWITHU is offline Novice
    Windows XP Access 97
    Join Date
    Apr 2010
    Posts
    7
    Quote Originally Posted by HAPPYWITHU View Post
    http://www.tek-tips.com/faqs.cfm?fid=6295

    Fix my form's code using the link above.

    There are two combo boxes in my form one for Number and another one for text.

    Make those two find as you type filter combo.


    Thanks in advance.//
    There is no reply... what happened..

  10. #10
    Join Date
    May 2010
    Posts
    339
    You failed to copy/paste the required code into your combo box On Change Event...
    1. Create a combo box on a form.
    2. Create an event procedure for the combo box's OnChange event.
    3. Copy and paste the code, below, into the OnChange procedure
    4. Replace "Combo0" with the name of your combo box.
    5. Change the strSQL strings to match your table and fields.
    6. You're done.

  11. #11
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Access_Blaster, you get my vote for "most epic first post." Thank you

  12. #12
    HAPPYWITHU is offline Novice
    Windows XP Access 97
    Join Date
    Apr 2010
    Posts
    7
    Quote Originally Posted by HAPPYWITHU View Post
    http://www.tek-tips.com/faqs.cfm?fid=6295

    Fix my form's code using the link above.

    There are two combo boxes in my form one for Number and another one for text.

    Make those two find as you type filter combo.


    Thanks in advance.//
    The information provided is useless. Please upload an working example of the code please. Do not give useless suggestions. Please help to upload an working sample.

  13. #13
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Hey Mod, can we get this thread locked? This guy just wants us to do his work for him.
    kthxbai
    /unsubscribed from thread

  14. #14
    HAPPYWITHU is offline Novice
    Windows XP Access 97
    Join Date
    Apr 2010
    Posts
    7
    Please help me to fix the SQL from the sample database please. I am fed up with the experiment. you could just give the sql query alone.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combo Box Autocomplete / Filter as you type
    By Pimped in forum Programming
    Replies: 28
    Last Post: 01-14-2015, 08:37 AM
  2. combo boxes
    By thewabit in forum Forms
    Replies: 7
    Last Post: 01-01-2010, 08:51 PM
  3. combo boxes
    By googenfrog in forum Forms
    Replies: 3
    Last Post: 07-03-2009, 05:41 PM
  4. Replies: 0
    Last Post: 02-27-2009, 01:27 PM
  5. Combo Boxes
    By Mxcsquared in forum Forms
    Replies: 0
    Last Post: 01-19-2006, 04:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums