|
Access 307 continues our advanced Access
database development with VBA programming.
This class focuses on creating a custom search
button for your forms - where you can place a command button next to
a commonly-searched field (say, LastName) then click on it, type in part
of the last name, and Access will search for it. We'll learn all of the
VB code behind such a feat.
We'll also look at dynamic combo boxes -
where the values in the combo box can change or be changed by other
fields. I'll show you an example where one combo box can be used to
change the values in another (pick a state in one box and it shows you
only cities from that state to pick from in the next one, for example).
We'll learn some simple database security -
I'll show you how to set up a database password. We'll see how to
convert between different Access versions, and how to create a secure
MDE file. I'll also show you the database splitter wizard.
ACCESS 307
Lesson 1. Custom Search Button
Docmd.FindRecord
Docmd.GoToControl
InputBox
Custom Sub with Parameter
Lesson 2. Dynamic Combo Boxes Part 1
Combo boxes that control (filter) other combo boxes
Form_BeforeUpdate
Cancelling BeforeUpdate
Verifying user data before allowing them to leave a record
Lesson 3. Dynamic Combo Boxes Part 2
ComboBox.Requery
Subform Link Master ID
Lesson 4. Simple Database Security
Set Database password
Open Database Exclusive Access
Unset password
Converting a database between versions
Creating an MDE file
Lesson 5. Splitting a Database
Database Splitter Wizard
Linking Tables
Linked Table Manager
|
