Index

F

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