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?
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?
in the accdb, set the option to NO tabs.
save as accde
then try it in runtime.
I'm using the Dutch version of Acccess.
Where can I find the options NO Tabs?
Can you add a screenshot?
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)
I found the option.
Still tabs in the menu in accde.
Is there another solution?
I found this setting.
If I change it to overlapping windows the menu is still with tabs.
Is there another solution?
I think I am not understanding what you mean by 'Menu'
I mean the commandbar. See the attachment of my first post.
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
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.
I added complete screenshots of the program
MDE
ACCDE
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?
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.Or use this newer method of RunCommandCode:DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
https://msdn.microsoft.com/en-us/lib.../ff821354.aspx
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.