A

.accda file format, 472, 473, 505, 511. See also add-

ins, Access .accdb file format, 471, 473, 482, 511, 671 Access backing up databases, 277-282 calendar pop-up, 52, 53, 320 comparing add-ins with COM add-ins, 469 comparing contact data with Outlook contact data, 359-390 concatenating data for export, 143-144 CopyAccessAttsToAccess procedure, 394-395

CopyAccessAttsToOutlook procedure,

391-392

CopyAccessContactsToOutlook procedure, 390

CopyAllOutlookContactsToAccess procedure, 390 CopyOutlookAttsToAccess procedure,

392-393

CreateProjectAppts procedure, 245-247 CreateProjectTasks procedure, 253-254 creating client/server applications, 657-662 creating databases from templates, 225-229 creating denormalized tables from linked tables,

352-359 creating e-mails from tables, 81-85 creating form letter reports, 8-10 creating worksheet-type reports, 11-25 DAO support, 90, 91-96

ExportAccountSummary function, 195-200 ExportAppointmentsToOutlook function, 241-243

ExportContactsToExcel function, 191-195 ExportFlatFileContactsToOutlook procedure, 255-258 exporting appointment data to Outlook, 72-78, 241-243

exporting contact data to Outlook, 255-258 exporting data to Excel, 184-187 exporting data to Outlook items, 220-233 exporting data to unformatted Excel worksheets, 50-52

exporting data to Word documents, 135-138 exporting data to Word using Automation code, 138-182

exporting mainframe data as Outlook Journal items, 79-81 exporting queries to Excel, 184-187 exporting task data to Outlook, 72-78, 247-249 ExportTasksToOutlook function, 247-249 filling Word documents with Access data by using TypeText method, 27-30 Help overview, 272-277 history of data transfer techniques, 4 ImportApptsFromOutlook function, 243-245 ImportContactsFromOutlook function, 259-262

importing Outlook appointment data from, 243-245

importing Outlook contacts to, 259-262 ImportTasksFromOutlook function, 250-251 Layout view, 134-135

methods for merging data to Word, 145-182 new templates in Access 2007, 230-233 Object Browser, 94

Access (continued)

placing indicators in Word templates where data should appear, 30-45 preparing databases for upsizing to SQL Server, 629-631

SQL Server Migration Assistant, 671-672 storing data, 4

transferring timesheet data to Excel, 211-218 using to enter and edit data, 4 Word Mail Merge feature, 136, 138 Word (RTF) feature, 136, 137 working with attachments, 391-396 working with older format databases in Access 2007, 91-96 Access Interoperability reference, 571-573 Access Options dialog Add-ins page, 465, 587 Current Database page, 474, 524, 546, 630 Customize page, 518

Navigation Options button, 475, 524, 630 opening, 513-514 Trust Center Page, 508 Access Projects, 657-662 Access to Excel.accdb sample database, 49 Access to Outlook.accdb sample database, 72 Access to Word.accdb sample database, 27 AccessDesigner module opening, 442 Visual Basic code, 443 working with add-in events, 442-443 action queries, 106

ActiveX controls, 229. See also ADO object model Add a Program dialog, 641-642, 645, 646 Add Add-ins dialog, 466 Add method, 236-237 AddButtons custom form Ribbon, 547-549 Add-In Manager dialog, 478, 502, 509 AddlnErr procedure, 441, 442, 581 add-ins, Access building, 583-587 code requirements, 481-482 comparing with COM add-ins, 469 construction tips, 482-483

creating, 471-514 customizing Ribbon with, 549-560 debugging, 582-583 Extras add-in code, 483-499 Extras (Ribbon).accda, 549, 552 Extras 2007.accda, 471, 510-514, 549 finalizing, 502-503

installing, 507-510, 549, 550, 551-552, 583-587 interpreting error messages, 506-507 library database properties sheet information,

502-503 location, 477 menu, 478, 549-560 property builders, 480-481 purpose, 472 and Registry, 472 shared, 563-565 signing code, 511 storing, 472 testing, 588-589 troubleshooting, 503-507 types, 472-473 version issues, 472, 510 and VSTO, 563-565 as wizards, 472-473, 479 writing code, 481-483 add-ins, COM

comparing with Access add-ins, 469 creating by using Visual Basic 6.0, 436-467 creating LNC Control Renaming add-in,

440-463 customizing, 438-440 installing, 463-466 selecting template, 436-440 troubleshooting, 466-467 using, 467-468 Add-Ins menu, 510 addresses code for updating in Access, 385-387 creating shipping labels in Word, 397-415 labels for Mail Merge, 175-176 synchronizing, 353-354 as user information field, 31-33

AddToCommandBar function, 440 ADO object model code limitations, 129 Command object, 113-116 Connection object, 110-113 converting DAO code to, 129-131 versus DAO object model, 89, 91-96, 110, 130 defined, 90

equivalents of DAO objects, 130 method for working with text files, 291, 296 role of Object Browser, 94 .adp file format, 657-662

AdventureWorks SQL.accdb sample database, 627 AllowMultiSelect property, 270 apostrophe ('), 366 append queries, 314, 315, 317 Application object, 139, 234-235, 236 appointments, Outlook

CreateProjectAppts procedure, 245-247 creating based on Access table data, 245-247 ExportAppointmentsToOutlook function, 241-243

exporting Access table data to, 241-243 exporting to Access tables, 243-245 importing from Access, 72-78 ArchiveData procedure, 53-58 arguments, 102 attachment fields adding to Access tables, 391 data type, 297, 391 illustration, 298 loading files, 299-302 overview, 297 attachment icons, 297 attachments adding by using Attachments dialog, 298-299 adding by using LoadAttachments procedure, 299-302

CopyAccessAttsToAccess procedure, 394-395

CopyAccessAttsToOutlook procedure, 391-392

CopyOutlookAttsToAccess procedure,

392-393 handling in Access, 391-396 handling in Outlook, 391-396 PDF Products to Reorder report, 432 PDF shipping report, 428, 430 SaveAttachments procedure, 302-304 saving, 302-304

selecting Attachments folder path, 357-359 Automation. See also Visual Basic for Applications (VBA)

code for creating blank Word documents, 27-28 code for creating Word documents by using bookmarks, 36-39 FillWithTypeText procedure, 28-30 history, 3-4 axes, PivotChart formatting, 419-420 naming, 23

0 0

Post a comment