Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » access+training+in+london - Macro for hiding database
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access+training+in+london - Macro for hiding database
Resolved · Low Priority · Version Standard
Reply
Macro for hiding database
I would like to know how how to write a macro to hide tables from other users to disallow potential edits on key data.Many thanks.
For upcoming training course dates see: Pricing & availability
RE: Macro for hiding database
Hi CherSorry for the delay in getting back to you but our offices have been closed over the Christmas period. We our now processing all of our forum entries and we will be back to you very shortly with an answer to your question.
David
RE: Macro for hiding database
If you don't want users to see a table in an Access database, you can mark the table as a hidden object.To do this, right-click on the table that you wish to hide and select Properties from the popup menu.
When the Properties window appears, select the checkbox called "Hidden". Then click on the OK button.
and to view these hidden tables in the database window?
goto the Tools menu, select "Options".
When the Options window appears, select the view tab and check the "Hidden objects" checkbox. Then click on the OK button.
This will return you back to the database window where you should now be able to see all hidden objects including the hidden tables that you are looking for.
|
 |
|
» Forum post: Vlookup |
What is Vlookup and how can it be used
