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.
cnrlzenAsked:
Who is Participating?
 
cnrlzenConnect With a Mentor Author Commented:
found a solution to the email/exporting:  Use buttons on the ribbon and call a function the sends the report.

<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="dbExport" label="Export Report">
                              <button idMso="DataRefreshAll"  size="large"/>
                                             <button idMso="ExportExcel"  size="large"/>
                                            <button idMso="ExportTextFile"  size="large"/>
                                            <button idMso="PublishToPdfOrEdoc"  size="large"/>
      <button id="CreateEmail" label="Email Report " imageMso="FileSendAsAttachment" enabled="true" size="large" onAction="=MySend()"/>
       </group>
       </tab>
    </tabs>
  </ribbon>
</customUI>
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
How did you create the custom ribbon? Have you set that as the "Ribbon Name" in the Options - Ribbon and Toolbar Options section of your database?

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).
0
 
cnrlzenAuthor Commented:
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.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You are correct - you cannot compact/repair the current database through code.

Can you show the XML you're using to create the ribbon?
0
 
cnrlzenAuthor Commented:
<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="FileSendAsAttachment" 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="FileCompactAndRepairDatabase" label="Compact and Repair" enabled="true"/>
              </group>
      </tab>
    </tabs>
  </ribbon>
</customUI>
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Do you get the Export to Excel item?

I've had much better luck recreating the entire Ribbon, and setting startFromScratch="true"
0
 
cnrlzenAuthor Commented:
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.
0
 
cnrlzenAuthor Commented:
This solved the issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.