We have a user who is suddenly getting the following error message
when they start our very mature application. Other users of the same
version are NOT getting this error:
"Error 3075 - Function is not available in expressions in query
expression 'Trim([tblProspects]![Email])' "
I believe that this function comes from the DAO 3.6 library.
Anyone have a clue how we can fix this problem?
Thanks for all responses gentlemen,
-- LW
If your user is getting this message while using
MS Access, then you have a 'references' problem.
Open the database in Access, open a code module,
and check Tools, References.
(david)
"Lauren Wilson" <nos...@nospam.com> wrote in message
news:218j12lat3nhp5jia...@4ax.com...
James
We modified our update installer to include the WMI Scripting lib and
the problem went away after update.
Your contributions to this group are very much appreciated.
Live long and prosper!
-- LW
Are you talking about this:
SELECT myTable.* FROM myTable WHERE TableID=Forms!myForm!SelectAnID
This works fine in AC2003, AK2k, AC97.
--
Bri