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

[jack drawbridge]

Bill,
When I re-read my previous message, it seems I was not clear. Yes, vba
extensibility is key to getting at "the stuff 'hidden' behind our typical
vba/Access. Truth is, I hadn't been aware of vba extensibility, but it's at
the heart of code to work with Procedures, modules tucked away by Access.

Here is another link on the subject.
http://www.devhut.net/2011/06/04/vba-vbe-enumerate-modules-procedures-and-line-count/

jack

On Thu, Mar 26, 2015 at 7:38 AM, jack drawbridge <jackandpat.d at gmail.com>
wrote:

> 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
>>
>
>