Modifying the Journal Entry Form

In the previous posting, you have known already, how to create journal entry form using Form Wizard. But the result is a rough form of Journal Entry. We should reformat and add additional function in it. Now open form frmOpenTransactionJournalParent in design view, as depicted below:

Why We Should Use Parent and Child Table to Make a Journal Entry Form

There are several ways to create a table for recording transaction journal. Several software developers like to make a table that contains all the required fields in a single table of the journal, some other divide the table in 2 parts: the parent table and the child table. In essence, these two types of tables will give the same results. But in the process they are different.

Modify the Report Based on Control Setting

In previous posts, you already know how to create simple reports using the Report Button provided in the Reports Group. This posting will modify the report that was created to be displayed according to our settings like in the picture below.

Create a Report Using Report Button

Report button in Create tab - Report groups can be used to create a basic report on the data in the current table or query, to which you can add features such as groups or totals. It is very easy to apply. Point your mouse to the table the report you want to create, and click Report button. Finish.

Enter Record In the Tables Using Form

After knowing how to create table and form in MS Access, the next step is create query and report. Before doing that, you have to enter record in each table, especially master tables in the form we have created. To enter such records, make sure that you have add additional control, depicted below, on each form (put the on Form Header). If not yet, please read Control the Form Using Module and follow the steps provided there.

Control the Form Using Module

We have created a form with a simple way in which the form has not been added or installed any feature that will help us work quickly - such as print or view current form. On the other hand, we have created a module contains functions that at any time we can call in such an easy way in the objects we have created. Basically, MS Access has feature to run the function in the module we have created but unfortunately, that function can only be applied in a predetermined form, namely through the class module. In contrast with the standard module, which is created as a separate object in the Access Navigation Pane.

Create Functions using Module

In MS Access, modules contain declarations, statements, and procedures or functions that are programmed in a structured and systematic manner as a single unified entity. There are two types of MS Access module, class module and standard module. Class module is on a form or report, and usually contains a specially programmed procedures for its form or report. Standard module contains general procedures that are not associated with or can be used on other objects - such as query, form, and report. Standard modules are listed under Modules in the Navigation Pane, while a class module not.