Access.2007.VBA.Bibl..

USysRegInfo system table

creating, 473–481

defined, 472

fields, 476–477

subkeys for Form Wizard add-ins, 479

subkeys for menu add-ins, 478

subkeys for property builder add-ins, 480–481

USysRibbons table, 523–525

V

variables

data typing, 601

naming convention, 11

Object type, 236

VBA versus VBScript, 601

VB 2005 Express, 562

VB 2005 XML Editor, 518–519, 525, 526

VBA. SeeVisual Basic for Applications

.vbs file format, 592

VBS (Visual Basic Script)

CopyAllTemplates.vbs script, 610–611

CopyTemplateUser.vbs script, 603, 607–608

CopyTemplateWorkgroup.vbs script, 603,

608–610

DailyDatabaseBackup.vbs script, 619–625

Delete Audible Files.vbs script, 616–619

Help file, 597–599

and Microsoft Script Editor, 592–596

New Document from Template.vbs script,

614–616

PrintInvoice.vbs script, 612–614

PrintReport.vbs script, 611–612

Rename Files.vbs script, 618

scheduling backup script, 619–625

versus Visual Basic for Applications, 599–603

visible XML element, 522

Visual Basic. See alsoVisual Basic for Applications

(VBA)

AccessDesigner module, 444–463

AddInErrprocedure, 441, 442

AddToCommandBarfunction, 440

command-bar buttons, 447–450

ControlCAfunction, 456–457

ControlCSfunction, 454–456

ControlNAfunction, 459–461

ControlSOfunction, 457–459

CreateCTTfunction, 461–463

CreateFormCommandBarButtonfunction,

443

CreateReportCommandBarButtonfunction,

443

creating COM add-ins by using VB 6.0,

436–467

DeleteFromCommandBarfunction, 440

LNCRenameFormControlsfunction, 443,

450–453

LNCRenameFormControls_Clickevent

procedure, 443

LNCRenameReportControlsfunction, 443,

453

LNCRenameReportControls_Clickevent

procedure, 443

naming projects, 463, 503–504

OnConnectionevent procedure, 443

OnDisconnectionevent procedure, 443

referencing projects to object libraries by using

VB 6.0, 438–439

RemoveAddInCommandBarButtonfunction,

443

SharedCode module, 439, 440–442

StripCharmfunction, 441

using legacy code for working with text files,

292, 296

Visual Basic for Applications (VBA)

Access add-in code requirements, 481–482

AddInErrprocedure, 581

ADO object model versus DAO object model,

89, 91–96, 110, 130

ArchiveDataprocedure, 53–58

argument styles, 102

BackupDBfunction, 279–281, 282

BackupFrontEndfunction, 489–491

Callbackfunction, 263, 264

callback procedures for Ribbon command

buttons, 542–547

U Index

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