Results 1 to 5 of 5
  1. #1
    Cleave_1b is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    27

    Tab Control Pages

    Re: https://www.accessforums.net/program...tml#post237419



    Long ago I created a form with tabs. I now want to intercept an attempt to access one of the tabs (if statement...). The above explanations seem to be great for that with one exception for me: How do I find the name of my tab control? It will probably be viewed as a simple matter but it has me stumped.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Find it same way as for any other control - on the Properties sheet. In design view, select the page and look at the All tab of Properties sheet.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Cleave_1b is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    27
    What I see there is the name of a tab. I see other postings such as :
    Private Sub YourTabbedControl_Change()
    Select Case YourTabbedControl
    Case 0 'First Page
    'Code for Page 1
    Case 1 'Second page
    'Code for Page 2
    Case 2 'Third page
    'Code for Page 3
    End Select
    end sub

    Where I think the 0/1/2 refer to the tabs and those could also be referred to by the tab name. Are these the "YourTabbedControl" I'm looking for?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Select the Tab control by clicking next to the last tab. Select any Page of the Tab control by clicking directly on any tab. The properties listed will change.

    Pages of a tab control also have a PageIndex property. The PageIndex of a selected tab becomes the value of the tab control. So the code you show is reading the value of tab control as set by selecting a page (tab).

    If the Tab control value is 0 then the page with PageIndex 0 has focus.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Cleave_1b is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    27
    "...by clicking next to the last tab..."

    That was the answer I needed. Thank you!

    Dick

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Anchor pages in tab control
    By snoopy2003 in forum Programming
    Replies: 2
    Last Post: 03-24-2012, 08:26 AM
  2. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM
  3. pages
    By hokie in forum Reports
    Replies: 0
    Last Post: 07-16-2009, 10:08 AM
  4. Using tab control pages
    By queenbee in forum Programming
    Replies: 1
    Last Post: 02-28-2009, 09:43 PM
  5. Tab Control Pages
    By queenbee in forum Access
    Replies: 1
    Last Post: 02-28-2009, 10:21 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums