Microsoft Access Programmer Albany, New York

The Microsoft Access Project Form For Programmers

Call MS Access Solutions at (323) 285-0939 for your FREE consultation.

The material below originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development and is reprinted here with the author's permission. There may be references to "Figures" or "Chapters" that are not reprintable and are not used on this page.

Designing The Projects Form

The next step is to design the Projects form, which is pictured in Figure 5.75. The form is easily created with the Form Wizard and then customized. Here are the steps involved in designing the Projects form:

1. Select the Create tab.
2. Select Form Wizard from the More Forms drop-down.
3. Select tblProjects from the Tables/Queries drop-down. This record source is modified in Chapter 10.
4. Click to select all fields and click Next.
5. Select Columnar from the list of layouts and click Next.
6. Select a style of your choice and click Next.
7. Title the form frmProjects and click Finish.
8. Switch to the Form Design view. Delete the ProjectID and EmployeeID text boxes and the ClientID combo box. Move and size the form objects

A Combo Box Must Be Added For The EmployeeID:

1. Make sure that the Control Wizards tool is selected.
2. Click to select a combo box from the Controls tab of the Design tab on the ribbon; then click and drag to add it to the appropriate location in the detail section of the form. The Combo Box Wizard launches.
3. Select I Want the Combo Box to Look Up the Values in a Table or Query. Click Next.
4. Select the tblEmployees table from the list of available tables and click Next.
5. Select the EmployeeID, LastName, and FirstName fields and click Next.
6. Indicate that you want the data sorted by Last Name and then First Name and click Next.
7. Leave the Key column hidden, and size the LastName and FirstName columns, if desired. Click Next.
8. Select Store That Value in This Field. Select EmployeeID from the combo box and click Next.
9. Enter Employee as the text to appear within the label and click Finish.

Refine The Form

1. Rename the objects per the naming conventions found in Appendix A (txt for text boxes, cbo for combo boxes, and so on).
2. Set the Dividing Line and Record Selector properties of the form to No.
3. Select Tab Order from the Controls Layout group on the Arrange tab of the ribbon and set the tab order of the controls as appropriate.
4. Set the Caption property of the form to Project Information.

Adding a Command Button That Links The Clients And Projects Forms

The final step is to tie the Clients form to the Projects form. The Command Wizard will help to accomplish the task:

1. Return to the frmClients form in Design view.
2. Make sure the Control Wizards toolbar button is active.
3. Click to select a command button and then click and drag to place it within the Header section of the frmClients form. The Command Button Wizard launches.
4. Click Form Operations within the list of categories.
5. Click Open Form within the list of Actions and click Next.
6. Select frmProjects as the name of the form you would like the command button to open. Click Next.
7. Click Open Form and Find Specific Data to Display. Click Next.
8. Click to select the ClientID field from the frmClients form and the ClientID field from the frmProjects form. Click the <-> button to designate that the fields are joined. Click Next to continue.
9. Select a picture or enter text for the caption of the command button.
10. Enter the name for the command button. Don't forget to use proper naming conventions (for example, cmdShowProjects). Click Finish.
11. Switch from Design view to Form view and test the command button. The frmProjects form should load, displaying projects for the currently selected client.

---

Author Attribution

The preceding information originally appeared in Alison Balter's book Mastering Microsoft Office Access 2007 Development and is reprinted here with the author's permission.

---

Expert Microsoft Access Programmer In Albany, NY

When you need a Microsoft Access programmer for your Albany, New York business, call MS Access Solutions at (323) 285-0939. We have over 25 years experience in Microsoft Access programmer solutions. We create Access database applications for all sectors, inlcuding, but not limited to: medical clinics and hospitals, government agencies, the U.S. military, universities, junior colleges and school districts, agriculture, human resources depoartments, employment agencies, and insurance agencies and insurance companies.

More Microsoft Access Projects We Perform For Our Clients

• Database Form Reconstruction: Systematically diagnose and fix damaged Access database interface structures


• Reporting Enhancement: Refine MS Access reporting mechanisms for enhanced data visualization and insights


• Macro Optimization: Streamline Access macros to improve operational efficiency


• VBA Code Refinement: Advanced programming interventions to elevate code quality and performance

---

Find out more about our programmer services on the Microsoft Access Programmer Brooklyn, New York web page.