Hi
I've got a VBA function that returns a string in my Access 2010 app.
To show the value on a form I can add a textbox and set the Control Source to '=MyFunction()'. Works fine.
Now I move the function to another Access accdb file, that acts as a Library, and I add a reference to that accdb in my app. If I run '?MyFunction' from the Immediate window it works, but when I add '=MyFunction()' in a textbox on a form it shows #Error.
The other sad thing is that it works on 1 PC, but not on another. Any clues? Registry entries perhaps?
I also find that if I create a 'proxy' function it works. Thus if I create another function, let's say:
Public Function CallMyFunction() as String
CallMyFunction = MyFunction()
End Function
I don't really want to create proxies for everything. And that's only on some PC's.
I've got a VBA function that returns a string in my Access 2010 app.
To show the value on a form I can add a textbox and set the Control Source to '=MyFunction()'. Works fine.
Now I move the function to another Access accdb file, that acts as a Library, and I add a reference to that accdb in my app. If I run '?MyFunction' from the Immediate window it works, but when I add '=MyFunction()' in a textbox on a form it shows #Error.
The other sad thing is that it works on 1 PC, but not on another. Any clues? Registry entries perhaps?
I also find that if I create a 'proxy' function it works. Thus if I create another function, let's say:
Public Function CallMyFunction() as String
CallMyFunction = MyFunction()
End Function
I don't really want to create proxies for everything. And that's only on some PC's.
Last edited:
