F

Field object, 94-96 fields in ADO object model, 94, 95-96, 130 creating to store RTF data, 5-6 creating via NewTable procedure, 106-109 in DAO object model, 92, 94-98, 130 ListQueryFields add-in, 495-497, 511, 513-514

ListTableFields add-in, 497-499, 511, 514

fields (continued)

ListTableFields procedure, 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 FileDialog object

AllowMultiSelect property, 270 ButtonName property, 270 creating, 265-267 DialogType property, 270 Filters.Add method, 270 InitialFilename property, 270 InitialView property, 270 methods, 270 overview, 263-264 properties, 270

setting reference to object library, 268, 269 viewing MsoFileDialogView in Object Browser, 270 FileExists method, 617

Files and Folders.accdb sample database, 264, 302 FileSystemObject object CopyFile method, 282 FileExists method, 617 GetFile method, 608, 609 GetFolder method, 281 GetSpecialFolder method, 617 Help file, 271-272

method for working with text files, 282, 290, 292, 296, 297, 298

overview, 263, 264, 271

setting reference to Scripting Runtime Library, 271

Stream object, 282 TextStream object, 282, 292 as VBS error handling alternative, 601 FillDatecontrols procedure, 204, 205 FillWithTypeText procedure, 28-30 filtering reports, 17-19 Filters.Add method,270 Find* methods, 93, 101 FindFirst search method, 93-94, 101 FindLast search method, 101 FindNext search method, 102 FindPrevious search 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_Click procedure, 323 versus comma-delimited text files, 315 creating import specifications by using

TransferText method, 306-311, 317 importation problems, 315 and TransferSpreadsheet method, 282 and TransferText method, 282 flat-file tables, 352-359 Folder object, 235 FolderPicker dialog, 141, 268-269 Folders.accdb sample database, 264 For Each...Next statement, 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, 183

HTML files, 338-347 Outlook files, 237 Visual Basic Script, 592 Word documents, 31, 146 Word templates, 31, 146 XML files, 338-347 Form_Load procedure, 484-485 forms, Access creating emails from, 81-85 Event List form, 230-231 frmWeeklyTimesheet form, 202, 203-211 Rich Text-enabled text blocks on, 6-8 sample, 230-233

selecting for comparing Access and Outlook contacts, 359-360 selecting from templates, 230-231 Task List form, 230-231 forward-only cursors, 117, 122, 127-129 forward-only recordsets, 100, 103 free-form text files, 282 frmCompanylnfo form, 355-357 frmContactlnfo form, 353-355 frmSelectOrdersForShipping form, 403, 404 frmTextlmport form, 292, 293, 297 frmWeeklyTimesheet form, 202, 203-211

0 0

Post a comment