Click colour icon to select Red colour in condition- . Click OK to close the conditional formatting dialog. (v) Text control for entering Code in SubForm can be morphed to List control in the same manner as already explained for Debit/Credit Account in simple Transaction Voucher except that the Control source property is assigned the Field name Code of VouchersDetail Table. (vi) Control morphing from Text box to List box is also to be applied on text controls meant to store the data values for AuthBy and PrepBy respectively.
This can be achieved in the manner as already described in the context of designing a simple Transaction Voucher. (vii) Paste a label control to the top right of SubForm for displaying the instruction “Press F9 to Refresh Display”. (viii) Command button at the bottom of Debit/Credit Voucher Form can be added in the same manner as described above in the context of Simple Transaction Form. An additional Command button with Caption Close Form can be added by choosing Form Operation as category with Close Form as the action.
While operating on the above form in run mode, it must be ensured by the user that the entries in the grid are made only after saving the data contents of voucher outside the grid. This is because a data record for contents outside the grid belongs to VouchersMain table. Such record in primary table must exist before any data record is entered in grid to be finally stored in VouchersDetail table. .
Information Using Queries Accounting information that is presented in an accounting report is generated by creating and executing various queries using DBMS. The basics of creating such queries in MS Access have been described below along with their usage in the context of Model- . . .
Basics of Creating Queries in Access Recall that one of the great advantages of relational databases is that the fragmented data is stored in different data tables so that there is no or minimum redundancy. But a complete view of data stored across various tables is achieved only by executing queries based on SQL.