Adding a function to the expression builder

[Climbo]

Hello there,

I just create a VBA function and I'm wondering if it is possible to add it to Access Expresion builder, so I can call it from any queries...

 

[boblarson]

You need to put it in a Standard Module and make it Public. So, you put it in a standard module (not a form's module) and set it public by either adding the public keyword or by removing the Private keyword:

Public Function YourFunctionName()

or

Function YourFunctionName()


like that and then it should show up in the list.

 

[Climbo]

Thanks for the quick reply,

but it seems that the day has been too long .. there were a few words missing in my question.

I already had the function in a public module, and I can get it in my DB.

What I truely want , is to be able to use that Function in any query.. IN ANY DB.

so when expanding the functions, in addition of built-in functions, I would like to have another folder called MyFunction, which would regroup all function I'll do in the future, accessible from any DB I use...

sorry for the confusion... almost time to go home