Results 1 to 4 of 4
  1. #1
    MatthewGrace is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Jan 2013
    Posts
    159

    Your favorite resources for becoming and advanced VBA Programmer


    I happen across videos on Access VBA from time to time, most of them aimed at the beginner level. Some of these are very well made videos that take you by the hand through fundamental aspects of programming. Trouble is, I've long since exhausted all these resources and become "almost intermediate-ish", I'm finding far less quality teaching resources. I know what all the loops are and the most common properties and controls and such, but I'm seeing advanced users who have intimate understanding of many objects and are wizards with expression building, etc.

    I'm asking for anyone who is at the advanced level to chip in if they've discovered a resource that provided them a bolus of VBA-skill when they were at the intermediate level.

    Thanks for sharing!

  2. #2
    CJ_London is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    For me it is just google or bing and learning on the job - I don't think you will find advanced training on the web - perhaps a college or training centre of some sort which you can attend. I still learn today on this and other forums.

    Once you have learned the basics it and start to delve into more complex and often specific requirements, they are often for the benefit of a relatively small audience. Someone, somewhere will no doubt have had the same requirement at some point which you can find on the web through one of hundreds of forums. Perhaps not the exact solution you require, but enough to set you off in the right direction. Sometimes the trick is just to find the right keyword to use.

    And sometimes curiosity - there are hundreds of properties/event for controls, forms etc most of which are never modified - so you never find out or really understand what they do, but google them and find out and put the knowledge away until you might need it.

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    For me, studying C# and using Visual Studio is what helped my VBA skills. Also, studying Application Architecture helped A LOT. What these things taught me was not VBA, but taught me how to better understand application development and books like Access 2010 VBA Programming Inside Out ...
    https://www.microsoftpressstore.com/...-9780735659872

    Visual Studio costs money, but you can download free versions. One issue with learning is that curriculum becomes outdated fast. So, if you download the latest free version of Visual Studio Community, you may not be able to follow along with all of the labs within a specific tutorial. The tutorial may ask you to 'click here' and, in your version of the IDE, that option is not available or it is somewhere else or it is already baked into your IDE.

    I would start by trying to follow along with a programming tutorial that uses Visual Studio. Here is one that was made a few years ago for Visual Basic. I looked at the link and it seems the first video of the series is on the last page.
    https://channel9.msdn.com/Series/Vis...lute-Beginners

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 09-02-2015, 02:17 PM
  2. Access Programmer
    By Kristi.owen091010 in forum Access
    Replies: 1
    Last Post: 04-01-2012, 08:45 PM
  3. Access 97 programmer needs a refresh
    By rlam in forum Programming
    Replies: 1
    Last Post: 02-02-2012, 12:18 AM
  4. Programmer Wanted
    By Hoota Caroota in forum Access
    Replies: 2
    Last Post: 11-15-2010, 08:56 PM
  5. DB2, MySQL Programmer needs Access Answer
    By cgaccess in forum Access
    Replies: 1
    Last Post: 09-23-2010, 09:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums