Adding a Subform to an Existing Form Many of you are having issues with at least one of the subforms. Your database will still work if you don’t have the form as the missing subform comes from other...

1 answer below »

Accounting information system Access

Adding a Subform to an Existing Form Many of you are having issues with at least one of the subforms. Your database will still work if you don’t have the form as the missing subform comes from other tables where you have input data. Your queries will provide the information needed to complet the invoices and cash receipts. However, as I discovered yesterday, some of you want the subform. If you want the missing subform to show on the main form, it is easy to add the subform. The first step is to make room for your subform in the existing form. Open your existing form in Design View. Click on the Form Footer and hover over the top edge until you get the . Click, hold the left mouse button down and drag down to enlarge the Detail section of your form as shown below. Next, from the Controls section of the Design ribbon make sure the Use Control Wizards is selected and then select the Subform/SubReport tool as shown on the next page. Click on where you want your subform to go and the control wizard will open as shown below. Accept the default option and click Next. In the next window, Select the Engagement-Employee table from the drop-down list. Move EmployeeID and BillableHours from the Available Fields to Selected Fields. Click Next to continue. As shown on the next page, make sure the Choose from a list option is selected and then select Show Engagement-Employee for each record in Engagement using EngagementNumber. Remember your table and field names may be a little different from mine. Click Next to continue. You can accept the default subform name and click Finish. Now you should see your subform as shown in the next screenshot. Size the form as appropriate and delete the Label for the subform by clicking on it and pressing delete. At this point, you may also want to adjust the size of the Detail section of your form. Go to the Form View to see your results. If you already have data entered, you can scroll through the records and see the subform change with the Engagement.

database-project-spring-2020-2-xkckdsj0.docx

Answered Same DayMay 04, 2021

Answer To: Adding a Subform to an Existing Form Many of you are having issues with at least one of the...

Neha answered on May 08 2021

146 Votes

Database5
    TransNo    BillingDate    ClientId    ServId    HoursBilled
    1    4/30/20    10000    ASW    12.0
    2    4/29/20    10001    TSW    10.0
    3    4/30/20    10002    TSW    10.0
    4    4/30/20    10003    ASW    10.0
    5    4/30/20    10004    TSW    20.0
    6    4/30/20    10005    ASW    20.0
    7    4/29/20    10006    ASW    20.0
    8    4/29/20    10007    ASW    20.0
    9    4/29/20    10008    ASW    44.0
    10    4/29/20    10009    CSW    44.0
    11    4/29/20    10010    CSW    44.0
    12    4/29/20    10011    TSW    66.0
    13    4/29/20    10012    ASW    66.0
    14    4/29/20    10013    TSW    66.0
    15    5/2/20    10014    CSW    88.0
    16    5/2/20    10015    CSW    88.0
    17    5/2/20    10016    ASW    88.0
    18    5/2/20    10017    ASW    18.0
    19    5/2/20    10018    ASW    12.0
    20    5/2/20    10019    ASW    13.0
    21    5/2/20    10020    ASW    14.0
    22    5/4/20    10021    CSW    15.0
    23    5/4/20    10022    CSW    12.0
    24    5/4/20    10023    TSW    12.0
    25    5/4/20    10024    TSW    12.0
    26    5/4/20    10025    CSW    20.0
    27    5/4/20    10026    CSW    20.0
    28    5/7/20    10027    ASW    30.0
    29    5/7/20    10028    ASW    54.0
    30    5/7/20    10029    ASW    55.0
    31    5/7/20    10030    TSW    55.0
    ClientId    ClientTypeId    ClientName    Address    City    State    Zip    Phone
    10000    CO    John     73 Ocean Street    Sydney    Ne    76015056    8175281841
    10001    ET    Smith     19 Geroge Street    Sydney    Ne    76015033    8175289312
    10002    ID    Johnson    07 Gleble Point Road    Sydney    Ne    76015081    8175218191
    10003    LLC    Adam    86 Ocean Street    Sydney    Ne    76015058    8175274627
    10004    OT    Sarah    22 Great north Road    Sydney    Ne    76015000    8175228727
    10005    PA    Jonny    77 Geroge Street    Sydney    Ne    76015046    8175273186
    10006    SP    Allen     18 Gleble Point Road    Sydney    Ne    76015026    8175263011
    10007    ET    Jim    22 New South Head Road    Sydney    Ne    76015006    8175254475
    10008    CO    Morries     33 Ocean Street     Sydney    Ne    76015015    8175293542
    10009    LLC    Lewis    88 Geroge Street    Sydney    Ne    76015054    8175213772
    10010    CO    Scott    33 Great North Road    Sydney    Ne    76015056    8175260222
    10011    CO    Elisha    23 King Street    Sydney    Ne    76015044    8175202249
    10012    CO    Emily    56 Ocean...

SOLUTION.PDF

Adding a Subform to an Existing Form Many of you are having issues with at least one of the subforms. Your database will still work if you don’t have the form as the missing subform comes from other...

Answer To: Adding a Subform to an Existing Form Many of you are having issues with at least one of the...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment