ACC: How to Pass an Array as an Argument to a Procedure (116140)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q116140
Moderate: Requires basic macro, coding, and interoperability skills.
SUMMARY
In order for a procedure to accept an array as an argument, the procedure
must declare the array argument, with opening and closing parentheses after
the argument name. Additionally, when passing the array to the procedure,
you must include parentheses after the array name, unless you are using
Visual Basic. Otherwise, you may receive the error message "Parameter type
mismatch" or "Duplicate definition."
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
NOTE: Visual Basic for Applications is called Access Basic in Microsoft
Access versions 1.x and 2.0. For more information about Access Basic,
please refer to the "Introduction to Programming" manual in Microsoft
Access version 1.x or the "Building Applications" manual in Microsoft
Access version 2.0
REFERENCES
For more information about Arrays, search the Help Index for "Arrays."
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming KB116140 |
---|
|