Showing posts with label access switchboards. Show all posts
Showing posts with label access switchboards. Show all posts

Monday, October 27, 2014

Try the free Access Instant Ribbon Wizard

The Wizard will automatically create an Access 2007/2010/2013 Ribbon Switchboard  based on the native Switchboard Items table in your database built using the native Access Switchboard Manager. Just two clicks and your done.

Free Download

Monday, May 24, 2010

Access Switchboard to Ribbon Converter Wizard

Exclusive to readers of Access Extra!
A new free Wizard for Access 2007 and Access 2010






















This Wizard has been retired and replaced by The Access Instant Ribbon Wizard. The Wizard will automatically create an Access 2007/2010/2013 Ribbon Switchboard based on the native Switchboard Items table in your database built using the native Access Switchboard Manager.

Download


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!

Download now! Only 155kb (v1.0.1 updated 27 May 2010)

Also check-out these free new Access 2007/2010 tools:

Wednesday, April 07, 2010

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 here.  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 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:









The top level option tabs are equivalent to the legacy Go to Switchboard command, and each top level tab has 8 sub-tabs, which equate to the old Switchboard Items.  At run-time the code behind the Navigation Form assigns to each tab button the Item Text to the Caption property, the Command and Argument values to the Tag property of each button control, and an on-click function for macros and code functions to the OnClick Event.  Form and report objects names are assigned to a button’s 'navigate to' property.  Tab buttons are displayed only for actual item entries. Unused tab  buttons are hidden.

I have also built a Manage Switchboard Items Form to manage the Switchboard Items table and automate the process of upgrading legacy Switchboard Item tables from previous versions of Access. Updated 28 May 2010 so that after an item is deleted all items are automatically renumbered sequentially




Tuesday, November 24, 2009

New Free Access 2007 Menu Switchboard





















The latest free download from aadconsulitng.com. The Menu Switchboard for Access 2007 replaces the native Access Switchboard with this free superior menu switchboard, which uses the Switchboard Items table created by the native MS Access Switchboard Manager and only native Access controls. This navigation paradigm also enforces a strict SDI modal interface, hides the Access application window, and optionally hides the Access RibbonBar. The download includes a sample database.

How it works:
  1. Import your all your databases objects into the Access2007 Menubar Switchboard ACCDB template  file and rename it to match the old database name.
  2. Place the separate library database (ACCDE) file that ships with the template file in the same folder as the renamed ACCDB.This ACCDE must be deployed with your ACCDB file
  3. Use the native Access Switchboard Manager to build/manage your Menu Switchboard.
  4. Set the Modal property for all forms and reports in your ACCDB to True, and decide which forms will have the Popup property set to True.  
  5. Set the form, frmMenu, as your StartUp form.
  6. Place your custom splash image to replace the Access splash screen and your custom application icon in the same folder as your ACCDB.

Sunday, July 26, 2009

NEW Free Kiosk Dashboard Sample Access Database



My latest free mouse-driven full-screen modal kiosk dashboard for Access 2000 and later is available here.

Thursday, July 23, 2009



NEW Super Dashboard Switchboard and Builder
for Microsoft© 2002/2003/2007

Easily build complex dashboard of multiple switchboards of different types:
classic list or nested treeview

The latest Access switchboard product from aadconsulting.com is the exciting Super Dashboard Switchboard and Builder.

Replace the native Access Switchboards with this superior dashboard of up to 8 switchboards, which uses native Access controls for the SideBar and the MSCOMCTL.OCX TreeView and ImageList controls for the treeview switchboard. Each switchboard can be either a classic items switchboard or a fully nested treeview switchboard. A treeview can contain up to 1,000 nodes, and a classic items list can contain up to 16 items.

Included is the advanced Dashboard Builder MDE which fully automates the creation and maintenance of the Dashboard and each switchboard.

Try it now


Thursday, July 09, 2009


New Web 2.0 Switchboard for MS Access

I have just relased a great new Web 2.0 Switchboard for MS Access offering all the rich functionality of a Web 2.0 gui without OCXs or DLLs - using only native Access controls:

Check out the full demos here.

Tuesday, July 22, 2008

Coming soon... Ezy Dashboard Builder
from aadconsulting.com

I will soon be launching a cool new add-in for Access, that will in a few minutes transform your Access application switchboard from this:



to this:



using an easy to use 1, 2, 3 wizard:







A free BETA will be available shortly. Watch this space