how do I hide rows in an access table

A

alexandra zwick

i have an access database which I would like to re-use but not using all of
the records and would like to hide some rows. Is there a way of doing this,
please???

Alexandra Zwick
 
K

Ken Snell \(MVP\)

Use a query to select the desired data -- then don't use the table itself as
the RecordSource of a form, use the query instead.
 
J

John W. Vinson

On Mon, 24 Sep 2007 08:54:00 -0700, alexandra zwick <alexandra
i have an access database which I would like to re-use but not using all of
the records and would like to hide some rows. Is there a way of doing this,
please???

Alexandra Zwick
Click to expand...

Not if users have access to the table datasheets (in general, they shouldn't).

You can create a Query selecting only those records you want the users to see,
and make that query available to the user.

If these are independent, unrelated databases, you might want to import the
table (or just make a copy of the entire database) and delete the unwanted
records from the copy.

John W. Vinson [MVP]
 
Top