Access 2010 Print Ribbon Error: "The expresion you entered has a function that Microsoft Access can't find"

PW

unread,

Nov 9, 2012, 1:24:39 PM11/9/12

to

Hi,

That happens when I click on the Excel, Word, Text, HTML Document,
Email buttons in the print ribbon while a report is in preview mode.

It is only happening with a new application that I wrote, but not with
another application (works great). References are identical.

What did I miss?

Thanks,

-paulw

PW

unread,

Nov 9, 2012, 1:49:53 PM11/9/12

to

By the way, the ribbon XML for the report tab is the same on both
applications:

<customUI
xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
<tabs>
<tab id="MyReport" label="Report Print and View Options">

<group idMso="GroupPrintPreviewPrintAccess" />
<group idMso="GroupPageLayoutAccess" />
<group idMso="GroupZoom" />

<group id="ListCommands" label="Print">
<button idMso="FilePrintQuick" keytip="q" size="large"/>
<button idMso="PrintDialogAccess"
label="Print Dialog"
keytip="d" size="large"/>
</group>

<group id="ExportCmds" keytip="e" label="Data Export">
<button idMso="PublishToPdfOrEdoc" keytip="p"
size="large"/>

<button id="ExportExcel" label="Excel"
imageMso="ExportExcel" size="large"
onAction="=MyExport('XLS')"/>

<button id="ExportWord" label="Word"
imageMso="ExportWord" size="large"
onAction="=MyExport('RTF')"/>

<button id="ExportTextFile" label="Text"
imageMso="ExportTextFile" size="large"
onAction="=MyExport('TXT')"/>

<button id="ExportHtml" label="HTML Document"
imageMso="ExportHtmlDocument" size="large"
onAction="=MyExport('TXT')"/>

<button id="CreateEmail" label="Email Report (PDF)"
imageMso="FileSendAsAttachment"
enabled="true" size="large"
onAction= "=MySend()"/>
</group>

<group idMso="GroupZoom"></group>

<group id="Exit" keytip="x" label="Exit">
<button idMso="PrintPreviewClose" keytip="c" size="large"/>
</group>

</tab>
</tabs>
</ribbon>
</customUI>

PW

unread,

Nov 9, 2012, 10:08:18 PM11/9/12

to

On Fri, 09 Nov 2012 11:24:39 -0700, PW
<emailad...@ifIremember.com> wrote:

I can't find anything about this error with a report using Google or
Bing. The report previews (so what is the problem?) but these
particular buttons for Office apps (for the most part) cause this
error and do not work. But they don't work on my PC and my wife's PC
but our other application the ribbon works fine (it is not my print
ribbon but Access's). Same code, same report, same settings under
File/Options.

If I remove the name of the USysRibbon name from the Other tab, it
prints fine (using the right-click print option). Same XML code,
works with another of our apps.

This stinks because I have to deliver this application in a couple
days. I am going to have to disable in XML these options for the time
being :-(

-pw

PW

unread,

Nov 13, 2012, 9:53:38 PM11/13/12

to

On Fri, 09 Nov 2012 11:24:39 -0700, PW
<emailad...@ifIremember.com> wrote:

I just created a blank report with nothing on it and I still get the
error. Very frustrating. What could it be? Works with one
application but not another. Exact same code like I said.

PW

unread,

Nov 15, 2012, 2:33:12 PM11/15/12

to

On Fri, 09 Nov 2012 11:24:39 -0700, PW
<emailad...@ifIremember.com> wrote:

We forgot to copy some code from another application that we wrote.
All is well now.

What a good morning!

-pw