Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24

    Using Tabbed controls and Command Buttons together


    Hi:

    I would like to use a tabbed control to break a large form down into parts for easy viewing. I also want to be able to add new records, remove records, search, first, previous, next, and last command buttons. How do I do that when I am only using a tabbed control as my form please? Thank you. I am using Windows 8.1 and Access 2007.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,640
    The tab control is used to organize controls bound to the form's RecordSource - no subforms on the tab control? If so, command buttons on form will work just as if tab control was not there.
    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
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24
    my Tabbed control object will have 4 or 5 tabs and a sub form on each tab ( I am intending it to be my form)? Do I still put buttons on the main form? Thank you.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,640
    Can certainly put buttons on main form, however, if what you want are buttons for code to manipulate records of each subform, probably better to set the subforms as Continuous View and put buttons on the forms that are used as subforms.
    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
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24
    DO I only place one set of buttons on the first tab and that will control the rest of the tabs? I am spreading one table over several tabs. Is that what is meant by continuous?Thank you for helping me with this.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,640
    I don't understand why you are using subforms.
    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
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24
    To display the information on the tabbed control.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,640
    Don't need subforms to display the data from one table on tab control.

    If you are actually displaying a different table on each page of tab control - that is different.
    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
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24
    I will have 4 or 5 tabs. Not sure how many yet but at least 4. How do I find Continuous? What option is that?

    Thank you again for helping me.

  10. #10
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,640
    Set Continuous View in DefaultView property of form.

    Still not clear what you will display on tab control. Do you want to display data from multiple tables?
    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
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24
    If I am not using subforms where do I put my buttons now? On the main form?

  12. #12
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24
    I am using tabbed controls to spread data out that comes from a table with many fields? I want the data to be viewed easily. I found the continuous option! Thank you.

  13. #13
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,640
    If you are displaying data from ONLY one table, don't use subforms.

    Bind form to the table (or query) and then drag textboxes (or comboboxes, listboxes, etc) to pages of tab control.
    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.

  14. #14
    SSUTTON is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2015
    Posts
    24
    Do you put the buttons on the tab control then or under it (on the main form) if you have continuous?

  15. #15
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,640
    If not using subforms, put buttons directly on the form, not on tab control.
    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.

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. command buttons
    By hijack61 in forum Access
    Replies: 4
    Last Post: 11-19-2011, 04:59 PM
  2. Command Buttons
    By BLD21 in forum Access
    Replies: 2
    Last Post: 05-10-2011, 06:27 AM
  3. Command Buttons
    By Rosier75 in forum Access
    Replies: 3
    Last Post: 03-09-2011, 11:59 AM
  4. command buttons
    By nashr1928 in forum Forms
    Replies: 23
    Last Post: 10-15-2010, 04:09 PM
  5. Command buttons
    By maintt in forum Forms
    Replies: 3
    Last Post: 08-03-2010, 09:52 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