Hi
I have some tables with hidden attribute set to 1. In the query desgn
view , I do not see these tables as expected. But, If I choose the
query wizard to create a new query, then i do see these hidden
tables. How to hide these tables in the query wizard.
Thanks
3  2891 
"KNN" <kn****@gmail.c omwrote
I have some tables with hidden attribute set
to 1. In the query desgn view , I do not see
these tables as expected. But, If I choose the
query wizard to create a new query, then i
do see these hidden tables. How to hide
these tables in the query wizard.
Tools | Options | View | Uncheck "Hidden Objects"
Then, if you "button down" your application sufficiently well (so the user
cannot change that Option), the user will not be able to see it. But, as
the developer, you would be well advised to be able to see and use the
hidden objects -- that is, you should have some reason for their being
there.
I agree with the principle: "If this is an application developed for other
users, users should not have access to Design View." And, would ask the
question: "If it is a database just developed for your own use, why would
you want to permanently hide Tables from yourself?"
As I understand it, the purpose for the Hidden Attribute is that you can
prevent users from seeing the hidden objects in a database application that
you are distributing an application to others for their use, or to hide some
objects just for your convenience, in a database on which you are working,
until you wish to view them again, and it appears to me that it is working
as intended/designed.
Larry Linson
Microsoft Access MVP
On Sep 4, 7:26 pm, "Larry Linson" <boun...@localh ost.notwrote:
"KNN" <knn...@gmail.c omwrote
I have some tables with hidden attribute set
to 1. In the query desgn view , I do not see
these tables as expected. But, If I choose the
query wizard to create a new query, then i
do see these hidden tables. How to hide
these tables in the query wizard.
Tools | Options | View | Uncheck "Hidden Objects"
Then, if you "button down" your application sufficiently well (so the user
cannot change that Option), the user will not be able to see it. But, as
the developer, you would be well advised to be able to see and use the
hidden objects -- that is, you should have some reason for their being
there.
I agree with the principle: "If this is an application developed for other
users, users should not have access to Design View." And, would ask the
question: "If it is a database just developed for your own use, why would
you want to permanently hide Tables from yourself?"
As I understand it, the purpose for the Hidden Attribute is that you can
prevent users from seeing the hidden objects in a database application that
you are distributing an application to others for their use, or to hide some
objects just for your convenience, in a database on which you are working,
until you wish to view them again, and it appears to me that it is working
as intended/designed.
Larry Linson
Microsoft Access MVP
Thanks for the reply.
Probably I should have given you more information.
I have few standard tables, few linked tables and few queries. For
all these objects hidden attribute is set to 1. In the table pane or
the query pane I do not see the these objects as expected. Now, if I
select the design view for creating the queries, application will not
display these hidden objects as expeted, to be part of a new query.
The issue is, if I select simple query wizzard to create a new query,
then the wizzard displays hidden linked tables in the list of tables
and I can create new queries using these hidden linked tables which
defetes the purpose of hiding linked tables.
IMNSHO, if you choose to give the users the ability to create queries, that
implies that you are giving them the ability to view the Database Window and
you are giving them access to Design View, and that is likely a much greater
problem than being able to view hidden tables in the Query Wizard. And, I do
not understand why you'd want to hide the Tables, Queries, or whatevers from
yourself.
Larry Linson
Microsoft Access MVP
"KNN" <kn****@gmail.c omwrote in message
news:11******** *************@y 42g2000hsy.goog legroups.com...
On Sep 4, 7:26 pm, "Larry Linson" <boun...@localh ost.notwrote:
>"KNN" <knn...@gmail.c omwrote
> I have some tables with hidden attribute set
to 1. In the query desgn view , I do not see
these tables as expected. But, If I choose the
query wizard to create a new query, then i
do see these hidden tables. How to hide
these tables in the query wizard.
Tools | Options | View | Uncheck "Hidden Objects"
Then, if you "button down" your application sufficiently well (so the
user
cannot change that Option), the user will not be able to see it. But, as
the developer, you would be well advised to be able to see and use the
hidden objects -- that is, you should have some reason for their being
there.
I agree with the principle: "If this is an application developed for
other
users, users should not have access to Design View." And, would ask the
question: "If it is a database just developed for your own use, why would
you want to permanently hide Tables from yourself?"
As I understand it, the purpose for the Hidden Attribute is that you can
prevent users from seeing the hidden objects in a database application
that
you are distributing an application to others for their use, or to hide
some
objects just for your convenience, in a database on which you are
working,
until you wish to view them again, and it appears to me that it is
working
as intended/designed.
Larry Linson
Microsoft Access MVP
Thanks for the reply.
Probably I should have given you more information.
I have few standard tables, few linked tables and few queries. For
all these objects hidden attribute is set to 1. In the table pane or
the query pane I do not see the these objects as expected. Now, if I
select the design view for creating the queries, application will not
display these hidden objects as expeted, to be part of a new query.
The issue is, if I select simple query wizzard to create a new query,
then the wizzard displays hidden linked tables in the list of tables
and I can create new queries using these hidden linked tables which
defetes the purpose of hiding linked tables.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: mark.reichman |
last post by:
First off.. Thanks to Grant Wagner for help in a previous thread
related to this one.
I am at a total loss... I have multiple fields in a form with the
same name. Lets call the fields with the same name "junk_array". My
first field of junk_array is a input type=hidden. All the others
fields in junk_array that follow are type=text. I can reference this
first hidden field in IE with document.form.field.value. In, fact
my form works...
|
by: Mark McLellan |
last post by:
Dear all
Following the oft-repeated advice here and ciwas I have made my site
nearly 4.01 strict (working on it). There are some items on which I would
appreciate your advice:
1. Hidden fields
http://www.zoo.co.uk/~mmenterprises/contact.htm
I am using FormMail from Matt's Script Archive. The W3C validator
objected to the hidden fields unless I put, say, P round them. That gave
|
by: Michael Donahoe |
last post by:
I have a database that I inherited that has query in it that has
hidden fields when it is in design view. Datasheet view shows the
fields and when I switch back to design view it appears as though
those columns are compressed. If I try clicking between the columns
"<-|->" it does not do anything. I don't have 'Format' in the menu
bar to unhide any of the fields for design view.
Does anyone know how to unhide these columns?
|
by: dixie |
last post by:
If I sent a user an empty database container - dB with no tables and I
needed them to import their tables into it and one of their tables was a
hidden table with the prefix Usys, is there any way in code I can get that
table imported without them having to go to options and show hidden tables
and then import it manually?
dixie
|
by: Gunnar |
last post by:
I am finding some unusual behavior with techniques I am using to
show/hide/update data without having to refresh the page. I'm quite
sure it's developer ignorance on my part and would be grateful for any
suggestions.
My page has 10 tables with their visibility controlled by the user
making a menu selection. For example, selecting menu_1 calls a
function which displays table_1 by setting table_1's style display:
block and hides tables...
| | |
by: Graham Charles |
last post by:
I'm trying to create a standard "hidden" table. However, using this
code, my tables are not displayed in the database window *even* when I
choose to show Hidden and System objects from the Options dialog:
tdf = theDB.CreateTableDef(OptionsTableName)
fld = tdf.CreateField("OptionName",
dao.DataTypeEnum.dbText, 50)
tdf.Fields.Append(fld)
|
by: Farshid |
last post by:
Hi
Is there any way to use Visual Studio Query Builder in Windows Forms
applications.
I think query builder dialog is in Micosoft.VSDesigner assembly but i dont
know how to use it.
Thank You for your help
|
by: pemigh |
last post by:
I'm almost done with an application, and trying to lock it down
tightly. But I still want users to be able to point to a new location
for the data file.
The code below fires off to detect and address the problem of a
moved/renamed data file. The problem: WITHOUT the "tdf.Attributes =
dbHiddenObject" line, my previously hidden tables are now visible.
(Not that the users will normally have the chance to see them, hidden
or not.)
|
by: dba |
last post by:
using the following code with a problem....
echo "<input type='hidden' name='member_id' value=\"{$row}\">{$row}";
echo "<input type='radio' name='member_name'
value=\"{$row}\">{$row}<br />";
The post_data.php program posts the following
member id is: 0009
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
