Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2002
    Posts
    114
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Treble filter (Access 2000)

    In my continous form called frmDiary each row begins with a date, for example 01.07.2007.How can i filter the form in such a way, as to when i click on a certain date, for example 01.07.2005, to get the results only for this date ?
    Also, how can i make this filter work after the main fiter?.My main filter is filtering per offices, as shown in my attachment.After this filter, i want to make also 2 kinds of filters
    1. to filter a given date, as said before
    3. to filter per invoice or order or offer, after fltering for the office.

    Can you help me with this difficult task?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Treble filter (Access 2000)

    You don't need code to filter by date, the user can click in the date field and then click the Filter By Selection button on the toolbar, or right-click the field and choose Filter By Selection from the popup menu.
    Filtering by invoice, order or offer can be done the same way.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Treble filter (Access 2000)

    [[insert comment about bass filter here]]
    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    I know, I know, bad joke, but it was started <!post=here,485414>here<!/post>...
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Treble filter (Access 2000)

    I didn't want to make the same joke twice... <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>

  5. #5
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Treble filter (Access 2000)

    I will <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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