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.
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
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:
Hanging over the textbox you will see the available short key and their interpretation.
Pops up the Constant Builder and fills the name and value fields.
