cnrlzen
asked on
Email on Ribbon disappears when user is using Runtime Version of MS Access 2010.
I have a crossover of Full version of Access users and others who have the runtime installed who need some additional functionality like being able to compact and repair or email documents.
I did create a custom tab/ribbon and added it as my ribbon to use but those items do not show on the ribbon when a user is running the runtime version.
I did create a custom tab/ribbon and added it as my ribbon to use but those items do not show on the ribbon when a user is running the runtime version.
ASKER
This is a standalone database that imports a users old data into a new version and part of the issues surrounds compiling so the autonumber refresh. There is no backend to work with and from what I know you can't compact and repair the database you are in, or am I wrong with this?
I did it using the USysRibbon table way.
I did it using the USysRibbon table way.
You are correct - you cannot compact/repair the current database through code.
Can you show the XML you're using to create the ribbon?
Can you show the XML you're using to create the ribbon?
ASKER
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabCreate" visible="false" />
<tab id="dbCustomTab" label="My Custom Tab" visible="true">
<group id="dbCustomGroup" label="Exporting">
<control idMso="FileSendAsAttachmen t" label="E-Mail" enabled="true"/>
<control idMso="FileSaveAsPdfOrXps" label="Export to PDF" enabled="true"/>
<control idMso="ExportExcel" label="Export to Excel" enabled="true"/>
</group>
<group id="dbCustomGroup2" label="DB Maintenance">
<control idMso="FileCompactAndRepai rDatabase" label="Compact and Repair" enabled="true"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
<ribbon startFromScratch="false">
<tabs>
<tab idMso="TabCreate" visible="false" />
<tab id="dbCustomTab" label="My Custom Tab" visible="true">
<group id="dbCustomGroup" label="Exporting">
<control idMso="FileSendAsAttachmen
<control idMso="FileSaveAsPdfOrXps"
<control idMso="ExportExcel" label="Export to Excel" enabled="true"/>
</group>
<group id="dbCustomGroup2" label="DB Maintenance">
<control idMso="FileCompactAndRepai
</group>
</tab>
</tabs>
</ribbon>
</customUI>
Do you get the Export to Excel item?
I've had much better luck recreating the entire Ribbon, and setting startFromScratch="true"
I've had much better luck recreating the entire Ribbon, and setting startFromScratch="true"
ASKER
No excel was excluded, just the PDF one was active.
The email one is on the normal Print Preview when a report was open but not for the runtime users.
The email one is on the normal Print Preview when a report was open but not for the runtime users.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This solved the issue.
Note that the runtime does not allow certain things. I'm not sure if the runtime allows the user-click Compact or not (you can compact from code in the Runtime, of course).