Bang Notation and Dot Notation in VBA and MS-Access

by

Despite the (formerly) accepted answer to this question, the bang is not in fact a member or collection access operator. It does one simple and specific thing: The bang operator provides late-bound access to the default member of an object, by passing the literal name following the bang operator as a string argument to that default member.

That’s it. The object doesn’t have to be a collection. It doesn’t have to have a method or property called Item. All it needs is a Property Get or Function which can accept a string as the first argument.

For much more detail and proof, see my blog post discussing this: The Bang! (Exclamation Operator) in VBA

More Related Contents:

  1. How does one decompile and recompile a database application?
  2. What are the rules governing usage of parenthesis in VBA function calls?
  3. Autonumber value of last inserted row – MS Access / VBA
  4. Code to loop through all records in MS Access
  5. How do I force VBA/Access to require variables to be defined?
  6. VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)
  7. How to diagnose MS access crashes
  8. Equivalent cURL in VBA?
  9. How do I access the selected rows in Access?
  10. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  11. Prevent enabling of shift bypass – Access 2010
  12. VBA procedure to import csv file into access
  13. Transform multiple rows into columns with unique key
  14. how to show query results in a datasheet in the same form?
  15. Access VBA: Find max number in column and add 1
  16. MS Access prepared statements
  17. Create sequential ID value based on the year that a record is added
  18. UrlDownloadToFile in Access 2010 – Sub or Function not Defined
  19. Null values for variables in VBA
  20. Using a centralized VBA module in multiple Access databases
  21. How to execute a query in ms-access in VBA code?
  22. How to add a menu item to the default right click context menu
  23. VBA – Run Time Error 3271 using DAO object
  24. Trouble with InputBoxes
  25. Get Name of Current VBA Function
  26. Getting Error 3340 Query ‘ ‘ is corrupt while executing queries DoCmd.RunSQL
  27. Select Case True
  28. Access query producing results like ROW_NUMBER() in T-SQL
  29. Calling stored procedure using VBA
  30. ODBC Call Failed with stored procedure – Pass through query

Leave a Comment