Programatically hide/unhide reports & tables

  • Thread starter Thread starter Jeff Clark
  • Start date Start date
because my access database must go out to the internet and get some settings
which are saved into a hidden table and will be displayed on a report. The
user wants to see the report and the underlying table, but I don't want him
to delete or change the settings table, which would mess up the report. He
may also delete or change data in the table.
Next question?
 
No user EVER needs to see a table in order to see everything in a table. You
can easily create a form that looks like a datasheet, but has all the
control of having events (something not available with a table or query) and
allows you to show or hide whatever you wish.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I am not such a CONTROL FREAK. I just want to get it out his way because it
is clutter to him. I don't want to rope him down and strap blinders on him
like so many IT people would.
 
Jeff, The only control is the data's integrity. It is the absolute
resonsibility of the database developer to ensure that the data maintains
integrity. It is nearly impossible to do that if you let users into tables.
If you preface a table name with "USys" as in "USysMyTable", the table will
ordinarily be hidden, unless "Show hidden objects" is turn on in Access
options.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Jeff Clark said:
I am not such a CONTROL FREAK. I just want to get it out his way because it
is clutter to him. I don't want to rope him down and strap blinders on him
like so many IT people would.
Click to expand...

I have seen nothing in your posts to explain why you need to hide the table
programmatically. Just hide it and be done with it.
 
I appreciate the Utablename tip.
I need to hide the table programatically because The User hits a button
which causes Access to hit the internet and download the latest version of
two tables. This causes them not to be hidden. I am hiding one, just to
get it out of his way. The other table he may very well want to delete or
alter the table, and it is his perogative.
I am not interested in controling his behaviour.

So very very very very often a user will make a request and some IT guy will
come along and say, "What do you need that for?" -Not in a "give me
information" sense, but in a skeptical, "you are a stupid user" point of
view, "and unless I stop you, you will make my life as an IT guy harder.
This information is SO important, because I am important and I control it.
You, the stupid user will cause a National Emergency Unless I the HERO stop
you".

Maybe people need that where YOU work, but that is not what this is about.
This guy is looking at the data and refining it, and is welcome to do
anything he wants with it.
Thanks
 
Back
Top