[AccessD] Set Tab name (in tabbed page) via VBA

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________



aaaah, Yes, Gentlemen, this is exactly what I need, along with more than the 5 hours sleep a night I have gotten for the past two nights.

Of course it would be Caption and not Name.  Oddly, I did actually know that, but hey...  stupid does what stupid does when having a brain freeze and major senior moment.

Thanks guys.  Appreciate the heads up - back on track.

cheers
Darryl.

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, 24 March 2011 2:23 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Set Tab name (in tabbed page) via VBA

Why would you want to change the Name property of any control at runtime.  It will break all 
references to the control.  Are you sure it isn't the Caption that you want to change?

-- 
Stuart


On 24 Mar 2011 at 14:05, Darryl Collins wrote:

> 
> ______________________________________________________________________
> _________________
> 
> Note: This e-mail is subject to the disclaimer contained at the bottom
> of this message.
> ______________________________________________________________________
> _________________
> 
> 
> Hi Folks,
> 
> I was pretty confident that this would work just fine.
> 
> Me.tabIntro.Pages.Item(1).Name = "Acceptance Criteria (" &
> gstrPreEstVar(5) & ")"
> 
> but no. When running the code I debug out at this line and  I get a
> very useful error saying I can only do this if the form is in design
> mode. WTF?
> 
> Now, I am missing the bleeding obvious here or is it not possible to
> set the Tab Page name using code?  More likely it is possible, but I
> am going about it completely the wrong way.
> 
> Access 2003 BTW...
> 
> Regards
> Darryl.
> 
> _____________________________________
> 
> Darryl Collins | Business Analyst Database Developer
> Retail Business Insurance
> Insurance Australia Group (IAG)
> Level 2, 181 Williams St, Melbourne, 3000 - Australia
> Ph: + 61 3 9916 3926
> Mobile: + 61 418 381 548
> 
> 
> 
> ______________________________________________________________________
> _________________
> 
> The information transmitted in this message and its attachments (if
> any) is intended only for the person or entity to which it is
> addressed. The message may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use of,
> or taking of any action in reliance upon this information, by persons
> or entities other than the intended recipient is prohibited.
> 
> If you have received this in error, please contact the sender and
> delete this e-mail and associated material from any computer.
> 
> The intended recipient of this e-mail may only use, reproduce,
> disclose or distribute the information contained in this e-mail and
> any attached files, with the permission of the sender.
> 
> This message has been scanned for viruses.
> ______________________________________________________________________
> _________________ -- 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
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________