FrmInspection is an unbound form with two subforms one to, display properties due for inspection and one to display properties. With inspection reports to complete. The subforms are tabular and have as their source queries that use data, from tblPropertyForRent. TblInspection tblLeaseAgreement and, tblStaff. Properties due for inspection are defined as those whose most recent inspection. Was over three months ago or which, have never been inspected. Properties that have inspection reports to complete are defined. As those whose inspection record does not have an entry for 'comments'.The 'Arrange Inspection' command button runs a macro to open frmInspectionArrange at a new record. The property number. Of the, property selected and the staff member who manages the property are input, into the inspection record automatically. (further details of frmInspectionArrange are given later in this section). If the Arrange Inspection button is clicked when. There are no inspections due a message, is displayed.The 'Complete Inspection Report' command button runs a macro to open frmInspectionComplete at the inspection record, selected. Further details of frmInspectionComplete are given later in this section. Again if there, are no inspection reports to complete. When the button is clicked a message, is displayed.The Close command button closes the form.
การแปล กรุณารอสักครู่..