|
||||||||||||||||||||||
Access 305 continues our advanced Access database development with VBA programming. We continue work on our sales and order-entry system. This lesson focuses on building an Aged Accounts Receivable. You will learn a lot of new tricks including using a MsgBox to ask questions, the vbYesNoCancel option, the BeforeUpdate event, and much more. We will begin by creating a query to hold our Accounts Receivable data.
You will learn how to determine how old certain invoices are - which are current, which are 30-days late, 60-days, etc.
This is the basis for an AGED Accounts Receivable:
Then we'll create a Report to display our AR information. We'll create form headers and footers to sum up the data.
Next we'll learn how to give each order a Percent Discount.
We'll give each item on the invoice a possible discount as well (in case certain items are, for example, 50% off).
We'll learn how to get information back from the user by asking questions with the MsgBox command:
We'll learn about the BeforeUpdate event which allows us to cancel an event in progress:
|
||||||||||||||||||||||
| Access 305 Outline |
||||||||||||||||||||||
| 1. Accounts Receivable
Query |
||||||||||||||||||||||
|
|
||||||||||||||||||||||
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
|
||||||||||||||||||||||
