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

[jack drawbridge]

Thanks for the responses and thanks Arthur for the link. One that I found
to be useful is
http://www.codeproject.com/Articles/640258/Deconstruction-of-a-VBA-Code-Module

And Bill, I haven't worked with extensibility --quite honestly never knew
about it other than one of the files in a "Reference list".

Jim's example got me headed in a "better" direction.
Thanks all for responding.
jack

On Thu, Mar 26, 2015 at 6:07 AM, Arthur Fuller <fuller.artful at gmail.com>
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?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>