Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Cannot get my Public Function with arguments to work
I found the solution here: http://support.microsoft.com/kb/312851 I had the name of the module the same as my function. Bad form.- mtnstream
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Cannot get my Public Function with arguments to work
I'm using Access 2010, standard module. The only declarations are Option Explicit and Option Compare Database.- mtnstream
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Cannot get my Public Function with arguments to work
I'm running the code from the standard module it is written in, and it displays the macro creation prompt any time I ask for parameters to be passed in. http://www.mtnstream.com/macroerror.jpg When I try and run it in the intermediate window I get "Compile Error: Expected variable or...- mtnstream
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Cannot get my Public Function with arguments to work
FYI....the code I pasted in reflects the code after applying an argument to the function. If you want to see the results as it should work, remove the argument and uncomment the strOrphans list on line 9.- mtnstream
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Cannot get my Public Function with arguments to work
Hello. I'm having issues with a MS Access Public Function that resides in a standalone Module. It is pasted below. When I run the code, it gives me the exact alphabetized list from an array that I was hoping for. However, when I try to add an argument to the Function so I can pass values to...- mtnstream
- Thread
- Replies: 8
- Forum: Microsoft: Access Modules (VBA Coding)
