‘Public law has grown to meet the needs of justice on the one hand and of good government on the other by holding public administration to as much of its….
Use the InputBox function to get the department code. Code the application and then test it appropriately.
Open the Morgan Industries Solution (Morgan Industries Solution.sln) file contained in the VB2015\Chap14\Morgan Industries Solution folder. The application is connected to the Employees database, which contains a table named tblEmploy. Each record in the table contains seven fields. The EmpNum field is the primary key. The Status field contains the employment status, which is either the letter F (for full time) or the letter P (for part time). The Code field identifies the employee’s department: 1 for Accounting, 2 for Advertising, 3 for Personnel, and 4 for Inventory. The records should appear in order by the employee number when the application is started. The application should allow the user to display all of the records, only the part-time records, only the full-time records, and only the records for a specific department. Use the InputBox function to get the department code. Code the application and then test it appropriately.