|
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:
|
Lesson |
Description |
Time |
| 00 |
Welcome |
2:06 |
| 01 |
Accounts Receivable,
part 1. Accounts Receivable Query, Aging of Accounts Receivable,
(Showing how many days late) |
16:11 |
| 02 |
Accounts Receivable,
part 2. Accounts Receivable Report |
11:54 |
| 03 |
Percent discounts on
orders, modifying OrderDetailQ |
19:42 |
| 04 |
Msgbox with vbYesNo,
Docmd.OpenQuery, Me.Refresh |
17:20 |
| 05 |
BeforeUpdate, Canceling
update, vbYesNoCancel |
8:25 |
| 07 |
Review |
3:05 |
| |
Total Running Time:
79 minutes |
Click here
for the complete outline
|
