Looking For Something Besides Switchboard Or Navigation Form
May 28 2012, 09:47 AM
Joined: 27-May 12
I am used to using buttons or the switchboard for access operations which seemed clunky. Now they have a navigation form for reports. I am looking for something different that controls everything. I have seen an example for one at TheUAIC.com that seems fairly simple and has some nice features I like:
It has everything for navigation controlled by one form.
It can be used to open/execute everything like – Reports, Forms, Queries, Macros, Code etc.
Once a selection has been made it has an area that explains in greater detail of what the Report, Form, Query, Macro, Code etc. is about.
Documentation can be easily accessed for the selection.
Due dates can be also viewed and edited quickly for the selection.
My question is has anybody used this before or know or other navigation systems for Access that may similar or better?
Thanks for any assistance.
May 28 2012, 10:02 AM
UtterAccess VIP / UA Clown
Joined: 21-January 04
From: LI, NY
Using a combobox for program control is not uncommon and easy to do. There are many ways to do it. One can use the MSysObjects system table to display objects and then execute code based on the type of object selected.
But to be really easy for the user, It would be better to create your own table of Objects. This way you better control categories, listed objects and the actions to take. For example. you could have a category like Enter New Data, Edit Existing Data, Print Reports, etc. then based on the category a list of tasks is displayed using the technique of cascading combos.
Personally, I don't like this for total control of an application. But I do use the technique at times. Generally I use it for selecting reports, because there are often a long list of reports and they are added frequently.
Jun 16 2012, 06:30 PM
Joined: 27-May 12
Here are my responses from other boards:
url]http://www.access-programmers.co.UK/forums/showthread.php?t=227488[url] - http://www.mrexcel.com/forum/showthread.php?t=248191
[url]http://answers.microsoft.com/en-us/office/forum/office_2010-access/wanting-something-besides-switchboard-or/772d06d2-a37c-4b8c-a7ff-669643c4a219[url] - you can find a multitude of free examples onlin
[url]http://www.msfn.org/board/topic/157003-wanting-something-besides-switchboard-or-navigation-form/[url] - Can you provide a link so that we can see what you're talking about?
Only one possible option listed above that requires me programming.
|Search Top Lo-Fi||2nd March 2015 - 10:07 PM|