Access Developer 6
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
|