Question XML Code - open form

[Dairy Farmer]

I am building a custom ribbon and need some XML code help. I need this button to open a form.

<[COLOR="Red"]button idMso="??????" [/COLOR]size="large" label="MyButton"

 

[HiTechCoach]

This site might help:

http://www.accessribbon.de/en/?Welcome

 

[Dairy Farmer]

Thanks got it:

[U]USysRibbon[/U]
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
   <ribbon startFromScratch="true">
       <tabs>
          <tab id="MyTab" label="My Tab">
             <group id="MyGroup" label="My Group">

                <button id="MyButton1" size="large" label="MyButton1"
                  imageMso="AccessListCustom"
                  onAction="MyButton1CallbackOnAction"/>

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

[U]Module[/U]
Sub MyButtonCallback1OnAction(control As IRibbonControl)

DoCmd.OpenForm ("Form1")

End Sub

 

[HiTechCoach]

Glad to hear you got it working.

Thanks for posting your solution.

 

[HiTechCoach]

Just notice the link in your signature:

Access Package and Deploy - Make your db a "Standalone" app


The title of that post is very mislead and I would have to say NOT accurate.

To Make your db a "Standalone" app means that you do NOT need any other software installed, like Access, to use the forms and reports. This is just not possible.

An Access database can not stand alone from the MSAccess.EXE and still be able to use the forms and reports.

To use the form and reports in an Access database (MDB/MDE or ACCDB/ACCDE) you must have a venison of Access installed that is compatible.

You can NOT make an ACCDB/ACCDE stand alone form Access and still you the forms and reports.

What this post is really about is using the Access Runtime. It no way is it ablut making the database standalone.

The title really should be something like:

Package and Deploy - Using your db with the Access Runtime

 

[Dairy Farmer]

Samle DB of using a custom ribbon to open forms.