Access.2007.VBA.Bibl..

Special case for lines whose default name is “Line” or “Option” (same first three letters as the stan- dard prefix). If Left(pst ...

End If Resume ErrorHandlerExit End Function Public Function CreateCTTable() ‘Called from LNCRenameFormControls and ‘LNCRenameRep ...

!ControlType = 103 !ControlTypeName = “Image” .Update .AddNew !ControlType = 104 !ControlTypeName = “Command Button” .Update .Ad ...

!ControlType = 122 !ControlTypeName = “Toggle Button” .Update .AddNew !ControlType = 123 !ControlTypeName = “Tab Control” .Updat ...

FIGURE 13.8 A COM add-in button on the Add-Ins tab of the Ribbon in Access 2007. If you don’t see your COM add-in’s button(s) in ...

To install or uninstall COM add-ins, select COM Add-ins in the drop-down list at the bottom of the screen, as shown in Figure 1 ...

The name displayed in the “Add-Ins available” list is the one entered as the add-in’s name in the Designer, but curiously, the ...

To reopen a COM add-in for editing, double-click the .vbp (VB project) file. You need to have any supporting files (.bas, .dsr, ...

FIGURE 13.13 A COM add-in question. Saving the original control name to the Tag property can occasionally be useful, especially ...

Comparing COM Add-ins with Access Add-ins ................................................................ In previous versions ...

...

M ost of the sample databases for earlier chapters included objects from the Access 2007 Backup database, used to make incremen- ...

FIGURE 14.1 A security warning when attempting to install an Access add-in for Access 2007 running on Windows Vista. The Purpose ...

TABLE 14.1 Types of Access Add-ins Wizard Builder Menu Add-in Called when a new table, Lets you set properties in Not context-sp ...

FIGURE 14.2 The Access 2007 Office menu. On the Access Options dialog, select the Current Database section, as shown in Figure ...

Click the Navigation Options button to open the Navigation Options dialog, where finally you can check the “Show System Objects ...

FIGURE 14.5 System tables in the Navigation Pane. TABLE 14.2 The USysRegInfo Table Fields Field Data Type Usage Subkey Text The ...

FIGURE 14.6 An error when creating the Value field in the UsysRegInfo table. If you copy the USysRegInfo table from another add- ...

Menu Add-ins ........................................................................................................ A menu add ...

Wizards .................................................................................................................. My De ...