Brad Marks
BradM at blackforestltd.com
Thu Mar 10 17:04:09 CST 2011
Lambert, Thanks for the help, I appreciate it. I have things working now with your assistance. Thanks again, Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Thursday, March 10, 2011 4:00 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Is it possible to Programmatically Obtain the Name of all Tabs on a Form? Tab controls have a Pages property, one Page per tab. so you can find out how many tabs with MsgBox "Number of pages in TabCtl1:" & TabCtl1.Pages.Count And you can access the actual tab with TabCtl11.Pages(n) Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Thursday, March 10, 2011 4:41 PM To: Access Developers discussion and problem solving Subject: [AccessD] Is it possible to Programmatically Obtain the Name of all Tabs on a Form? I would like to be able to obtain the names on all TABs on a Form so that I can work with these names in VBA (Access 2007). Thanks for your help, Brad -- 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.