ConcatRelated function in a query

by

Do not call the Module the same as the function, it can sometimes make things confusing for VBA.
Rename the module something like “DatabaseUtils” for instance.

Make sure the function is really defined as Public Function ConcatRelated(..., the Public here is important, otherwise the function will not be visible outside the module itself.

More Related Contents:

  1. ConcatRelated() in Access, using two keys
  2. Concatenating multiple rows into single line in MS Access [duplicate]
  3. Combine values from related rows into a single concatenated string value
  4. What are the rules governing usage of parenthesis in VBA function calls?
  5. Autonumber value of last inserted row – MS Access / VBA
  6. How to get random record from MS Access database
  7. create form to add records in multiple tables
  8. Operation must use an updatable query. (Error 3073) Microsoft Access
  9. How do I force VBA/Access to require variables to be defined?
  10. Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
  11. Running Microsoft Access as a Scheduled Task
  12. “Operation must use an updateable query” error in MS Access
  13. How to restart counting from 1 after erasing table in MS Access?
  14. Equivalent cURL in VBA?
  15. MS Access trigger?
  16. Insert SQL command with Datetime in MS-Access
  17. How do I execute multiple SQL Statements in Access’ Query Editor?
  18. Is MS Access (JET) suitable for multiuser access?
  19. VBA procedure to import csv file into access
  20. How to select top 10 in Access query?
  21. Transform multiple rows into columns with unique key
  22. how to show query results in a datasheet in the same form?
  23. Selecting 2 tables from 2 different databases (ACCESS)
  24. connected combo boxes in continuous form – the second combo doesn’t show its value if dependent on first combo how could I fix that
  25. Linked table ms access 2010 change connection string
  26. Access 2007 – INSERT and instant SELECT doesn’t retrieve the inserted data
  27. Create sequential ID value based on the year that a record is added
  28. How to use cross join in access?
  29. Get Name of Current VBA Function
  30. How to extract the schema of an Access (.mdb) database?

Leave a Comment