Results 1 to 5 of 5
  1. #1
    dev82 is offline Novice
    Windows XP Access 2002
    Join Date
    Oct 2010
    Location
    Germany
    Posts
    9

    SQL Filter?

    Hello Guys,



    i have this access mdb and i would like to filter in the menü the "airline" and "kette" i have access 2002. if i click on "suchen" the code dosent's work. i can't find the problem.

    Thanks
    Dev82

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    You don't indicate what you would like to happen -- just that it doesn't work -- doesn't help much.

    I think you should watch the free video tutorial here
    http://www.datapigtechnologies.com/f...combobox2.html
    to see if selecting something in one list affects what can be selected in the second list.

    You may also want to watch
    http://www.datapigtechnologies.com/f...tboxtrick.html

  3. #3
    dev82 is offline Novice
    Windows XP Access 2002
    Join Date
    Oct 2010
    Location
    Germany
    Posts
    9
    Hello orange,

    that's not my problem. i would like to filter the data via the subform from the main menü.

    Dev82

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,847
    Please give an example of what you would like to happen.

    I tried your mdb and don't know what you think is suppose to happen.

    What do you think is being placed in the immediate window?
    What does it represent?

  5. #5
    dev82 is offline Novice
    Windows XP Access 2002
    Join Date
    Oct 2010
    Location
    Germany
    Posts
    9
    in the form "menü" you can mark the "kette" and "airline" i would like to mark 2 or 3 of them and then filter the data, the subform has to show me the filtered data.

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

Similar Threads

  1. Slow response over VPN or To Filter or not To Filter
    By rcrobman in forum Database Design
    Replies: 0
    Last Post: 04-30-2011, 02:37 PM
  2. Filter problem
    By Javad in forum Access
    Replies: 0
    Last Post: 01-22-2011, 01:48 PM
  3. How do I filter on this ?
    By _Chris_ in forum Access
    Replies: 7
    Last Post: 08-12-2010, 08:34 PM
  4. Filter on #Num!
    By marley in forum Access
    Replies: 5
    Last Post: 07-28-2010, 06:59 AM
  5. VBA Filter
    By ntallman in forum Programming
    Replies: 7
    Last Post: 04-06-2010, 10:53 AM

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