[AccessD] change tab control's page on open...

Heenan, Lambert Lambert.Heenan at AIG.com
Tue Feb 12 16:01:46 CST 2008


Glad to be able to help.

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas
Konstantinidis
Sent: Tuesday, February 12, 2008 4:57 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] change tab control's page on open...


Hi Lambert
Every tab page keeps filtering dates data from a central year table which
counts month by month like an attendance register of a people in a gym

now it works perfect

Many thank's
/kostas

----- Original Message ----- 
From: "Heenan, Lambert" <Lambert.Heenan at aig.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, February 12, 2008 11:12 PM
Subject: Re: [AccessD] change tab control's page on open...


> Well this little piece of code would do the trick...
>
> Private Sub Form_Load()
> Dim nPage As Long
>    nPage = Month(Date)
>    tabControl1.Pages(nPage - 1).SetFocus
> End Sub
>
> But I wonder what these 12 tab pages are doing. I hope you don't have 
> a table structure where there are different fields for different 
> month's data entry instead of just one set of fields and a date time 
> stamp on each record.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas 
> Konstantinidis
> Sent: Tuesday, February 12, 2008 3:14 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] change tab control's page on open...
>
>
> hi group,
> In a form I use a subform with a 12 pages tab control inside the 
> titles
> are
> 01 to 12 which means 12 months of a year
>
> What I want to do is when the system's date changes
> my form to be able to open on the corresponding tab page
> e.g. when the system date will be 01/03/2008 my form to be open on tab 
> conttrol's page with the title 03
>
> Is that effectible
>
> thank's a lot
> /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



More information about the AccessD mailing list