Insert Objectname

The Insert Objectname tool let's you pick up about any string in your VBA project (MS Access, Excel or Word). It let's you find what again was the name of that - table, field, commandbar, reference, ... Select name of objects to insert instead of having to look the name and copy/paste/retype. Add the appropriate elements to surround the string. Insert by [Insert] or by double-click on the item. [Constant] will bring up the Constant Builder dialog with names filled in.

Start from Shortcuts Insert Name, using Alt-CO ( Objectname), <Object Name> in popup on Fragment Builder and Line of Code Builder and Constant Builder.

Intelligence

When first an item is inserted from the Objects list, and next one from the Names list (less then 4 seconds after the first) the program interprets the insertion as below:

1. collection with instance  CommandBars | Menu Bar >>  CommandBars ("Menu Bar") 

2. NOT collection with instance

2.1 Access +  a table/query  Payments | PaymentAmount  >>  [Payments].[PaymentAmount]

2.2 Access +  report/form  Fee Schedules | Fee  >>  Forms![Fee Schedules]![Fee]

2.3 all other cases > no intelligense

Controls:

• Objects
• Names
• Insert
• Use
• Constant
• Close
• Help

---

Objects

Shows which objects and collections are available

Names

Controls or fields belonging to the object.

Insert

Insert the item that has focus.

Use

This textbox let's you indicate with a short key entry what extra surrounding characters you want. If you enter ( the selected item will get round brackets,

Examples:

• "Total Payments"
• & "Total Payments" (concatenating strings)
• 'RegistrationId','Total Payments', (use with SQL in code)

Hanging over the textbox you will see the available short key and their interpretation.

Constant

Pops up the Constant Builder and fills the name and value fields.

Close

Close the dialog.

Help

Shows this help topic.