Manage Multiple Small Lists

[Mr. B]

Take a look at the attached zip file which contains a demonstration of a method that I use when I have multiple small lists in one database applicaiton that are used to provide selection options for user. These list are things like Prefix, Suffix, Title, etc.

An Access 2002 database file and an 2007 database file, a "How to" PDF document are included in the zip file. I have also created a demo video that will provide an overview to see how I use this method. You can view the video at: http://www.askdoctoraccess.com/managelistsvideo.htm

The short overview of this demo is that this method uses a single table to store the list values for each list type and uses a single form to provide the user interface that allows users to add new values, manage existing values and even to create a user-defined sort order for each list.

I have been using this method for managing these small list for quite some time and thought it might be of interest to others here on the forum.

I welcome comments from one and all.

 

[wiklendt]

you seem to have used a codec that is proprietry (g2m3) for the video. i've tried installing the codec from here, but i cannot get any video feed, only audio...

 

[Mr. B]

There is some blank video at the beginning of the video, only sound. Try to continue to view for a few minutes and see if it will show the actual video.

 

[Mr. B]

Play the video for at least 10 seconds and see if the view of the screen is actully visible.

 

[DCrake]

Although intuative I felt that the how to doc was over long (46 pages). did not read it fully. However there seems to be one thing missing. Adding a list selection type to database. For example lets say I want to add a further selection list, such as Age Groups. How do I do that?

 

[Mr. B]

Although intuative I felt that the how to doc was over long (46 pages). did not read it fully. However there seems to be one thing missing. Adding a list selection type to database. For example lets say I want to add a further selection list, such as Age Groups. How do I do that?

DCrake,

Thanks for your thoughts.

The "How to" document was meant for use by someone who has little or no experience with Access and certainly not for someone with your experience and ability.

I realise that it is lengthy, but I have had beginner Access users that were able to use the "How to" and create their own user interface. I even addressed this in the document, saying that this document was not for seasoned developers.

The use of this type of management method would never require that the end user add an new "List Type" as the developer will have created each of the "List Types" needed during the development of the project, so there is no need for providing a method for creating a new "List Type" when using this user interface.