custom function in query runs multiple times

[Michael]

Hi all,

I have a custom function that I am calling from a query.
The problem is that this function is then executed 3 times
instead of just once. I found the following
Microsoft Knowledge Base Article - 304098

ACC2000: Custom Function Called by a Query Runs Multiple
Times on a Computer Running Windows 2000 SP1.

This states there is a bug in the jet 4.0 engine and to
fix this install the latest service pack (8). I have done
this and still the problem persists.

Does anyone know of a way to fix this??
Im running windows 2000 sp3 and access 2000

Thanks.

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Remove any extra filters/sortings on the query. How:

Run the query (double-click on the query object).
When the datasheet appears right click on the dataset.
Select Remove Filter/Sort.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQSpTqoechKqOuFEgEQKAMgCeK/rc/CoUJ5GcVGX6bqRSfPWLy/AAnjIe
Kd3DiY7qp07P5lsMna3nYWU/
=KBRd
-----END PGP SIGNATURE-----

 

[Guest]

Thanks for the reply,

Forgot to mention it's an update query being called
onClick of a button.

I tried doing what you suggested but it didn't make any
difference still runs the function 3 times. Unless any one
has any other suggestions I might have to write the query
into VB then I can get the value and put it into the query
via a variable rather then having the query call the
function to get the value.