Dean
dnod at aol.com
Tue Aug 30 08:07:05 CDT 2011
I have been doing the same Robert, using treeview or an activeX sidebar control. I stick to single subform interface and popups, dialogs. I would never allow a user access to any of the standard controls or, gasp, direct edit of a record in a table. If they did require a table or if that was the best use, I would still present them with a form that I could control all aspects of the operation within. Most users are not, in my opinion, benefitting from more options so much as from a focused efficient, error-free, workflow and that is what I strive to provide. They don't seem to miss what they never see. Regards, Dean On Aug 30, 2011, at 8:20 AM, Robert Stewart wrote: > I have went to using a treeview control on the left side of the screen for a "menu" > The treeview is loaded from a table that can be maintained by the administrator > of the program. They can add reports, etc later if they want to. Double clicking > on a control on the main interface form, reloads the treeview. > > I also have security at the treeview item level that is based on the Windows login. > This will set the form for read only, etc, or not even show it. > > Almost all forms are loaded as a subform to the right of the treeview. I have found > that it give the applications a polished look and a very non-Access look. That is > important for those people that do not like the idea of using Access. > > At 07:26 PM 8/29/2011, you wrote: >> Date: Mon, 29 Aug 2011 09:18:16 -0400 >> From: "William Benson \(VBACreations.Com\)" <vbacreations at gmail.com> >> To: "'Access Developers discussion and problem solving'" >> <accessd at databaseadvisors.com> >> Subject: Re: [AccessD] User Interface >> Message-ID: <001701cc664e$2381e7a0$6a85b6e0$@gmail.com> >> Content-Type: text/plain; charset="US-ASCII" >> >> I think you all write applications for many more users than I do. I have not >> written anything for more than about 3 users at a time and basically they >> are easily trained. The most important things have been to get work done in >> the fewest number of steps. And no "false moves". On one app I built lately >> there are several buttons down the right hand side of each of the main >> forms. I can put anything I want in their captions then handle all button >> clicks through a test of screen.activeform.name, >> screen.activeform.ActiveControl.Name. I ALWAYS use captions, never images, >> for just that reason. > > Robert L. Stewart > www.WeBeDb.com > www.DBGUIDesign.com > www.RLStewartPhotography.com -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com