These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 10, 2012

David Katherman Dynamic Database

This project was originally conceived as a ‘pocket database’ application for a mobile platform, allowing a user to dynamically build, update, and search small databases on the go at worksites or business meetings. The version of the project explained below is a prototype of the pocket database system, built in Microsoft Excel using visual basic for applications and called ‘Dynamic Database’.

The Dynamic Database program allows a user to create a database composed of values held in a specific worksheet in the workbook. The user may specify what fields he wishes the database to take in. Dynamic Database will take the specified information and dynamically create an input form by which the user may quickly add information to the sheet containing the database.

Dynamic Database also allows the user to edit an existing database. The user may select the existing database from a list, and the program dynamically recreates the input form for that database from the saved input form information, kept on a separate sheet and inaccessible to the user. The user may then use the input form to quickly add more data to the database.

While a user could manually create the sheets and column headers and manually search and edit the information contained thereon, Dynamic Database was conceived to help me work through the logic of dynamically creating userforms and form controls from a series of user inputs, and then successfully placing the information entered into those form controls into a file. Documentation and forums suggest it is not possible in vba, where it is discussed at all, but I have found that it is possible, although it is not a small undertaking. Dynamic Database is described in detail below.

No comments:

Post a Comment

Blog Archive