Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

hide items in drop down menus instead of deleting them

Discussion in 'Information Technology' started by john mcmichael, Nov 3, 2005.

  1. john mcmichael

    john mcmichael
    Expand Collapse
    Guest

    Is it possible to simply hide an item from a combobox/ dropdown list instead
    of deleting it from the list so I can use it later.

    Thank you for help and support
     
  2. Loading...

    Similar Threads Forum Date
    World War 1 To show their contempt for death, some Sikhs had refused to hide in the trenches History of Sikhism May 14, 2014
    Opinion Underneath The Turban: Why Sikhs Do Not Hide Breaking News Aug 23, 2012
    Opinion Underneath the Turban: Why Sikhs Do Not Hide? Breaking News Aug 13, 2012
    UK Hideously diverse Britain: What makes a Sikh join the far right? (Editorial) Breaking News Jun 17, 2010
    Politics Stephen Harper's Canada Chided For Cowardice (Sikh Chic) Breaking News Jun 6, 2010

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Add a field named Active that is a Yes/No field. Use a query as source for
    the combobox with criteria to eliminate any non-active items.

    "john mcmichael" wrote:

    > Is it possible to simply hide an item from a combobox/ dropdown list instead
    > of deleting it from the list so I can use it later.
    >
    > Thank you for help and support
     
  4. xRoachx

    xRoachx
    Expand Collapse
    Guest

    This can be done but it requires that you add a field to the source table and
    edit the row source for the combo box. This is easy to implement. Add a
    column to the source table labeled Active. The values are Y and N for Active
    and Inactive values (or A & I if you prefer). For the values you want
    displayed, place a Y in the Active column and N in the Active column for
    those you don't want displayed.

    In the Row source property of the combo box, add a WHERE statement to the
    SQL. The syntax is WHERE TableName.Active = "Y". For example, say your
    table is named Widgets and you want to display the name of all Widgets in the
    table. Your SQL in the row source property may look like the following:

    SELECT WidgetName FROM Widgets WHERE Active = "Y" ORDER BY WidgetName

    "john mcmichael" wrote:

    > Is it possible to simply hide an item from a combobox/ dropdown list instead
    > of deleting it from the list so I can use it later.
    >
    > Thank you for help and support
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page