Results 1 to 7 of 7
  1. #1
    Join Date
    May 2012
    Posts
    132

    Unanswered: how select all the options?

    The criteria of a query is coming from a dropbox on a form. There are 7 selections in the dropbox. How can we enable the user to select all of them?
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    Take a look at the following link:

    Selected Listbox items and Dynamic Query
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    May 2012
    Posts
    132
    could you please check the link? there is nothing on that page!!
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Quote Originally Posted by ariansman View Post
    could you please check the link? there is nothing on that page!!
    Sure there is! An Error Message:

    NOT FOUND

    Sorry, but you are looking for something that isn't here.


    ariansman: Are looking for a way to include all seven items or any combination from one to all seven items?

    What code are you currently using to include a single item in the Query?

    Linq ;0)>
    Last edited by Missinglinq; 05-19-12 at 19:26.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    Very Sorry for the mistake. The correct link is given below:

    LEARN MS-ACCESS TIPS AND TRICKS - Selected List Box Items and Dynamic Query
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  6. #6
    Join Date
    May 2012
    Posts
    132
    linq: i used the lookup wizard when i put the combobox on the form
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

  7. #7
    Join Date
    May 2012
    Posts
    132
    Thank you for your guide,
    It was helpful. I also have a question about combobox.
    The criteria in the query is getting data from combobox on a form. How can we make the criteria to be ignored if nothing is selected on the combobox. In other words, the query will show all the records if nothing is selected on the combobox.
    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
    I asked god to please give me everything to enjoy the life, God said: i gave you the life to enjoy everything.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •