Seeing All Entries in a Table

[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.

 

[SusanV]

You design forms for that sort of thing.

 

[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?

 

[Dirk Goldgar]

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.

 

[Joseph Meehan]

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.

 

[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.

 

[John Vinson]

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]

 

[Dirk Goldgar]

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.

 

[ChrisM]

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.