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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started