Doug Murphy
dw-murphy at cox.net
Tue Jun 1 14:50:23 CDT 2010
Debbie, Are you sure you have the report opened in PrintPreview? Access 2007 has several view modes for reports, one of which, layoutview, I think don't supports printing. This is just a guess, but I think I have run into that before. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Debbie Sent: Tuesday, June 01, 2010 12:34 PM To: Access Developers discussion and problem solving Subject: [AccessD] Ribbon problem The Access 2007 I am working on has lots of custom ribbons. The print preview on the report is giving me problems intermittently. The close print preview button will gray out and become disabled. I have not been able to figure out why, but I have been able to reproduce it pretty consistently when I select a criteria from a pop up form. This is not the only time it shows up, but the only one I can reproduce. Using the default ribbon on this same report has a working close print preview. I am including a copy of the ribbon XML in the hope that someone can spot an obvious problem I cannot. <?xml version="1.0" encoding="utf-8"?> <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onRibbonLoad"> <commands> <command idMso="FileExit" enabled="false"/> <command idMso="ApplicationOptionsDialog" enabled="false"/> <command idMso="FileCloseDatabase" enabled="false"/> </commands> <ribbon startFromScratch="true"> <officeMenu> <button idMso="FileOpenDatabase" visible="false"/> <button idMso="FileNewDatabase" visible="false"/> <splitButton idMso="FileSaveAsMenuAccess" visible="false"/> </officeMenu> <tabs> <tab id="tabReportPreview" label="Report Preview"> <group id="grpCommands"> <button idMso="PrintPreviewClose" size="large"/> <button idMso="FilePrintQuick" size="large"/> </group> <group id="grpExport"> <button id="cmdExportPDF" label="PDF" size="large" imageMso="PublishToPdfOrEdoc" onAction="ExportToPDF"/> <button id="cmdExportHTML" label="HTML" size="large" imageMso="ExportHtmlDocument" onAction="ExportToHTML"/> <button id="cmdExportRTF" label="RTF" size="large" imageMso="ExportWord" onAction="ExportToRTF"/> <button id="cmdExportExcel" label="XLS" size="large" imageMso="ExportExcel" onAction="ExportToExcel"/> <button id="cmdExportExcelCustom" label="Custom XLS" size="large" imageMso="TableInsertExcel" onAction="ExportToExcelCustom"/> </group> </tab> </tabs> </ribbon> </customUI> TIA Debbie Sent from my iPhone -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com