Results 1 to 4 of 4
  1. #1
    snoopy is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    53

    VBA Reference, a good one


    He folks,

    is there a good vba reference with all built in functions, may also events and so on. I am just need a overview about all functions with explanation. I tried to search with google, did not find a good one. Furthermore I searched the forum, neither find one.

    Which one are you using?

  2. #2
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262
    i doubt there is. and the reason is probably because there's no money in putting such a thing together.

    but if you're interested, I keep track of all IDE's I work with. VBA was one of those, the file link at the bottom probably covers just about anything and everything related to VBA and Visual Basic 6. Sorry, couldn't attach it here cuz it's too big for zip files I guess.

    each table represents the different tiers that VBA operates under. FYI - the tiers, in order for libraries that it works with are (in general): library => coclass => method / property

    enums and vartypes are stand-alone entities. they are related to VBA only...so I guess I'm saying that this file covers the visual environment itself as well as external libraries that can be referenced.

    you might be able to get some use out of it too as a search tool. as you can see I started on a search form in case I forgot something. didn't finish it though. I may have only scanned a few different directories on my machine though. I know I scanned through the sys dir, but can't remember what else I did.

    regardless though, plenty of stuff here for just about anyone to chew on!

    good luck with it! It's huge!

    http://www.filefactory.com/file/4jlx..._abilities_zip

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Here's an alphabetical list of the most commonly used Functions in Access. Click on any of them for a short article on its use.

    http://webcheatsheet.com/sql/access_functions/

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262
    nice one Linq! good stuff there. did not know of that.

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

Similar Threads

  1. Replies: 3
    Last Post: 08-01-2012, 05:47 PM
  2. Is this a good database design?
    By Someday in forum Database Design
    Replies: 4
    Last Post: 07-22-2012, 06:50 PM
  3. Replies: 1
    Last Post: 06-06-2010, 12:29 PM
  4. SQL - Read any good books lately?
    By metaDM in forum Queries
    Replies: 2
    Last Post: 03-05-2009, 12:46 PM
  5. Creating a *Good* Custom Message Box
    By Jerimiah33 in forum Forms
    Replies: 1
    Last Post: 11-09-2005, 04:47 PM

Tags for this Thread

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