Function can be found

[Sarah at DaVita]

I made a public function called BulkMail(). When I try to use the runcode or
openfunction in macros access cannot find the function. Can someone tell me
how to have access recognize this function?

 

[John W. Vinson]

I made a public function called BulkMail(). When I try to use the runcode or
openfunction in macros access cannot find the function. Can someone tell me
how to have access recognize this function?

You're sure it's public, and in a public module - not private, and not in a
Form's module? Perhaps you could post the code, or at least the Function
statement. Also... be sure that you use Debug... Compile <my database> to
ensure that the function is compiled, and then click the Save (diskette) icon
in the toolbar.


John W. Vinson [MVP]

 

[Tom Wickerath]

Hi Sarah,

To add some to John's comments, verify that the name of the module is not
the same as the name of your function. You need to use the RunCode action,
not the OpenFunction action.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Sarah at DaVita]

I got it. Had the same names. Thanks!!!

Hi Sarah,

To add some to John's comments, verify that the name of the module is not
the same as the name of your function. You need to use the RunCode action,
not the OpenFunction action.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Wickerath]

Hi Sarah,

Glad to read that you got this working. Good luck on the rest of your project!


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________