Question: Develop a Database, with VBA, of a company that can add new employees or search for current ones. Your database should accomplish the next requirements:

Develop a Database, with VBA, of a company that can add new employees or search for current ones. Your database should accomplish the next requirements:

1. Data Base should have 4 command buttons: Save New User, Reset Form, Close From, Search.

2. New users will be asked to provide personal information. It includes: Last Name, Middle Initial, First Name, Gender, Address, SSN, State, Picture (use browser to upload it), Employee Number.

3. Reset Form will clean the from partially filled.

4. Close Form will close the Form even if it is partially filled.

5. Search button will ask for Employee Number and it will display Employees information and picture after finding him(her).

Previous description is the minimum content that your project should have. Consider also:

1. The first Worksheet for the UserForm,

2. The second Worksheet to storage the data, and

3. The third Worksheet to display information from the search button. Once a search is done, include also a reset search button to clear contents. You can decide if this search is printed out on Worksheet 3 or on Worksheet 1.

4. Protect your UserForm, use password 12345.

5. Your project MUST use at least Labels, textboxes, Combo boxes, listboxes, checkboxes, option buttons, command buttons, and images.

If possible to get the xls file please submit it, if not just screen shot the code in excel please.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!