Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45

    Menu accde access runtime 2010 without tabs?

    A mde under access runtime 2010 shows no tabs in the menu.


    A accde under access runtime 2010 shows tabs in the menu.

    Zie attachment for example.

    Is it possible to have menu a accde under runtime 2010 without tabs?
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    in the accdb, set the option to NO tabs.
    save as accde
    then try it in runtime.

  3. #3
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    I'm using the Dutch version of Acccess.
    Where can I find the options NO Tabs?
    Can you add a screenshot?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Microsoft keeps moving the options around. Since I dont have 2010:

    open your db,
    menu: file, options (or Settings.... something like this)
    then there is a radio button to view as TABS or (not tabs)

  5. #5
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    I found the option.

    Still tabs in the menu in accde.

    Is there another solution?

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    It's in there. It should be in the Current Database section of the Options. I think what you are after is something we call Overlapping Windows. I can't remember what version this screenshot is from. I believe it is 2010.

    .
    Click image for larger version. 

Name:	OverlappingWindows.jpg 
Views:	25 
Size:	53.7 KB 
ID:	25551

  7. #7
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    I found this setting.

    If I change it to overlapping windows the menu is still with tabs.

    Is there another solution?

  8. #8
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I think I am not understanding what you mean by 'Menu'

  9. #9
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    I mean the commandbar. See the attachment of my first post.

  10. #10
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I will be unable to view your attachment. However, I can guess you are referring to the Ribbon and Groups. You can hide the Ribbon via code.

    Perhaps this thread will be some help ...
    http://stackoverflow.com/questions/1...-ribbon-onload

  11. #11
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    This works too well. The whole ribbon is gone.

    I want the commandbar the same as mde under runtime 2010.

    Click image for larger version. 

Name:	Knipsel.JPG 
Views:	24 
Size:	42.2 KB 
ID:	25561

    Is this possible?

  12. #12
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    In 2007, Microsoft decided to start using the Ribbon for its Office suite of applications. I looked at the illustration you provided in post #11 and I am uncertain as to what, exactly, I am looking at. As you mentioned, you are looking for a way to interact with the commandbar. I believe this is correct. Apparently, your MDE has custom commandbar objects.

    I believe you are able to create custom Groups with the Ribbon using the Commandbar Collection. Unfortunately, this is not an easy thing to do. I find it easier to use the old Shortcut Menu associated with the mouse right click. In other words, I depend custom Shortcut Menus and I hide the Ribbon and the Quick Access Toolbar
    https://msdn.microsoft.com/en-us/lib...(v=vs.85).aspx

    Here is some info on creating custom shortcut menus. Understand that Shortcut menus are superseded by the Context Menu. Just like the Ribbon is replacing the old menu options.
    https://www.accessforums.net/showthr...ghlight=policy

    As I mentioned, you can create custom Ribbons. You can also customize the QAT and create custom Context Menus. Here is some info on Custom Ribbons.
    https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

    https://support.office.com/en-us/art...ID=HA010211415

    There are other resources and examples if you are interested in pursuing custom Ribbons.

  13. #13
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    I added complete screenshots of the program

    MDE
    Click image for larger version. 

Name:	Knipsel.JPG 
Views:	20 
Size:	43.4 KB 
ID:	25563

    ACCDE
    Click image for larger version. 

Name:	Knipsel.JPG 
Views:	20 
Size:	54.9 KB 
ID:	25562

    I explain what we did.
    #1
    You have a 2002 project (mdb). Make a mde of it and run it with access runtime 2010 you get NO ribbon with the add in tab with the toolbar(s).
    Yout got the toolbars the same as in Access 2002/2003.
    #2
    Make a accdb of the mdb and make a accde. Run it with access runtime 2010 and get the ribbon with the add in tab with the toolbar(s).

    We tested with custom groups in the ribbon.
    This has a lot of disadvantages appending to the toolbar menu.

    We now converted the toolbars to a table.
    From the table we build the toolbars with the commandbars object.
    That works perfect.

    The last thing we want is the ribbon not visible and only the toolbars visible.

    Because a mde under access runtime 2010 only shows the toolbars we think this is possible.

    Is there a solution to do this?

  14. #14
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    It is possible but you have to use XML and create a custom Ribbon. It has been a while since I have worked with this stuff and my memory of the correct terms is not perfect. Bottom line, what you have there is a feature that Microsoft is deprecated. Microsoft does not want to use the custom toolbar anymore. Having said that, each of those tools you have in your toolbar/commandbar things should still be available via their policy ID's. Additionally, the custom toolbar things you have there should be able to be incorporated into a Custom Ribbon. As you can see, Access tries to incorporate your custom toolbars automatically. However, this is not fully customized because Access will also include menu items and tools you may not want your users to use/employ. The solution is to customize.

    Why not create custom command buttons on your forms? I still have some legacy VBA that goes after old Menu Versions. For instance, here is some code to save a record using the records menu.
    Code:
    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    Or use this newer method of RunCommand
    https://msdn.microsoft.com/en-us/lib.../ff821354.aspx

  15. #15
    BrightSoftware is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    45
    We tested with the Ribbon.
    Its has a lot off disadvantages.
    For example the record navigation buttons next en previous are not automatically disabled when on the last or first record.
    The toolbar does that automatically.

    Create custom bars on forms is a lot of work when you have a lot of forms.

    We also use a toolbar for reports. Is not possible to create buttons on a report.
    We use custumized buttons on the toolbar for reports.
    For example for some reports we have to save that the report is printed to a printer.

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

Similar Threads

  1. ACCDE run on both ACCESS 2010 32 and 64 bit
    By ghervis in forum Programming
    Replies: 5
    Last Post: 02-05-2016, 05:42 PM
  2. Replies: 2
    Last Post: 08-22-2015, 11:26 AM
  3. Replies: 1
    Last Post: 12-05-2013, 02:57 AM
  4. Replies: 3
    Last Post: 04-21-2013, 06:48 AM
  5. Access 2010 will not allow me to make ACCDE
    By MFS in forum Programming
    Replies: 3
    Last Post: 02-15-2013, 11:00 AM

Tags for this Thread

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