Ribbon on form (1 Viewer)

[pjs]

Set-up as follows:
USysRibbon table with 2 custom ribbons
Autoexec macro runs LoadRibbons() (LoadCustomUI)
All ribbons listed in form properties
Button on form opens blank query for user reports. Want to attach a custom ribbon to the button.
Docmd.ShowToolbar "qryRibbon", acToolbarYes gives the error "Toolbar not found"
How do I get VB to see the ribbon and open it on the button click event?
Thanks in advance.
pjs

 

[CEH]

Take a look at this.... Sounds like what you want.
http://msdn.microsoft.com/en-us/library/aa434076.aspx

 

[vbaInet]

Form's have a Ribbon property, so you do:

NameOfMyForm.RibbonName = "nameOfCustomRibbon"

You won't be able to set a ribbon for a query so you would have to use a form based on your query.

 

[pjs]

Take a look at this.... Sounds like what you want.
http://msdn.microsoft.com/en-us/library/aa434076.aspx

thanks, pretty much covered this article without luck.

 

[pjs]

Form's have a Ribbon property, so you do:

NameOfMyForm.RibbonName = "nameOfCustomRibbon"

You won't be able to set a ribbon for a query so you would have to use a form based on your query.

Your idea looked like a nice easy solution. I'd hoped that in opening a custom ribbon on a form to locate a query, the query design view could 'inherit' the ribbon from the form. no such luck.
I will now use the 2003 custom menu instead, seems the only choice.
Thanks
pjs

 

[vbaInet]

As a workaround, use a form that is based on your query and set the form's Default View property to Datasheet View. It would look like a query and you will have the custom ribbon.

 

[CEH]

This site seems to have the most on using the ribbon......

http://www.accessribbon.de/en/index.php?Access_-_Ribbons

 

[vbaInet]

This site seems to have the most on using the ribbon......

http://www.accessribbon.de/en/index.php?Access_-_Ribbons

That's a good site. I used it when I initially started building ribbons. Still use it actually

But I think the OP has already created his/her xml schemas for the ribbon. All the OP wants to do is attach it.