|
This class continues our exploration of Macros and
Event Handling. We will begin by creating Search Field
Boxes for our customer list form. This will allow us to type in
a few characters and have the list filtered to show just those customers
match our criteria. We will learn how to build dynamic SQL
statements with multiple WHERE clauses to
accomplish this task.
Next we will learn about Data
Macros. These are macros that are tied to events at the
TABLE level. This way whenever you make changes to the data in
fields in your table, you can cause specific things to happen.
This is the 6th class in the Access Advanced series. If you're
serious about building quality databases with Access, and you want to
learn how to automate your database with Macros
and Events, which is a good pre-cursor to 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
Advanced Level
6
00. Intro (4:38)
01. SQL Search
Boxes (35:50)
Create
Unbound Search Text Boxes
SQL Statement to Replace
RecordSource
Build SQL Statement in a Text Box
Separate
WHERE Clause Box
Multiple Conditions |
02. Data Macros (17:40)
BeforeChange
If NumEmployees < 0
SetField
RaiseError
ProductT Add UnitCost, Markup
Auto Calculate UnitPrice
If
[IsInsert] For Adding Records
After Update
Create a Log
Table
="Updated " & [CustomerT].[CustomerID]
Macro
Shortcut on Desktop
03. Review (7:42) |
|
