MS Access XP question

aza · 8-23-02, 08:02 PM

Currently reading "Access 2002 Bible" book by C.Prague and M.Irwin .... and there was a word at the very beginning about hiding objects ... (right-click on one of the tables, choose properties, and mark checkbox to hide it; there is also field for making description to the object there).

I've hided one of my DB tables but how to get it back visible I can't seem to find, because just can't get to these properties window again (table is hidden)!

Any ideas how to get properties of hidden object in MS Access and so UNcheck that checkbox.

P.S.: I suppose books also should write how to do reverse actions near so called 'Tips' sections.

aza · 8-23-02, 08:13 PM

That's the quote from the book:

TIP

Quote:

You can enter a description for an object by right-clicking on the object name and then selecting Properties or selecting View -> Properties from the Access Menu bar. You can enter long description for the object or you can hide the object.

9-5-02, 05:54 PM

I don't know if this will help.....
Do you remember where the table was saved and the actual name of it? If so, you probably could create a new db and import that table.
I've used this before to re-open a table that got locked up and wouldn't re-open.

Well, that's my 1 1/2 cents worth.

---roystreet

**NMS** · 9-5-02, 06:08 PM

Usually what I do is recreate a whole database not just the table...

However I would suggest you visit a microsoft board and ask the question there, or else do some intelligent searching using google.

Good Luck

9-6-02, 08:06 AM

sure...

from the main db window, go to Tools > Options...

on the View tab, first option on the right hand side is a check box for Hidden Objects. Check it, and you'll see your table.

aza · 9-9-02, 12:02 AM

2lostdreamer: yep, that's what I was looking for. thanks!

Another question - are there any good Access developers 'community' around on the Internet which you could advice for intermediate/expert level? (except Micrsoft's page

)

9-9-02, 01:08 AM

Database Forums

i'm a reg'd user there too, but i must admit: i don't go too often, only bcuz this is my primary forum, and i just don't get enuf sleep as it is!

good luck.

8-23-02, 08:02 PM	#1
aza everything has beauty Join Date: Jan 2002 Location: Kyiv, Ukraine Posts: 268 Reputation: 5	MS Access XP question Currently reading "Access 2002 Bible" book by C.Prague and M.Irwin .... and there was a word at the very beginning about hiding objects ... (right-click on one of the tables, choose properties, and mark checkbox to hide it; there is also field for making description to the object there). I've hided one of my DB tables but how to get it back visible I can't seem to find, because just can't get to these properties window again (table is hidden)! Any ideas how to get properties of hidden object in MS Access and so UNcheck that checkbox. P.S.: I suppose books also should write how to do reverse actions near so called 'Tips' sections. __________________ Yours faithfully, Yaroslav Zaremba

9-5-02, 06:08 PM	#4
NMS Moderator Join Date: Apr 2002 Location: Malta - Europe Posts: 7,108 Reputation: 125	Usually what I do is recreate a whole database not just the table... However I would suggest you visit a microsoft board and ask the question there, or else do some intelligent searching using google. Good Luck __________________ Neville NMS Designs - Website Services & Graphic Design. ThesisAbstracts.com - A website for under-graduates and graduates. Ktieb.com - Sell, Buy and Watch New & Second Hand Books online. Website Agent - Online discounts & Resources for web designers. - new promotions just updated Sell and Buy Stuff Classified - Free of Charge You never have a second chance to make a first good impression!

9-9-02, 12:02 AM	#6
aza everything has beauty Join Date: Jan 2002 Location: Kyiv, Ukraine Posts: 268 Reputation: 5	2lostdreamer: yep, that's what I was looking for. thanks! Another question - are there any good Access developers 'community' around on the Internet which you could advice for intermediate/expert level? (except Micrsoft's page ) __________________ Yours faithfully, Yaroslav Zaremba

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

9-5-02, 05:54 PM	#3
roystreet Posts: n/a	I don't know if this will help..... Do you remember where the table was saved and the actual name of it? If so, you probably could create a new db and import that table. I've used this before to re-open a table that got locked up and wouldn't re-open. Well, that's my 1 1/2 cents worth. ---roystreet

9-6-02, 08:06 AM	#5
lostdreamer Posts: n/a	sure... from the main db window, go to Tools > Options... on the View tab, first option on the right hand side is a check box for Hidden Objects. Check it, and you'll see your table.

9-9-02, 01:08 AM	#7
lostdreamer Posts: n/a	Database Forums i'm a reg'd user there too, but i must admit: i don't go too often, only bcuz this is my primary forum, and i just don't get enuf sleep as it is! good luck.