Open form from Ribbon

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom Ventouris - 20 May 2007 08:31 GMT

Is there a way to open a form from a Ribbon using VB instead of Macro?

Reply to this Message

Albert D. Kallal - 20 May 2007 13:17 GMT

You ribbon code can run code in a form or module.

=YourPublicFunctionName()

So, Just set the on-action to the name of your function

eg:

<button id="button1" label="Buttion1" onAction="=MyTest1()"/>

So, simply place a public function in the form called

Public MyTest1

and, you can have that function in a standard code module also....

So, if you have a bunch of form code, and want to move the code from buttons
on the form to a ribbon, simply have both your buttons on the forms, and the
ribbon code both call the same code:

Private Sub Command18_Click()

MyPrintInvoice

End Sub

And, for the button, you would go:

<button id="button1" label="Buttion1"
onAction="=MyPrintInvoice()"/>

And, then either in the forms module, or a standard public module, you go

Public Function MyPrintInvoice()

....you code here.....

end function

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Albert D. Kallal - 20 May 2007 13:29 GMT

So, lets go:

Public function OpenMyform(strF as string)

docmd.Openform strF

end if

now, to open form customers, you go:

<button id="OpenCust" label="View Customers"
onAction="=OpenMyForm('frmCustomers')"/>

Note how I did use single quotes to pass a string value...it does work...

so, now we have a general re-usable public function that allows you to build
custom ribbon buttons that opens a form of your choosing....

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Tom Ventouris - 20 May 2007 14:22 GMT

Perfect!

It's just what I was looking for to avoid a large number of macros.
I now have Ribbons where and when I want them. It appears that the A2003
Shortcut Menus and Toolbars cannot be created or edited in A2007. I have
posted a question on this before, but, perhaps because A2007 is till new, no
response.

Are you able to shed some light on this? i.e. Can we create shortcut menus
(Rt Click) in A2007? Can one create a custom Quick Access Toolbar or at least
disable the default toolbar.

Thanks for your help.

> So, lets go:
>
[quoted text clipped - 13 lines]
> so, now we have a general re-usable public function that allows you to build
> custom ribbon buttons that opens a form of your choosing....

Reply to this Message

Albert D. Kallal - 21 May 2007 06:40 GMT

> It appears that the A2003
> Shortcut Menus and Toolbars cannot be created or edited in A2007. I have
> posted a question on this before, but, perhaps because A2007 is till new,
> no
> response.

You can't change them via the ui. I am a big fan of menu bars, but I
*always* used the GUI to build those menus.

A good number of people actually used code to build those menu bars:

I don't think you can "add" new command bars, but you can certainly
manipulate existing ones via code.

The problem is that when you display a "old" menu bar it appears in the
"add-ins" tab.

So, you can for example "display" a particular menu bar (or specify it in
the forms other tab like you always did)

eg:

commandbars("name of menu bar").Visible = true

When you run the above code, the menu bar will appear, but, it appears in
the "add-ins" tab.

So, presumably, you could/would use the add-ins tab, and display your custom
ribbon items on that also (that would be a easy way to hide the rest of the
interface).

And, you can still specify a shortcut menu (right click) for a form. I not
tired adding to existing menu bars via code
but, I have to assume that shortcut menu bars can be added via code.

> Are you able to shed some light on this? i.e. Can we create shortcut menus
> (Rt Click) in A2007?

You should be able to, but you can' use the GUI to do this.

> Can one create a custom Quick Access Toolbar or at least
> disable the default toolbar.

I assume so. I know you can't turn off the office button, but you can
customize it as you please...

I not yet built something that hides the 07 interface, but hope to post a
example soon...

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

Reply to this Message

Tom Ventouris - 21 May 2007 10:04 GMT

Thanks again for your detailed and helpful response.

I have decided that I, and my users, will live without Menu Bars and
Shortcut Menus. The new UI is just too flexible and helpful to stick to old
habits. I have created 2007 and imported all objects without the 2003 Menu
and Shortcut Bars. The Ribbon takes care of everything and all in one place,
as it was designed to do. The new advantage of running code from it provides
all I need for a friendy and intuitive UI.

I will keep an eye on this group for discussion on hiding the Quick Access
Toolbar.
This could create problems for curious users!

> > It appears that the A2003
> > Shortcut Menus and Toolbars cannot be created or edited in A2007. I have
[quoted text clipped - 44 lines]
> I not yet built something that hides the 07 interface, but hope to post a
> example soon...

Reply to this Message