Results 1 to 9 of 9
  1. #1
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    650

    Cheat sheet for VBA commands and functions

    I'm coming from an old, non-object, non-event-driven BASIC.



    Has anyone seen a good cheat sheet of all the commands, functions, etc. used in Access VBA?
    I Need a starting point for reference, I know what I want to do, but not the command/function in VBA.
    Things like number and string manipulations.

    It would be nice to have the same for objects and properties.

    They can be downloaded and printed, it would be nice to read when not online.
    It just needs a brief description and the parameters, maybe an example and that's it.
    The Microsoft documentation doesn't help much with this so far.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    650
    I went and looked there. They have one for basic and intermediate Access skills.
    Bit, I didn't find anything for VBA.

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

  5. #5
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    650
    This one seems quite extensive, but I'm not sure what they're selling. Have you used it?

  6. #6
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    650
    This one by MS :
    Functions (Visual Basic for Applications) | Microsoft Docs
    (found by a link in your link) doesn't have a short description, it's for VBA in general.
    For grins I tried finding Dlookup(). I admit I'm not sure where I should look, but I didn't see it.
    Still searching.

  7. #7
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    No, I have not bought nor used the referenced material. I was trying to find vba reference material oriented to MS Access.

    I realize you'd like a cheat sheet, but I have not found such.

    I have used/referenced the following links:

    http://www.functionx.com/vbaccess/
    https://www.vb123.com.au/
    http://www.cpearson.com/excel/vbaarrays.htm

  8. #8
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    @Orange - you forgot the one in your signature
    AccessFunctions_SyntaxAndExamples TechontheNet

    Dlookup comes under domain functions

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Sometimes (often lately) I overlook the "obvious"!
    Thanks for the reminder CJ.

    The M$oft function details has info also.

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

Similar Threads

  1. Replies: 4
    Last Post: 05-19-2021, 10:00 AM
  2. Replies: 5
    Last Post: 04-25-2017, 01:38 AM
  3. Button with too many commands?
    By santinimatias in forum Programming
    Replies: 6
    Last Post: 02-05-2015, 11:56 PM
  4. Replies: 26
    Last Post: 01-08-2013, 04:55 PM
  5. SQL Commands in VBA
    By chris.williams in forum Programming
    Replies: 4
    Last Post: 12-20-2012, 10:33 PM

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