access 2000

D

darren

please could anyone tell me how to hide a row in data base view (access
2000)thanks in advance darren
 
K

Karsten Schultz

darren said:
please could anyone tell me how to hide a row in data base view (access
2000)thanks in advance darren
Click to expand...

Expend your Table by a YesNo-Column "hided".
Mark every row you want to hide.

In your query you ask for every row with
hided = false

Greetings

Karsten
 
J

John W. Vinson/MVP

please could anyone tell me how to hide a row in data base view (access
2000)thanks in advance darren
Click to expand...

If you mean in table datasheet view You Can't. Table datasheets aren't
designed for user interaction, and they're very limited.

Use a Query with criteria to exclude the record, and base a Form on
the query to display and edit the data.
 
K

Karsten Schultz

darren said:
please could anyone tell me how to hide a row in data base view (access
2000)thanks in advance darren
Click to expand...

Expend your Table by a YesNo-Column "hidden".
Mark every row you want to hide.

In your query you ask for every row with
hidden = false

Greetings

Karsten
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Permissions Error 1
Access stripping decimal places in query 1
Excel Help to copy information from one row at a time to another sheet 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Can anyone tell me how to Hyperlink in Access? 2
Access Query about ticking multiple checkboxes 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Data Base with Access 2007 6

Top