Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: unhide objects


Message #1 by "carlier jacques" <jacques.carlier@c...> on Wed, 18 Dec 2002 10:47:09
Hi,

How  could i  unhide  objects  (database window , debugger window)
of a MDB    where  there is only  some icons on the menu bar 
like  printer,search,quit...  and a switchboard menu ???


Many thanks  in advance

J. CARLIER
BRUSSELS



Message #2 by "Foote, Chris" <Chris.Foote@u...> on Wed, 18 Dec 2002 10:54:57 -0000
The "hot key" "F11" will normally open the database window (unless the
cunning designer has disabled it ;0) Jacques.

Regards!
Spike
UK

> -----Original Message-----
> From: carlier jacques [mailto:jacques.carlier@c...]
> Sent: Wednesday, December 18, 2002 10:47 AM
> To: Access
> Subject: [access] unhide objects
> 
> 
> Hi,
> 
> How  could i  unhide  objects  (database window , debugger window)
> of a MDB    where  there is only  some icons on the menu bar 
> like  printer,search,quit...  and a switchboard menu ???
> 
> 
> Many thanks  in advance
> 
> J. CARLIER
> BRUSSELS
Message #3 by joe.dunn@c... on Wed, 18 Dec 2002 11:07:33 +0000
The approach I take is to implement Access security so that users
(including myself) are categorized into groups of users. Some of those
users are 'development' people who I trust to see the 'hidden' objects -
some are not.

I put a button on the switchboard form and show it for users who are
'developers' or 'administrators' and hide it for the others - I do this by
checking that the current user is in a specified group.

So only the 'developer' or 'administrator' sees this button.

When this is clicked, I run code or a macro to unhide the database window.
I then have a 'hide' macro to hide things again afterwards.

Is this the approach that would suit you?



                                                                                                        
                      "carlier                                                                          
                      jacques"                 To:      "Access" <access@p...>                  
                      <jacques.carlier         cc:                                                      
                      @cbc.be>                 Subject: [access] unhide objects                         
                                                                                                        
                      18/12/2002 10:47                                                                  
                      Please respond                                                                    
                      to "Access"                                                                       
                                                                                                        
                                                                                                        




Hi,

How  could i  unhide  objects  (database window , debugger window)
of a MDB    where  there is only  some icons on the menu bar
like  printer,search,quit...  and a switchboard menu ???


Many thanks  in advance

J. CARLIER
BRUSSELS








*************************************************************************

This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s).
 If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return: you should
not disclose the 
contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an authorised individual, nothing
contained in this e-mail is
 intended to create binding legal obligations between us and opinions expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Personal Investment Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 (also regulated by IMRO) - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

********************************************************************************

Message #4 by "carlier jacques" <jacques.carlier@c...> on Wed, 18 Dec 2002 14:10:07
thanks  for your reply..

can you give me the code  (by e-mail)  to  implement  your approach  (
probably with properties)  

thanks in advance  ..+

in fact , i have received from "someone" a mdb with hidden objects
(probably with properties's coding) and i would like to  'examine'
his mdb (modules,tables,queries  ...)
I have tried to launch the debugger (ctr G)
but without success. 
So it' impossible to unhide it ??(shareware ???)  

THANKS;;


> 
The approach I take is to implement Access security so that users
(including myself) are categorized into groups of users. Some of those
users are 'development' people who I trust to see the 'hidden' objects -
some are not.

I put a button on the switchboard form and show it for users who are
'developers' or 'administrators' and hide it for the others - I do this by
checking that the current user is in a specified group.

So only the 'developer' or 'administrator' sees this button.

When this is clicked, I run code or a macro to unhide the database window.
I then have a 'hide' macro to hide things again afterwards.

Is this the approach that would suit you?



                                                                           
                             
                      "carlier                                             
                             
                      jacques"                 To:      "Access" 
<access@p...>                  
                      <jacques.carlier         
cc:                                                      
                      @cbc.be>                 Subject: [access] unhide 
objects                         
                                                                           
                             
                      18/12/2002 
10:47                                                                  
                      Please 
respond                                                                    
                      
to "Access"                                                                
       
                                                                           
                             
                                                                           
                             




Hi,

How  could i  unhide  objects  (database window , debugger window)
of a MDB    where  there is only  some icons on the menu bar
like  printer,search,quit...  and a switchboard menu ???


Many thanks  in advance

J. CARLIER
BRUSSELS








*************************************************************************

This e-mail may contain confidential information or be privileged. It is 
intended to be read and used only by the named recipient(s).
 If you are not the intended recipient(s) please notify us immediately so 
that we can make arrangements for its return: you should not disclose the 
contents of this e-mail to any other person, or take any copies. Unless 
stated otherwise by an authorised individual, nothing contained in this e-
mail is
 intended to create binding legal obligations between us and opinions 
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the 
Personal Investment Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R -
 for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965 
(also regulated by IMRO) - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-
832-8686   Internet  http://www.cis.co.uk   E-mail cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-
operative Bank p.l.c., registered in England and Wales number 990937, P.O. 
Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS 
Policyholder Services Limited as agent of the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

***************************************************************************
*****


  Return to Index