How do Hide a table through a macro?

D

Doug

I have imported a table through a macro into a database that has, by
neccesity, all of the tables hidden. When I import any new table it
automatically makes the new table visible. I can not open the database and
use the commands in the toolbar as I am not always available, and many times
others are using the system. So I must set it up so the macro automatically
hides the table.

I assume I can use the runcommand 'hide table' in the macro, but how would
you write the condition to make the new table hidden? The table name is
'meds'.
 
S

Steve Schapel

Doug,

I do not know of a way to do this (although there may be one). However,
I normally have the Database Window itself hidden in a production
environment, so the hiding of tables is never an issue. Could you do
that too?
 

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

Drop down list control value in vba 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Match table shading (color) to Visio color/Transparency 1
Hide tables macro 0
Hide text in MSWord 2013 using macro 1
Hide rows in table based on 1 empty cel of the same row. 1
How to count table records in a macro 1
How to make scroll bar permanently visible, Word 365 0

Top