This class continues our look at programming in Visual Basic for
Applications in Microsoft Access (VBA, or Access VB). We will
begin by learning how to convert the macros we built in the Advanced
classes into VBA code. We will learn some additional VBA commands, and
some new programming techniques.

Next we'll build an
Enhanced Timer Form. We briefly learned how to use the
Timer event in the Expert classes to download updated weather
information from a web site. In today's class we'll expand on that Timer
to learn how to create a clock that ticks every second, and launch
events in VBA at specified intervals, such as "run this report every 60
minutes," or "send the sales reps an updated sales report every day."

We covered Cascading Combo Boxes
briefly in some of our free Tips and Tricks lessons and seminars, but we
haven't spent much time with them in an actual class. So in today's
lesson we will see how to use them to pick a Product Category, and then
see a second combo box that shows just the products from that category.
This is handy if you have thousands of products to choose from. You can
also use this technique to pick a state, for example, and see just
cities from that state. The options are endless.

Finally, we will go over a
fan-favorite: how to backup your database. I'm going to
show you two different methods. The first is to backup just specific
objects from your database - your customer and order tables, for
example. The second method will show you how to backup the entire Access
database file from within Access itself.

This is the 6th 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
6
00. Intro (4:36)
01.
Converting Macros to VBA (29:41)
Quotation or Invoice in Report
Examine old Macro from Advanced 2
Label.Caption Property
Detail_Format Section
Report Detail Build Event
TRUE assumed in IF statements
VB Editor Auto Capitalization
vbRed, vbBlue
ForeColor Property
Quote or Invoice Toggle Button
Global Module for IsQuotationCode
Enabled, Locked Properties
IsPaid Password Code to VBA
Convert Macros to VBA
02.
Enhanced Timer Form (16:35)
OnTimer Event
Timer Interval
One Second Ticks
Me.TimerInterval
IsPaused Checkbox
Checkbox to Control Events Firing
Specifying Timer Interval Text Box |
03. Cascading Combo Boxes
(9:47)
Dynamic Combo Boxes
Control Wizard Not Starting
Product Category SQL Rowsource
Select Category, Products Filtered
04.
Automated Backups (34:26)
Trusted Locations
Backing Up Critical Tables
You Should Have Separate Backup
Use This to Backup Critical Data
DoCmd.TransferDatabase
Backup With Timestamp
Current Date Time Field
Last Run Field
Run Every X Minutes or Hours
86400 Seconds
FileCopy Permission Denied
CopyFileA Windows API
Replace Function
05.
Review (3:44) |

|