using the CurrentUser function in a query.

[Guest]

this is a strange problem that probably has to do with the version of XP or
access.

When I use the function CurrentUser() as a criterion in a query I get the
message
FunctionName not valid.

when I use the CurrentUser() in an event it works fine.

I refreshed the references in an event but this did not solve the problem.

In the object library the currentuser() is in vmsacc9.olb but i do not think
this controls the functions in queries.

Do you know what needs to be reinstalled to work correctly. Is it also
possible that we have a memory problem ?

We run windows XP and access2000. We reinstalled access but it did not
improve.
Maybe the problem is with XP.

Yours P.Scaram

 

[Tom Ellison]

Dear PS:

I recommend you write a public function that accesses CurrentUser(). You
can then use this public function in your query with the same results.

Tom Ellison

 

[Guest]

Thank you for your answer.
This problem occurs only on one particular PC from many and I would change
the application only as a last resort.

Can you give me any more information about what windows library might need
to be reinstalled or whether an XP installation would improve things or some
reinstallation in general that would improve the problem.

Or please refer me to a technical windows team that might have an idea about
it.

thank you very much.

P. Scaram

 

[Rick Brandt]

Thank you for your answer.
This problem occurs only on one particular PC from many and I would
change the application only as a last resort.

Can you give me any more information about what windows library might
need to be reinstalled or whether an XP installation would improve
things or some reinstallation in general that would improve the
problem.

Or please refer me to a technical windows team that might have an
idea about it.

These problems occur when ANY library reference is broken. The missing library
does not need to have anything at all to do with the function that is failing.
You will have to examine the references on the PC having the problem to
determine what reference is marked "MISSING".

 

[Guest]

I tried using a Public local function and it still did not work. It seems to
have a problem using any function as criteria in a query.
The same functions seem to work in events without problem.

So the problem is particularly about using functions as criteria in queries.
Any suggestions about the particular problem ?

About the MISSING references the PC with the problem had Office 2002 using
Word, Excel and Access libraries 10 while the rest of the company had 9.0
libraries.

We reinstallled Office 2000 the libraries were not missing anymore but this
did not correct the problem.

On any other computer it works with XP SP1 and XP SP2.

Thank you in advance.

Philip