Microsoft Most Valued Professional MVP - Access Expert

mvp.png

  Boyd Trimmell, aka HiTech Coach
  Microsoft MVP - Access Expert


What is a Microsoft  Most Valuable Professional (MVP)?
Microsoft  awards the Most Valuable Professional (MVP) in recognition of significant contributions made to technical communities by sharing high quality, real world expertise. Microsoft Most Valuable Professionals (MVPs) are a worldwide network of exceptional technical community leaders.

"If technology doesn't work for people, then it doesn't work."
- Kim Vicente

FREE ribbon tools for Access 2007 and 2010

For those who are interested in 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

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

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

Display form at start up

There are two commonly used options:

1)There is an option to select the desired start up form:

Access 2000/2002/2003 -On the Menu -  Tools Startup... > Display Form/Page

Access 2007 - Office Button (upper left corner) > Access options (lower right) >
                         Current database >  Display Form
Access 2010 - File > Options > > Current database >  Display Form

2) use a macro named AutoExec

Action - OpenForm