fields (continued)
ListTableFieldsprocedure, 542–545
selecting for PivotCharts, 22–23
selecting for PivotTables, 20–21
for user information, 31–33
in Word documents, 45–48
file formats
Access add-ins, 472, 473, 505, 511
Access Project files, 657–662
Excel files, 61, 183
HTML files, 338–347
Outlook files, 237
Visual Basic Script, 592
Word documents, 31, 146
Word templates, 31, 146
XML files, 338–347
File Location dialog, 605
FileDialogobject
AllowMultiSelectproperty, 270
ButtonNameproperty, 270
creating, 265–267
DialogTypeproperty, 270
Filters.Addmethod, 270
InitialFilenameproperty, 270
InitialViewproperty, 270
methods, 270
overview, 263–264
properties, 270
setting reference to object library, 268, 269
viewing MsoFileDialogViewin Object
Browser, 270
FileExistsmethod, 617
Files and Folders.accdb sample database, 264, 302
FileSystemObjectobject
CopyFilemethod, 282
FileExistsmethod, 617
GetFilemethod, 608, 609
GetFoldermethod, 281
GetSpecialFoldermethod, 617
Help file, 271–272
method for working with text files, 282, 290,
292, 296, 297, 298overview, 263, 264, 271
setting reference to Scripting Runtime Library,
271
Streamobject, 282
TextStreamobject, 282, 292
as VBS error handling alternative, 601
FillDatecontrolsprocedure, 204, 205
FillWithTypeTextprocedure, 28–30
filtering reports, 17–19
Filters.Addmethod, 270
Find*methods, 93, 101
FindFirstsearch method, 93–94, 101
FindLastsearch method, 101
FindNextsearch method, 102
FindPrevioussearch method, 102
firewalls
accessing SQL Server 2005 through Windows
Vista, 642–647
accessing SQL Server 2005 through Windows
XP, 640–642
fixed-width text files
in cmdExportJobs_Clickprocedure, 323
versus comma-delimited text files, 315
creating import specifications by using
TransferTextmethod, 306–311, 317
importation problems, 315
and TransferSpreadsheetmethod, 282
and TransferTextmethod, 282
flat-file tables, 352–359
Folderobject, 235
FolderPicker dialog, 141, 268–269
Folders.accdb sample database, 264
For Each...Nextstatement, 601
form fields, 45–48
form letters, Access, creating, 8–10
form Ribbons, 547–549
Form Wizard add-ins, 479
Format Axis dialog, 420
formatting files
Access add-ins, 472, 473, 505, 511
Access Project files, 657–662
Excel files, 61, 183F Index
25_047026 bindex.qxp 4/2/07 9:58 PM Page 682