[AccessD] Tab Control Locking

Kostas,
I prefer to hide the tab versus hide all the controls.
In design view, click on one of the tabs
In tab (Page) control properties... under format change visible to No.
When the person enters the correct password - turn visible to yes.

   Me.PageName.Visible = True ' I prefer to use the page name vs the page index.

HTH

Jim 
jhewson at karta.com
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas Konstantinidis
Sent: Tuesday, May 29, 2007 12:39 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Tab Control Locking

Hi Jim..
sorry for thedelay to your quickly response
but it happened because of a big crash in my PC (I have already bought a new 
one...)
hmm that's what I need for...  but I don't know how to do it..
many many thank's
/kostas


----- Original Message ----- 
From: "Jim Hewson" <JHewson at karta.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, May 26, 2007 6:01 PM
Subject: Re: [AccessD] Tab Control Locking


>
> You could also hide the controls on the tab until the password is correct.
> Hide the controls by default then when the password is correct unhide 
> them.
>
> Jim
> jhewson at karta.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
> Sent: Saturday, May 26, 2007 1:41 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Tab Control Locking
>
> Hi Kostas
> I think you'll need to lock all of the controls within a tab rather than 
> the
> tab itself. A simple way to do this is to drop a subform on the tab and 
> put
> all of your controls in that. Then you need only set the subform locked 
> and
> unlocked.
>
> -- Andy Lacey
> http://www.minstersystems.co.uk
>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
>> Kostas Konstantinidis
>> Sent: 25 May 2007 10:22
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] Tab Control Locking
>>
>>
>> Hi group,
>> is that possible to lock a tab control form asking when cliking for a
>> password?
>>
>> many thank's
>> /kostas
>>
>>
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com