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...

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.

Thanks for the quick reply,

but it seems that the day has been too long :rolleyes:.. 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 :D