By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,008 Members | 2,962 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,008 IT Pros & Developers. It's quick & easy.

How to call a function located in a form module (form open in form view) from an Access Basic global module?

P: n/a
MLH
I would like to call a function stored in a form module
in Access 2.0 from an Access 2.0 procedure in a global
module.

Function EmailTheOutletters () in module AppSpecific...
....
560 SSNtext = SelectRandomSSNtext(SSN)
....
End Function

SelectRandomSSNtext() is the procedure in the form module.
I would use the syntax shown in line #560 if I were calling the
function from within another procedure inside the form module.
Do I have to reference it any differently if calling it from outside
the form module?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I don't think this is possible with Access 2.0
Solution: Put your function in a global module, and you can access it from everywhere.

--
Hope this helps
Arno R
"MLH" <CR**@NorthState.net> schreef in bericht news:53********************************@4ax.com...
I would like to call a function stored in a form module
in Access 2.0 from an Access 2.0 procedure in a global
module.

Function EmailTheOutletters () in module AppSpecific...
...
560 SSNtext = SelectRandomSSNtext(SSN)
...
End Function

SelectRandomSSNtext() is the procedure in the form module.
I would use the syntax shown in line #560 if I were calling the
function from within another procedure inside the form module.
Do I have to reference it any differently if calling it from outside
the form module?

Nov 13 '05 #2

P: n/a
MLH
<snip>
I don't think this is possible with Access 2.0
Solution: Put your function in a global module, and you can access it from everywhere.

xxxxxxxxxxxxxxxxxxxxxxxxxxx
yes, I did that as work-around. It'll have to be
a permanent fix, I believe.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.