Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rating: Thread Rating: 9 votes, 5.00 average. Display Modes
Old 12-12-2008, 07:55 AM   #1
AOsment
Registered User
 
Join Date: Jan 2008
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
AOsment is on a distinguished road
Missing Ribbon Buttons on report at Runtime

I am currently trying to create a custom ribbon for reports in Access 2007. I created the table UsysRibbons and added the group for email:

<group id="Email" label="Email">

<control idMso="FileSendAsAttachment" label="Email" enabled="true" size ="large"/>
</group>

It works fine when I'm running the accdb. But once I create the accde and use 2007 runtime to open it the group shows no buttons. I have other groups for closing and printing and they work fine. Any suggestions?

AOsment is offline   Reply With Quote
Old 12-12-2008, 08:35 AM   #2
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,829
Thanks: 56
Thanked 1,032 Times in 998 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Missing Ribbon Buttons on report at Runtime

in early versions of access you dont get much with runtime - eg none of the data handling buttons etc - i suspect that is why you are seeing only a minimum configuration

you have to program all required facilities, or get your users to spend the £80 or so to get an access upgrade, i think
although you say your users do get certain ribbons?
gemma-the-husky is offline   Reply With Quote
Old 12-12-2008, 10:21 AM   #3
AOsment
Registered User
 
Join Date: Jan 2008
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
AOsment is on a distinguished road
Re: Missing Ribbon Buttons on report at Runtime

Currently the icons that work on the ribbon are Export to Word, Print Preview and Close. Previously I had the icons to save the report as HTML and Snapshot file. These icons did not work with the runtime. Then I added the icon for FileSendAsAttachment which also does not work. We're in the process of converting all of our Access 2003 applications to 2007. In 2003 we used toolbars to handle the report functions.

AOsment is offline   Reply With Quote
Old 12-12-2008, 01:39 PM   #4
Vonnie
Newly Registered User
 
Join Date: Aug 2008
Location: Pacific Northwest
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Vonnie is on a distinguished road
Re: Missing Ribbon Buttons on report at Runtime

could you send more of the XML? Just one little typo will mess things up. Below is what I use, not control but button. Also I frequently forget to shut down the app and restart to see changes.

<button idMso="FileSendAsAttachment" size="large"/>
Vonnie is offline   Reply With Quote
Old 12-15-2008, 04:57 AM   #5
AOsment
Registered User
 
Join Date: Jan 2008
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
AOsment is on a distinguished road
Re: Missing Ribbon Buttons on report at Runtime

Here's what I have. I downloaded a Ribbon Customizer which actually adds the xml for you:

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<tabs> <tab idMso="TabHomeAccess" visible="false"/>
<tab id="dbCustomTab" label="ORBITRibbon" visible="true">
<group id="Export" label="Export">
<control idMso="ExportWord" label="Word" enabled="true" size ="large"/>
<button id="ExpExc" label = " Export to Excel " imageMso="ExportExcel" onAction="Ribbon.ManualExportToExcel" size="large"/>
</group>
<group id="Email" label="Email">

<control idMso="FileSendAsAttachment" label="Email" enabled="true" size ="large"/>
</group>
<group id="Print" label="Print">

<control idMso="PrintDialogAccess" label="Print" enabled="true" size ="large"/>
</group>
<group id="Close" label="Close">

<control idMso="PrintPreviewClose" label="Close" enabled="true" size ="large"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
AOsment is offline   Reply With Quote
Old 01-14-2009, 08:19 AM   #6
Vonnie
Newly Registered User
 
Join Date: Aug 2008
Location: Pacific Northwest
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Vonnie is on a distinguished road
Re: Missing Ribbon Buttons on report at Runtime

I did a test app, used your exact coding, created a runtime accde and it worked perfectly. If you have the correct references (and I assume you have since everything else works), it might be the Office Install or the default Email setup.
Have you tried the accde on another machine?
Vonnie is offline   Reply With Quote
Old 01-14-2009, 11:11 AM   #7
AOsment
Registered User
 
Join Date: Jan 2008
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
AOsment is on a distinguished road
Re: Missing Ribbon Buttons on report at Runtime

I think the problem is our command line for launching the database. In Access 02 we used 2 switches when launching the mde the RO (read only) and Runtime. If I open the accde from just double clicking on it everything works fine. If we launch it using a command file:
"C:\Program Files\Microsoft Office\Office12\MsAccess.exe" /runtime "\\somedrive\somefolder\somedatabase.accde" it no longer works. If we take /runtime out then the users have access to the database window. I know there is an option to hide the database but some of our users are smart and they don't need to figure out any way to get access to the queries and tables.
Thanks!


AOsment is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
show and hide text from one Report by 2 buttons saman Reports 0 07-18-2007 10:12 AM
Text missing in e-mail report Haynesey Reports 0 08-15-2005 11:48 PM
missing last entry in my report deekras Reports 1 10-20-2003 11:15 AM
Missing report Tech Chimp 05 Reports 1 07-15-2002 12:24 PM
Save form, Close, Print Report and goto another form all in one button ? anthonyevans Forms 2 04-20-2001 06:24 AM




All times are GMT -8. The time now is 05:11 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World