Hi,

I am testing my new ribbons on a different PC. I am getting a couple
of error messages:

"Can not run the macro OnOpenFormNewRec"
"User defined type not defined"

The last on is a doozy, eh? ;-)

I have the following code for the OnOpen listed above in a module, yet
it is not being recognized:

Public Sub OnOpenFormNewRec(ctl As IRibbonControl)

DoCmd.OpenForm ctl.Tag, acNormal, , , acFormAdd

End Sub

I don't think Access knows what iRibbonControl is (I got the code from
a book).

Any ideas how to fix these errors?

Also, what do I need to include in our distribution for our ribbons to
work (using the runtime version)?

The table USysRibbons and what else?

-paulw

On Sun, 15 Jan 2012 13:21:38 -0700, PW
<emailaddyinsig (AT) ifIremember (DOT) com> wrote:

I forgot to add the reference to the Office 14 object.

On Sun, 15 Jan 2012 13:21:38 -0700, PW
<emailaddyinsig (AT) ifIremember (DOT) com> wrote:

Any way, how do I get rid of the icon that appears with the
application name and "press F1 for help" whenever I mouse over a
button?

-pw

"PW" wrote in message news:eji6h79t15c7n7hd56crg4fpabii81uv0b (AT) 4ax (DOT) com...


No, unfortunately this cannot be changed. The reason is due to a current
policy that custom ribbons has to be distinguishable from built in ones.
(for example you (or malicious code) could change a button to "delete" or do
something nasty. So your buttons are always going to be a "little bit"
different then built in ones.

However, one GREAT issue that was changed from 2007 to 2010 is the forms
"caption" is now displayed in place of form name. In fact, this was a
personal request of mine to the Access team, and they went to bat for me. I
suppose I can never say I was the only one asking for this change, but the
lead of the Access team personally promised me that he would have that
change added from beta to RTM, and in fact that is exactly what occurred.

I quite much stated that without this change, I cannot use ribbons in my
applications.

So, it not ideal, but it does now take the caption (for forms ribbon), as
opposed to using the form name which in my case is often ugly or at the very
least meaningless to my end users.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Mon, 16 Jan 2012 03:46:47 -0700, "Albert D. Kallal"
<PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote:

Well "Press F1 for add-in help" is meaningless to our users because we
don't have a help file. What would it open any way?

Thanks Albert.