Access.2007.VBA.Bibl..

FileSystemObjectmethod, 292, 296

fixed-width, 282, 315

free-form, 282

importing data in VBA code, 312–320

methods for working with VBA code, 290,

291–292, 296

reading data from, 292–297

sending as email attachments, 348–350

types, 282

using TransferTextmethod, 306–323

writing data to, 282–292

TextStreamobject, 282, 292

timesheets

cmdClearTimesheet_Clickprocedure, 207

cmdSaveTimesheet_Clickprocedure,

207–208

CreateExcelTimesheetsfunction, 211,

212–218

engineering firm example, 202–218

filling in Access forms, 202, 203–211

frmWeeklyTimesheetform, 202, 203–211

overview, 202

qryNeedTimesheetsquery, 202

qryThisWeeksTimesheetsquery, 202

transferring Access data to Excel, 211–218

txtEmployeeID_DblClickprocedure,

209–211

titles. See alsorenaming

for add-ins, 502

assigning to PivotCharts, 421

save names for worksheets, 195

TodayDate document property, 157

TransferDatabasemethod, 327, 330

TransferSpreadsheetmethod

and comma-delimited text files, 282

defined, 184, 305

in ExportAccountSummaryprocedure, 195,

196, 201

exporting Access data to Excel, 62, 184, 186

importing Lotus 1-2-3 data to Access, 328

TransferTextmethod, 282, 306–311, 316,

317, 342

TransferToExcelfunction, 186

troubleshooting

Access add-ins, 503–507

add-ins, 506–507

COM add-ins, 466–467

Trust Center, 508–509

trusted locations, 508–509

txtEmployeeID_DblClickprocedure, 209–211

TypeTextmethod

advantages and disadvantages, 146

defined, 28

FillWithTypeTextprocedure, 28–30

MergeTypeTextprocedure, 170–175

as method for filling Word documents with

Access data, 27–30

as method for merging Access data to Word,

146, 170–175

U

UpdateAllAccessContactsprocedure,

382–391, 390

UpdateAllOutlookContactsprocedure,

376–382, 390

Upgrade Report, 562–563

Upgrade Wizard, 562

Upsizing Wizard

Access 2003 versus Access 2007, 627

converting Access tables to SQL Server tables,

649–655

creating client/server applications, 658–659

preparing Access databases for upsizing to SQL

Server, 629–631

versus SQL Server Migration Assistant for

Access, 671–672

user addresses, 31, 32, 33

user information fields, 31–33

user names, 31, 33

User Templates folder

copying templates to, 603

setting path, 604–605

viewing path, 604–605

Usersobject, DAO, 99

Index U

25_047026 bindex.qxp 4/2/07 9:58 PM Page 695