Access Database Project #2

The client had an access table with data. He required an Access userform that would provide different methods for modifying and inserting new data.
1


Adding New Records:

The userform provides the user with the ability to add new records to the database:
2
The following fields can only accept values from a list of predefined values:

  • Title
  • Loc Desc
  • Work State
  • Supv Name

Therefore drop down lists have been provided for the user to select values from. The values of the drop down lists are populated from separate access tables.
3


Modifying Existing Records:

The user can also modify existing records. in order to populate the userform the user must select a record. The user can select an existing record by either one of the methods below:

  • Selecting a CRIS number
  • Selecting a name

4
Once a value has been selected the user form will be populated with the data associated with that record:
5


Group Edit:

The client also wanted the ability to be able to modify certain fields in batches.

Example 1: Change the Loc Desc of all fields that have a their Loc Desc set to “BECKLEY, WV – 200 WOODLAWN AVE” to “DELAND, FL – 1398 S. WOODLAND BLVD”.

Example 2: Change the Supervisor of all fields that have a their Supervisor set to “HUDSON,ROBERT H” to “KORTZ,AMBER”.

This can be achieved through the group edit tab:
6


Upload Data in Batches:

The client also wanted the ability to upload data in batches from an excel workbook:
8
Again this is achievable through the “Group” tab. By pressing the “Path” button a select file dialog will open from which the user can locate the workbook with. Upon import the user can select a “Loc Desc” and “Supervisor” to apply to all the records:
9

If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Also please visit my home page  www.software-solutions-online.com

Live Chat

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s