Function is not available in expressions

A

Allan

I have developed an access data base to gather financial
data. I had tested the database on a single machine and it
performed without any problems. After I rolled the
database out, I received the following message on certain
machines:

Run-Time error '3075':
Function is not available in expressions in query
expression
'Trim(Str(Fix[field])))'

I figured it was a version issue but that did not resolve
the problem. Any ideas?

Allan
 
M

[MVP] S.Clark

Most likely a reference problem. Check Tools/references from any module.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Rate() function in expression builder 0
Query formatting for numbers. 2
error 3075: functions such as CHR$ not working on Vista 1
MS Outlook inbox to MS Accsess Database 0
Function is not available error in secured database 1
Error-17099 SMTP Relay Error Problem Entourage 2004 0
Function is not available in query expressions 1
Page numbering with Merged Document and IF statements 1

Top