D

DailyDatabaseBackup.vbs script, 619-625 DAO and ADO Sample Code.accdb sample database, 90 DAO object model

ADO object equivalents, 130

versus ADO object model, 89, 91-96, 110, 130

converting code to ADO, 129-131

databases, 99

defined, 90

fields, 106-109

hidden objects, 98-99

illustrated, 97 new objects, 97-98 old versus new, 90, 96-109 overview, 96 QueryDefs, 104-106 recordsets, 99-104 support in Access 2007, 90, 91-96 TableDefs, 106-107 when to use, 110 data sources qryOrdersAndDetails query, 62, 63 queries as, 50, 51, 52 data transfer, history of techniques, 3-4 Database object, 99, 130 databases. See also Access backing up by using BackupDB function, 279-282

backing up by using BackupFrontEnd function, 489-491 backing up to Access database folder, 277-279 creating client/server applications, 657-662 creating connections, 111 creating from templates, 225-229 importing legacy files, 324-328 naming conventions, 11

preparing for upsizing to SQL Server, 629-631 sample, 230-233 datasheet reports, 11-19 Date field, 157 dates calendar pop-up icon, 52, 53, 320 code for creating filtered queries, 54 saving in Word documents, 157 dBASE. See legacy files DBEngine object, DAO, 98, 130 DDE (Dynamic Data Exchange), 3, 4 debugging

Access add-ins, 582-583 and Debug.Print statement, 601 DefaultItemType property, 240 Delete Audible Files.vbs script, 616-619 DeleteFromCommandBar function, 440 denormalizing, defined, 352

Designer dialog, 439-440 DialogType property, 270 digital signature creating for signing VBA code, 398-402 why not to create for Access add-ins, 511 DLL files copying to default Add-ins folder, 463 creating, 463

troubleshooting COM add-ins, 466 .doc file format, 31, 146 DoCmd object

CopyObject method, 109 OpenQuery method, 109 RunSQL method, 109 DocProperty field, Word versus Access Memo field, 10

placing in Word templates where Access data should appear, 39-45 using field switches to format data, 152-153 Document Information Panel, 148 Document object, Word, 139 document properties accessing, 146-149 advantages and disadvantages, 145 creating, 149-150

MergeDocProps procedure, 160, 161-164 as method for merging Access data to Word,

145,146-165 overview, 39-45

working around limitations, 149-150 writing values to, 152 Documents collection, 139 documents, Word code for creating using bookmarks, 36-37 code for creating using DocProperties field, 43 creating by using cmdWord_Click event procedure, 154-157 creating by using templates, 30-45 exporting Access data to, 135-138 file formats, 31, 146 mail merge, creating, 176-182 saving date, 157 .docx file format, 31, 146

.dot template format, 31, 146 .dotx template format, 31, 146 drop zones, 20, 22, 23

drop-down content controls, inserting into Word templates, 45-48 dropDown XML element, 522 DSN Wizard, 665-669 dynamic cursors, 117, 121, 122 Dynamic Data Exchange (DDE), 3, 4 dynamic recordsets, 104 dynaset-type recordsets, 100, 101-103, 130

0 0

Post a comment