field data types, 50–51
fields
specifying for sorting, 157
viewing for a table, 134
file attachments, 456.
See also attachments
File Attachments tab, 339
File Open button, 339
file-level security, 327
FileName parameter
for the TransferSpreadsheet method, 205
for the TransferText method, 206
Filter property, 158–159
FinalizeOrder procedure, 35, 36
Find method, 157–158
firing events. See raising events
fixed-size array, 52
FixNull function, 489
For Each...Next loops, 61
For Each loops, 99–100
For...Next loops, 61–62
For...Next statement, 62
form(s)
adding to a database, 29
binding to ADO recordsets, 138
creating the user interface, 18
getting to the Visual Basic Editor from, 21
hiding to be reopened later, 325
loading, 47, 48
navigation and flow of, 181–187
obtaining a list of all open, 94–96
obtaining currently active, 98
opening from a switchboard form, 187
polishing, 197–198
properties of, 80
saving, 30, 87
form modules, 29
Form object, 94
Form_frmText object, 40, 41
Form_Load event
adding code to, 116, 119
adding to a form, 143, 150
code in, 138
ensuring changes are saved, 148, 156
for frmCustomers form, 505–506
for the frmProjects form, 410, 427
initializing frmContacts form, 441, 448–449
Form_Load event procedure, 511–512
Form_Load procedure, 135–136
Form_Unload event, 448, 451
Form_Unload procedure, 422–423, 437
Forms collection, 94
forward-only cursor, 133
frm (Form) prefix, 56
frmContacts form
building for Project Tracker, 440–451
creating, 351, 354–356, 357
writing code for, 441–451
frmCustomers form, 477–480, 504–512
frmProjects form
creating, 344–353, 357
example of, 410, 411
writing code for, 410–440
frmSearch form
adding a breakpoint to, 512, 513
creating, 475–477
writing code for, 500–504
frmTest form
Code Builder from, 40
creating a new procedure for, 37–40
displaying objects associated with, 40, 41
opening in View mode, 38
selecting from the Form Name field, 47, 48
FROM clause, 160–161
fsub (SubForm) prefix, 56
FullName property, 97
Function keyword, 42
function procedures, 42–44
functions
behind methods, 82–83
built-in, 45–46
built-in SQL Server, 275–277
calling from events, 45
calling from other procedures, 44–45
creating, 43–44, 114–115
defined, 33
scope and lifetime of, 45