Results 1 to 15 of 15
  1. #1
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163

    How to change active navigation button when open a new form?

    If there are multiple navigation buttons on the form (e.g. Home , Download, Upload, Exit)

    For example, when I open form Test_Record, the default active navigation button is the first button Home, how to change it to navigation button Download ?

    Active navigation button is highlighted with darker color by Access system.



    Maybe I need some codes in Form_Load?

    Thanks.

    Click image for larger version. 

Name:	Default.JPG 
Views:	26 
Size:	11.8 KB 
ID:	35514

    Code:
    Private Sub Form_Load()
    
    
    
    
    
    
    End Sub

  2. #2
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    By the way, is it possible to have multiple rows of Navigation Buttons?

    Thanks.

  3. #3
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    Actually, I should call it navigation menu

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Change the PageIndex property of each page(tab).

    Yes, can have multiple rows. Set the Tab control MultiRow property to Yes.
    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
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    Quote Originally Posted by June7 View Post
    Change the PageIndex property of each page(tab).

    Yes, can have multiple rows. Set the Tab control MultiRow property to Yes.
    What's page index, and where is the property for page index?

    Thanks.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    This a Tab control? Or a Navigation form?

    If this is a Tab control, click on the tab so the tab page area is outlined, then look at Format tab on the Properties Sheet.

    Page Index sets the display order of tabs.
    Last edited by June7; 09-18-2018 at 12:45 PM.
    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.

  7. #7
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    Quote Originally Posted by June7 View Post
    This a Tab control? Or a Navigation form?

    If this is a Tab control, click on the tab so the tab page area is outlined, then look at Format tab on the Properties Sheet.

    Page Index sets the display order of tabs.
    It is navigation form.

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    I never use Navigation form.

    If you want to change the order of the 'tabs', then change the NavigationTarget and Caption properties.

    A Navigation form can have 2 levels of tabs. This is in option when selecting Navigation form from the Create tab on ribbon.
    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.

  9. #9
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    Quote Originally Posted by June7 View Post
    I never use Navigation form.

    If you want to change the order of the 'tabs', then change the NavigationTarget and Caption properties.
    I changed Tab Index in property, actually it is not the feature. For example, even if I changed Download tab index to 0 and changed Home tab index to 1, when I open the form, it still highlight the first tab Home.

  10. #10
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Right, so change NavigationTarget and Caption properties.
    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.

  11. #11
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    Quote Originally Posted by June7 View Post
    Right, so change NavigationTarget and Caption properties.
    Not sure what you refer to, could not find Caption properties.

    I am talking about Navigation menu (Tab CREATE > Navigation )

    Maybe I should call it Navigation buttons in Navigation Control.

  12. #12
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Yes, that is Navigation form. I never use Navigation form.

    In design view, select tab, Caption property is on Format tab of Property 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.

  13. #13
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    Quote Originally Posted by June7 View Post
    Yes, that is Navigation form. I never use Navigation form.

    In design view, select tab, Caption property is on Format tab of Property Sheet.
    No, Navigation target: a list of forms, not navigation buttons. Doing so does not solve my problem.

    I think I would like to make my question clear again:

    Take post #1's screenshot for example, I have three navigation forms: Home, Download, Upload. I have four navigation buttons (Home, Download, Upload, Exit) in each of those three navigation forms. Now no matter which form I open, it always highlight the first navigation button Home. Even if it does not affect anything, it does not look good to me. That being said, when I open the form Download, I want the navigation button Download (in navigation form Download) to be highlighted. There are no subform, just three independent forms. I mean, if I click Download button(when I am already on Download navigation form), it can highlight Download button; but it can not highlight Download button when the program opens the navigation form Download initially.

    Take https://sharepointmaven.com/sharepoint-services/ for example, when I am on Services page, button Services has been highlighted. I don't want to see button Home being highlighted while I am actually on Services page. I want the "highlight" to be able to switch to corresponding button, not staying on the first button Home, even if it can switch to other page. When I am on Services page, button Services should be highlighted; when I am on Training page, button Training should be highlighted;....

  14. #14
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    @VAer most developers for Access avoid the inbuilt navigation forms like the plague , as they are awkward a to work with and utilise a "switched out" style of sub-forms to display your forms, which means lots of things stop working.

    If you want proper control over a Form that provides a navigation type experience, simply create a normal blank form and add a tabbed control.
    You will then be able to program get the functionality you need.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  15. #15
    VAer is offline Competent Performer
    Windows 10 Access 2013 32bit
    Join Date
    Sep 2016
    Location
    USA
    Posts
    163
    Quote Originally Posted by Minty View Post
    @VAer most developers for Access avoid the inbuilt navigation forms like the plague , as they are awkward a to work with and utilise a "switched out" style of sub-forms to display your forms, which means lots of things stop working.

    If you want proper control over a Form that provides a navigation type experience, simply create a normal blank form and add a tabbed control.
    You will then be able to program get the functionality you need.
    It is just my learning experience about Access application, thanks for the comment, I will search some youtube videos about tabbed control. I will learn it if it is a better choice.

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

Similar Threads

  1. Replies: 12
    Last Post: 07-15-2019, 06:33 PM
  2. Replies: 1
    Last Post: 08-06-2018, 10:57 AM
  3. Replies: 4
    Last Post: 07-20-2015, 07:11 AM
  4. subform to open form w/ active master record
    By spitfire122 in forum Access
    Replies: 1
    Last Post: 06-28-2011, 04:28 PM
  5. Replies: 3
    Last Post: 10-18-2009, 09:17 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