Debbie
delam at zyterra.com
Tue Jun 8 16:05:12 CDT 2010
Well, since I finally had a reproducable example I found something very strange. Many reports get criteria from forms that have drop down lists set on open in code depending on the report. If that particular report has a value list and only that value list is selected, the button goes gray. If a combo with a Table/Query source is selected the button is enabled. If a Table/Query source combo is created after open, it does not affect the button being enabled at all. Well, I can eliminate the problem, but the why is bugging me. I am not sure I have eliminated the problem completely with this revelation. I would feel better knowing how this might affect the close button so I can look for similar causes. If anyone sees anything let me know. Debbie Sent from my iPhone On Jun 1, 2010, at 2:34 PM, Debbie <delam at zyterra.com> wrote: > 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 >