[AccessD] Access Data Page - Change heading text on the fly

Darren,

 

It's been awhile since I played with DAPs...but can you use a CASE statement when the page loads...that reads your connect string...determine the heading...and set the appropriate text?

 

Thanks,

 

Mark A. Matte
 
> From: darren at activebilling.com.au
> To: accessd at databaseadvisors.com
> Date: Fri, 27 Feb 2009 12:13:25 +1100
> Subject: [AccessD] Access Data Page - Change heading text on the fly
> 
> Hi team
> 
> I have approx 10 Data Access Pages DAP (The Web pages that Access lets you
> 'play' with) - All identical - Just pointing to different SQL SVR Db's
> 
> I have worked out how to change the syntax to open one of these and then pass
> the relevant Connection string to the relevant dB so I can just have 1 to
> maintain - WooHoo
> 
> 
> 
> No all I need to do is change the text in the heading label
> 
> On the DAP in design view, the item is referred to in the property sheet as Id
> and I have called it label0 and I have given it an innertext of "MyHeading"
> 
> Anyone know how to change this text on the fly?
> 
> Many thanks in adavance
> 
> Darren
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Access your email online and on the go with Windows Live Hotmail.
http://windowslive.com/online/hotmail?ocid=TXT_TAGLM_WL_HM_AE_Access_022009