error with query expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

a query that I've designed runs on my computer, but throws an error on another computer. Error reads

The expression On Click you entered as the event property setting produced the following error: Function is not available in expressions in query expression 'Left([OrigTime],4) & " " & Right([OrigTime],8)
*The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]
*There may have been an error evaluating the function, event, or macr

Any idea of what the problem is?
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

First try compiling the application, then run the query again.

If that doesn't work it is probably the References on the other computer
are not the same as the designing computer. Open a VBA module & from
the main menu click Tools > References and make sure all the checked
items are the same on both computers.

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

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

iQA/AwUBQI1bPoechKqOuFEgEQLtYACeJ8Sk/o6eAzb0k32ohzAs9dZ2ilEAoJtQ
o5dvjJWYdhf6FRXEdLuPaEMr
=SSNn
-----END PGP SIGNATURE-----
 
Back
Top