open function

[webdevop]

Can you open a module Public function from the
criteria line in query design view ?
If so what would be the build OR how would you call the function from query design view ?

Thanks, Webdevop

 

[Nowell]

Hi, I don't think you can do that, you would be better off using vba recordsets to run your sql, then you can call your public function and use sql in the same vba event.

 

[TonyJollans]

Hi webdevop,

If I understand correctly then you can use your own functions in a query in the same way as you use built in ones.

In the criteria line just enter =YourFunction(YourParam, YourNextParam) or similar.

In the BUILD interface, in the left hand column expand Functions then select your database; then in the middle column select the module you want and in the right hand column will be a list of available functions.

Enjoy,
Tony