?
Solved

Email on Ribbon disappears when user is using Runtime Version of MS Access 2010.

Posted on 2012-09-20
8
Medium Priority
?
630 Views
Last Modified: 2012-10-10
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.
0
Comment
Question by:cnrlzen
  • 5
  • 3
8 Comments
 
LVL 85
ID: 38421355
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
 

Author Comment

by:cnrlzen
ID: 38421641
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
 
LVL 85
ID: 38421959
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
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Author Comment

by:cnrlzen
ID: 38422015
<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
 
LVL 85
ID: 38422245
Do you get the Export to Excel item?

I've had much better luck recreating the entire Ribbon, and setting startFromScratch="true"
0
 

Author Comment

by:cnrlzen
ID: 38422777
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
 

Accepted Solution

by:
cnrlzen earned 0 total points
ID: 38428789
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
 

Author Closing Comment

by:cnrlzen
ID: 38480865
This solved the issue.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
MS Outlook undoubtedly is the most widely used email client.Its user-friendliness, cost effectiveness, and availability with Microsoft Office Suite make it the most popular email application.  Its compatibility with Microsoft applications like Exch…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question