I am a firm believer that a picture can convey much more information than
can my keyboard, so I encourage you to visit the AccessUI web site to see a more detailed
explanation of what this user interface can do for you.The site
also provides a working demo based on the Northwind database that is free to
download and explore. That having been said, I want to describe a couple
of the most important, and interesting, features.
Command Bar Top Menu
Across the top of the application stretches the main command bar menu.
Items are added to this menu through the Admin tool and users may create
cascading menus with up to 4 levels. The command bar also supports
buttons for launching forms, reports, etc.
Outlook Style Vertical Left Menu Bar
Of all the non-native-to-Access features requested by my clients, the Outlook
style menu is the most desired. I know there are controls out there I
could purchase and it probably would not be beyond me to figure out how to
implement it, but it sure was nice to just plug-and-play this impressive
However, it is more than just an Outlook style menu. It allows users to
add items to their own favorites tab and it is integrated into a larger control
that gives users four different ways to view the component windows,
showingvarious combinations of the menu, the treeview and output screens.
Through the admin tool, you can add items to any of the Outlook bar tabs and
control their behavior and appearance. In addition to the 50 icons included
with the tool, users can supply up to 50 of their own icons to assign to menu
items. Forms can be loaded into the AccessUI client area (as a subform)
or be opened in popup mode. Reports can be opened in preview mode, or
sent directly to the printer. All of this is handled through the add-in
and once you get comfortable with the process, you will be amazed with how fast
you can implement new application features for your users.
The treeview is the Piece de Resistance of the entire tool.
As shown in the screen shot above, my application allows users to navigate
through their CRM opportunities by sales rep in one treeview and by
manufacturer in another. As the user drills down in my application, they
see the list of customers and may expand that customer's programs and
products. With AccessUI, I can create as many treeviews as I need and
even control which users have access to which menu items.
It should be noted that these controls load very quickly and the tool even
reports (in the status bar) the time required to load the client form, along
with the total number of records affected.
A Boon to Developers
It should be obvious that I
really love this product. In fact, I have decided to begin using it as my
standard interface for all new clients and projects. A single developer
license entitles me to create as many applications as I want and to distribute
the client to as many users as need be, royalty free! The developers of
this fantastic tool proudly and accurately boast:
The AccessUI tool provides Microsoft Access users and developers
the ability to create professional, highly customizable user interfaces without
writing any code. AccessUI's interface is completely customizable via the
easy to use administration tool. With the AccessUI tool you can quickly
add a professional interface to your new or existing Access applications and
distribute them royalty-free.
I'm sold, and you will be too when you see the pizzazz it
will add to your applications. As mentioned at the outset, this UI
secured one contract for me and I have no doubt it will pay for itself many
times over as I continue to dazzle my customers with professional, customizable
applications that expose all the power and simplicity of Microsoft Access, but
with a fresh new look.
See All Articles by Columnist Danny J. Lesandrini