[AccessD] Sample vba to get code (event procedurecode)behindform/controls

[Arthur Fuller]

A very good overview of MS-Access collections is available at Collections
Overview <http://www.yevol.com/en/vbaccess/Lesson03.htm>. There are
built-in collections such as AllForms, which (gasp) presents all the forms
in the CurrentProject object; you can then walk through the collection and
manipulate each item as you wish.

See AllForms collection
<https://msdn.microsoft.com/en-us/library/bb214271%28v=office.12%29.aspx>
for more information and sample code.

There are equivalent collections available for reports, queries and modules.

Hope this helps.

Arthur

On Wed, Mar 25, 2015 at 10:22 PM, Bill Benson <bensonforums at gmail.com>
wrote:

> Does vba extensibility work for Access objects, Ie.
>
> Dim vbc as vbComponent
> For each vbc in currentdb.vbproject or some such?