How to access user Functions in Expression Builder

[Maturi]

Hi,

I have a database called SODB

I have written a Public Function called - Public Function CheckFileExists (DocID) As String

I want to have access to it in a query

I am using Query Builder. Using Expression Builder I can see 'Functions' (with sub headings called 'Built-in Functions' and 'SODB')

But under SODB I cannot see my functions.

How do I write functions that can then be used in the Expression builder?

Thanks

 

[PHV]

Your functions should be defined in a standard code module.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Maturi]

PHV,

Sorry I'm a novice. What do you mean 'Standard Code Module'

Thanks

 

[PHV]

When in VBE menu Insert -> Module

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886