Can't call functions in query builder

  • Thread starter Thread starter oraustin
  • Start date Start date
O

oraustin

I've got a copy of an access Db - I think created with Access 2003
My version at home is 2000
Anyway...when I try to call my function TimeClass() from within an
access query it doesn't recognise the function name.
Please help me spot the schoolboy error
Thanks
 
I've got a copy of an access Db - I think created with Access 2003
My version at home is 2000
Anyway...when I try to call my function TimeClass() from within an
access query it doesn't recognise the function name.
Please help me spot the schoolboy error
Thanks
Click to expand...

If the TimeClass function is your own, I presume you have copied the module
containing it into the database you are working with?
 
Yep!! - in fact I just wrote it
If the TimeClass function is your own, I presume you have copied the module
containing it into the database you are working with?
Click to expand...
 
honestly both code and query are fine - I'm quite a long term user of
access
one thing it might be is that not all the code compiles???? (although
this function does)
basically its some setting or incompatibility somewhere that I bet has
been encountered before.....just I don't know what it is :)
thanks
the function is declared as public - although from what I rememebr that
is not neccessary as public is the default.
 
<LOL> Well I guess it's in there then! Sorry, but you did ask for the
obvious...

Here's another obvious: you DID declare the function as public, right?

Might be worth posting both the code for the function and the SQL for the
query.
 
If you code doesn't compile this could cause unknown issues. I would make
sure all code compiles if I want to use any code. Find your issue and fix
it.
 
In what respect does the code not compile? Is it another problem with an
unrecognised function? Maybe you have a missing reference?

In the code window, Tools-->References, and look for MISSING (sorry if you
already know this, I don't intend to patronise you!)

Yes, Public is the default in a module.
 
Back
Top