PDA

View Full Version : I can't Understand the Meaning. Kindly Help.



prabhafriend
06-25-2010, 08:26 AM
http://i.msdn.microsoft.com/dynimg/IC174466.gifWarning: You must save the document in macro-enabled format if you want to add code that reacts when the user interacts with the Ribbon customization. Documents with this functionality include the .docm, .xlsm, and .pptm formats. For all the examples in this article that include Microsoft Visual Basic for Applications (VBA) code, you must save the host document as one of these formats. What the bold Sentence means in the following link?
http://msdn.microsoft.com/en-us/library/aa338202(v=office.12).aspx
Means If we want the buttons in the ribbon to execute some macro, we have to save those files in the prescribed format or it means if we want to customize the ribbon at run time we have to save in those formats. Does Executing a Macro from a Button in a Ribbon needs this much change(fileformat)?

HiTechCoach
07-12-2010, 09:09 PM
That is referring to non-Access applications.

There is not a special format/file extension for Access. Just an .accdb

It does help to make sure that the database is in a trusted location.

HiTechCoach
07-12-2010, 09:42 PM
For working with the Ribbon in Access 2007 and 2010 here are three new FREE switchboard/ribbon tools for Access 2007 and Access 2010 available for download:

1. Access2007 Ribbon Builder and Editor for Microsoftİ Access 2007 BETA builds and maintains Access 2007 and Access 2010 Custom Ribbons. It is a simple yet sophisticated tool for building custom ribbonbars using XML files. The ribbon being built is displayed as the active RibbonBar. You use the treeview representation of the ribbon to navigate and build the ribbon by adding, editing, copying, pasting, and deleting controls. http://accessextra.blogspot.com/2010/03/ne...der-editor.html (http://accessextra.blogspot.com/2010/03/new-ezy-access-ribbonx-builder-editor.html)

2. Easily Migrate Legacy Access Switchboards to the Access 2010 Navigation Form In Access 2010 the venerable Native Switchboard Manager has been retired. The old Switchboard form has been replaced by a cool web 2.0 style Navigation Form using a tabs paradigm of up to two levels. The Navigation Form Control and Button controls cannot be created in code, so there is a degree of hard-coding involved. I saw the opportunity to ease the design process by adapting the legacy Switchboard Items table and porting it to the new Navigation Form. I have created a demonstration Access 2010, which can be downloaded from the url below. The code can be used freely in your applications 'as is'. All the required code is behind the custom Navigation Form, which is pre-built with a generic two-level tabs control: 8 level one options and each option having 8 buttons, which are populated at run-time from the Switchboard Items table, using custom code adapted from the Access 2003 vba module behind the native Switchboard form. http://accessextra.blogspot.com/2010/04/in...ble-native.html (http://accessextra.blogspot.com/2010/04/in-access-2010-venerable-native.html)

3. The Access Switchboard to Ribbon Converter Wizard in just two mouse-clicks turns your legacy Access Switchboard (as built by the native Access Switchboard Manager) into a fully functional Ribbon Switchboard. http://accessextra.blogspot.com/2010/05/ac...-converter.html (http://accessextra.blogspot.com/2010/05/access-switchboard-to-ribbon-converter.html)