J
Jeff Clark
Hi Buddies!
how can i use a for/each to hide/unhide all reports and tables
thanks!!
how can i use a for/each to hide/unhide all reports and tables
thanks!!
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer
Jeff Clark said:Hi Buddies!
how can i use a for/each to hide/unhide all reports and tables
thanks!
It isn't a particulalrly good idea to let users see the database window
anyway. Why don't you build a form menu and hide the database window in the
startup options?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
J
Jeff Clark
because the guy needs to see a table
Arvin Meyer said:It isn't a particulalrly good idea to let users see the database window
anyway. Why don't you build a form menu and hide the database window in the
startup options?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
J
Jeff Clark
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?
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?
A
Arvin Meyer
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
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
A
Arvin Meyer
What does he need to see in a table that he can't see in a form?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
J
Jeff Clark
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.
is clutter to him. I don't want to rope him down and strap blinders on him
like so many IT people would.
A
Arvin Meyer
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
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
R
Rick Brandt
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.
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.
J
Jeff Clark
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
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
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.