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

John W. Colby jwcolby at gmail.com
Thu Mar 26 08:32:58 CDT 2015


Access is built around collections, every thing you can think of uses 
collections.

Fields, properties, controls, you name it.

John W. Colby

On 3/26/2015 6:07 AM, Arthur Fuller wrote:
> 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?



More information about the AccessD mailing list