VBA & VBA GUI Guide?

[bginhb]

I'm looking for a comprehensive guide for Access 2007 and a tutorial for using the tools provided from the Visual Basic GUI - Project Explorer and Object Browser. I've been searching the web only to find lots of dead ends, misrepresentations and bit by bit solutions which seem to be specific solutions to specific problems.



I'm very comfortable with writing subroutines and functions and testing using all basic debugging facilities but I'm at a complete loss when it comes to using either of these two tools and believe they have the ability to assist me but every excursion into learning them has produced little success. I would have thought the product itself would provide me what I need in the way of a tutorial but if such is available I haven't been able to find it.

Any assistance would be appreciated,
bginhb

[Jester0001]

The book 'Access 2010 Inside Out' seems to be pretty good for VBA, as I just started reading it a few days ago. There is a .pdf chapter that is 132 pages long, which you can download here, along with all the exercise files for the book:

http://examples.oreilly.com/97807356...O_examples.zip

The Chapter on VBA can be found in the Bonus Content of the zipped folder, under Chapter 24.

[orange]

See this also
http://msdn.microsoft.com/en-us/library/aa468595.aspx