Results 1 to 9 of 9
  1. #1
    rlbroerman
    Guest

    Names list with tabs (2003)

    I want to access a list of names from tabs in a form. I want 27 tabs with one letter in each tab.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Names list with tabs (2003)

    Can you explain more in detail what's your question ?
    If you want to do a selection on the first letter first letter of the name, in attachment a filter solution with command buttons.
    Francois

  3. #3
    rlbroerman
    Guest

    Re: Names list with tabs (2003)

    What I am trying to do is figure out how to put tabs with the letters of the alphabet of some sort on a form so I can pick a tab and it will go to the names in the list that start with that letter.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Names list with tabs (2003)

    Why would you use tabs for that ?
    Did you want 27 tabs with 27 subforms with each the same recordset with 27 different where conditions ?
    Why don't you like the command buttons in my demo ? Have you look at it ?
    Francois

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Names list with tabs (2003)

    I don't recommend trying to use a tab control. See if this is more like what you want. This is implemented as a single form view, but I've used the same technique with continuous forms.
    Charlotte

  6. #6
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Names list with tabs (2003)

    I would probably just use a combo box w/ the alphabet in it to limit the amount of buttons on the form. you can just type the letter you want and then have a query filter on that, all you need to do is have a table with the alphabet, your regular table, and a simple query to filter based on the combobox.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  7. #7
    Star Lounger
    Join Date
    Jan 2003
    Location
    Manchester, Lancashire, England
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Names list with tabs (2003)

    I have used Francois solution which he helped me with some time ago & have been very happy & impressed with it!

  8. #8
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Names list with tabs (2003)

    Francois,

    I have done this type of thing with a listbox and the letters down the left side and a lot more code than you have used in your attachment. I really like how simple this is and will use this as an alternative in future.

    Thank you!!!!!

    Carla

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Names list with tabs (2003)

    But that is when you want to *filter* the recordset. The poster indicated that he wanted to go to the names in the list starting with a particular letter, which doesn't necessarily entail filtering. Clicking on a button to move to a point in a recordset requires a single click, which is less complicated than selecting from a combobox or typing a letter in and then hitting enter or clicking somewhere, and you don't need a method for showing all records as you do when you filter.
    Charlotte

Posting Permissions

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