| |
| |
|
|
|
Access
Developer
Level 8
Developer-Level
Microsoft Access Tutorial - 1 Hour, 20 Minutes |
| |
|
|
| |
Access
Developer 8 continues our focus on learning how to program the
Visual Basic for Applications programming language (VBA) in
Microsoft Access.
Topics include:
 |
-
More Partial Payments on Invoices
- Combo
DropDown Method
-
On Unload Event
- Locking
Invoices if Paid
- Creating a Public
Global Function
- Globally Search VBA Code
- Allow Additions,
Edits, Deletions VBA
- Search As You Type
- On Key Press, On Change Events
-
Lots more |
Order Now |
If you would like a preview of what's covered in this class,
click here to watch the first
and last lessons of
this course (free of charge), or scroll down for more information.
|
|
Access Developer Level
8 |
| Versions: |
This class was recorded with Microsoft
Access 2016. The material is valid for Access 2007 up to 2021. Access has not changed that much over the years. |
| Pre-Requisites: |
Access
Developer Level 7 strongly recommended, as you should watch all of my
classes in order. However, if you're skipping around, you should
have at least completed the Beginner series and the first 3 or 4
levels of the Expert series where I start to cover functions. |
| Running Time: |
1
Hour, 20 Minutes |
|
Cost: |
$41.99 |
|
|
|
This class continues our look at programming in Visual Basic for
Applications in Microsoft Access (VBA, or Access VB). We will
continue working with adding partial payments to invoices that we
started on in Developer 7. We will begin by defaulting the amount of the
next payment to the current amount due on the invoice.
We'll see how to use the combo box DropDown method to
automatically open the payment type combo box. We will refresh the total
payments and amount due shown on the payments form and the order form
after a payment is entered to avoid confusion. We'll learn about the
On Unload event. We will check for overpayments
and decide what to do in that case.
Next we will check to see
if an invoice is PAID. If so, we will not allow
additions, deletions, or edits unless a manager password is entered. We
will learn how to create Public Global Functions so
that we can use our IsManager function from anywhere in
the database. We will see how to return a value from a function, and how
to globally search and replace in our VBA code throughout the entire
database project.
In the last lesson, we will take a break from
the payments system and design something that I get lots of emails
asking for: a Search As You Type feature. We will make
a list box with all of our customers in it, and a text box that we can
type a search criteria in. As we type each letter into the text box, the
list of customers will automatically filter with each keystroke.
In addition, we can search based on first name, last name, or company
name. I cover this feature in more depth in my
Search
Seminar, but this is a simplified version that shows the
basics of how to build something like this.
This is the 8th class in the Access Developer series. If you're
serious about building quality databases with Access, and you want to
learn how to automate your database with VBA Programming then don't miss out on
this course. Of
course, if you have any questions about whether or not this class is
for you, please contact me.
Complete Outline - Access
Developer Level
8
00. Intro (3:30)
01.
Payment Mods 1 (23:48)
Default to Amount Due
Combo DropDown Method
Add Amount Due
to PaymentF
Refresh Amount Due
Refresh Total Payments
On Unload Event
Mark Order Paid
Check for Overpayments
02. Payment Mods 2 (27:25)
Don't Allow Edits if Paid
Me.AllowAdditions
Me.AllowEdits
Me.AllowDeletions
Manager Override Password to Edit
Create a Public Global
Function
IsManager Function
Returning a Value from a
Function
Replace Password Elsewhere
Globally Search All
Code
Search Code Entire Project |
03. Search As You Type (23:11)
Create Search Query
On Key Press Event
KeyPress
KeyAscii
What is ASCII?
CHR Function
OnChange Event
SelStart
Len, Nz
04.
Review (2:32)
|
|
| |
| Keywords:
Access VBA, Visual Basic for Applications, microsoft access tutorial, microsoft access tutorial, microsoft access training, public global functions, partial payments on invoices, search as you type, dropdown, on unload, allowadditions, allowedits, allowdeletions, return value from function, on key press, keypress, keyascii, chr function, onchange event, selstart, len, nz |
| |
|
|
