Welcome to SPN

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

Sign Up Now!

Seeing All Entries in a Table

Discussion in 'Information Technology' started by Sandi, Jul 28, 2006.

  1. Sandi

    Sandi
    Expand Collapse
    Guest

    In a table in your database is there a way to see each entry that is in the
    table. For example, in Excel if you right click in a cell there is the Pick
    From Drop Down List that will show each entry inside the column you are
    selected on. Is there a way to do the same thing in Access. I have a table
    that has over 55000 records and in one column holds a bunch of different 3
    letter codes and I want to be able to see all the different codes that are
    listed (this info was imported in from a text file). Any help would be
    appreciated.
    --
    Sandi Gardner
     
  2. Loading...

    Similar Threads Forum Date
    Seeing Through The "Single Eye" of Equality Interfaith Dialogues Mar 11, 2012
    India Anna Hazare: Whatever we are seeing is tragic, so I have decided to call off fast Breaking News Dec 28, 2011
    Opinion Seeing Good, Seeing Evil Breaking News Sep 29, 2011
    Seeing Good and Seeing Evil Inspirational Stories Sep 23, 2011
    SciTech Digging Deeper, Seeing Farther: Supercomputers Alter Science Breaking News Apr 27, 2011

  3. SusanV

    SusanV
    Expand Collapse
    Guest

    You design forms for that sort of thing.

    --
    hth,
    SusanV

    "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    news:752D28FB-2209-41DE-9CD8-661EA4C7D3AF@microsoft.com...
    > In a table in your database is there a way to see each entry that is in
    > the
    > table. For example, in Excel if you right click in a cell there is the
    > Pick
    > From Drop Down List that will show each entry inside the column you are
    > selected on. Is there a way to do the same thing in Access. I have a
    > table
    > that has over 55000 records and in one column holds a bunch of different 3
    > letter codes and I want to be able to see all the different codes that are
    > listed (this info was imported in from a text file). Any help would be
    > appreciated.
    > --
    > Sandi Gardner
     
  4. Sandi

    Sandi
    Expand Collapse
    Guest

    Well that would work if I were going to need forms but I will not be adding
    data to this - just importing it and running a report. Is there no way in
    the table to do such?
    --
    Sandi Gardner


    "SusanV" wrote:

    > You design forms for that sort of thing.
    >
    > --
    > hth,
    > SusanV
    >
    > "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    > news:752D28FB-2209-41DE-9CD8-661EA4C7D3AF@microsoft.com...
    > > In a table in your database is there a way to see each entry that is in
    > > the
    > > table. For example, in Excel if you right click in a cell there is the
    > > Pick
    > > From Drop Down List that will show each entry inside the column you are
    > > selected on. Is there a way to do the same thing in Access. I have a
    > > table
    > > that has over 55000 records and in one column holds a bunch of different 3
    > > letter codes and I want to be able to see all the different codes that are
    > > listed (this info was imported in from a text file). Any help would be
    > > appreciated.
    > > --
    > > Sandi Gardner

    >
    >
    >
     
  5. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    news:752D28FB-2209-41DE-9CD8-661EA4C7D3AF@microsoft.com
    > In a table in your database is there a way to see each entry that is
    > in the table. For example, in Excel if you right click in a cell
    > there is the Pick From Drop Down List that will show each entry
    > inside the column you are selected on. Is there a way to do the same
    > thing in Access. I have a table that has over 55000 records and in
    > one column holds a bunch of different 3 letter codes and I want to be
    > able to see all the different codes that are listed (this info was
    > imported in from a text file). Any help would be appreciated.


    The Filter By Form function (available on the toolbar) provides this
    sort of functionality (for filtering purposes, of course), but the
    number of unique values it will try to keep track of is limited by an
    option setting. The default for that setting is 1000. The option is on
    the Edit/Find tab of the Tools->Options... dialog.

    Alternatively, you can create a quick query to return the unique values
    from that field in the table. For a pick-list on a form, you'd use a
    combo box whose row source is such a query.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  6. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Sandi wrote:
    > In a table in your database is there a way to see each entry that is
    > in the table. For example, in Excel if you right click in a cell
    > there is the Pick From Drop Down List that will show each entry
    > inside the column you are selected on. Is there a way to do the same
    > thing in Access. I have a table that has over 55000 records and in
    > one column holds a bunch of different 3 letter codes and I want to be
    > able to see all the different codes that are listed (this info was
    > imported in from a text file). Any help would be appreciated.


    Tables are nothing more than buckets of data and definitions.

    You view that data by using forms, queries and reports.

    --
    Joseph Meehan

    Dia duit
     
  7. Sandi

    Sandi
    Expand Collapse
    Guest

    Thanks for being more descriptive Dirk. Maybe I should elaborate more. The
    information that is being imported in - I don't know of all the different
    codes so therefore filtering by form wouldn't work since I don't know of all
    the codes. I guess there is not a way just to see all the codes that are
    listed in a quick fashion.
    --
    Sandi Gardner


    "Dirk Goldgar" wrote:

    > "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    > news:752D28FB-2209-41DE-9CD8-661EA4C7D3AF@microsoft.com
    > > In a table in your database is there a way to see each entry that is
    > > in the table. For example, in Excel if you right click in a cell
    > > there is the Pick From Drop Down List that will show each entry
    > > inside the column you are selected on. Is there a way to do the same
    > > thing in Access. I have a table that has over 55000 records and in
    > > one column holds a bunch of different 3 letter codes and I want to be
    > > able to see all the different codes that are listed (this info was
    > > imported in from a text file). Any help would be appreciated.

    >
    > The Filter By Form function (available on the toolbar) provides this
    > sort of functionality (for filtering purposes, of course), but the
    > number of unique values it will try to keep track of is limited by an
    > option setting. The default for that setting is 1000. The option is on
    > the Edit/Find tab of the Tools->Options... dialog.
    >
    > Alternatively, you can create a quick query to return the unique values
    > from that field in the table. For a pick-list on a form, you'd use a
    > combo box whose row source is such a query.
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)
    >
    >
    >
     
  8. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 25 Jul 2006 07:46:06 -0700, Sandi
    <Sandi@discussions.microsoft.com> wrote:

    >In a table in your database is there a way to see each entry that is in the
    >table. For example, in Excel if you right click in a cell there is the Pick
    >From Drop Down List that will show each entry inside the column you are
    >selected on. Is there a way to do the same thing in Access.


    I'd suggest just creating a simple Totals query, grouping by (and if
    desired, counting) this field. You could have the query displayed
    either as a query datasheet or on a form.

    John W. Vinson[MVP]
     
  9. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    news:232CDBE8-7650-4B13-A4A6-692D29F9B4A6@microsoft.com
    > Thanks for being more descriptive Dirk. Maybe I should elaborate
    > more. The information that is being imported in - I don't know of
    > all the different codes so therefore filtering by form wouldn't work
    > since I don't know of all the codes. I guess there is not a way just
    > to see all the codes that are listed in a quick fashion.


    My point about the Filter By Form function is that, if you just want to
    get a quick look at the distinct codes that are in the data, you can
    start a Filter By Form, then click the dropdown arrow in that field on
    the filter form, and see the list of codes -- provided, of course, that
    there aren't more than 1000 (or your option setting) distinct codes.

    Failing that, setting up a quick query is really not that hard.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  10. ChrisM

    ChrisM
    Expand Collapse
    Guest

    Create a new Query based on your table, and put it into SQL view.

    SELECT DISTINCT myCode
    FROM myTable;

    Should show you what you want...

    Cheers,

    Chris.

    "Sandi" <Sandi@discussions.microsoft.com> wrote in message
    news:752D28FB-2209-41DE-9CD8-661EA4C7D3AF@microsoft.com...
    > In a table in your database is there a way to see each entry that is in
    > the
    > table. For example, in Excel if you right click in a cell there is the
    > Pick
    > From Drop Down List that will show each entry inside the column you are
    > selected on. Is there a way to do the same thing in Access. I have a
    > table
    > that has over 55000 records and in one column holds a bunch of different 3
    > letter codes and I want to be able to see all the different codes that are
    > listed (this info was imported in from a text file). Any help would be
    > appreciated.
    > --
    > Sandi Gardner
     

Share This Page