Function is not available

[cschnable]

I have a program which is run from an Access mde file in a runtime environment and a few people using it on their computers get this error when trying to open the referenced form. 99% of the people can open the form with no problem.


Function is not available in expressions in query
'Round((Date()-[M_Member_Since])/365.25,0) & "Years"


Is it possible that they are missing something in their runtime files or is something not referenced in the VBA reference library which should be.

 

[PHV]

The runtime version should be the same as the full access version that generated the mde.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

Do the people having the problem have the same OS as those that don't have the problem?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[cschnable]

I am using the Sagekey Solutions runtime package so I really don't think it is the runtime causing the problem and all of the customers are using Win XP.

I am wondering now if the problem might be referenced to their internal clock settings since part of the function includes "Date()". I am going to check on that possibility.

Any other ideas will be appreciated.

 

[PHV]

What are the references checked in the original MDB ?
When in VBE (Ctrl+G) menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cschnable]

The following references are listed

Visual Basic for Applications
Microsoft Access 10.0 Object Library
Ole Automation
Microsoft ActiveX Data Objects 2.1 Library
Microsoft Office XP Web Components
Sagekey Security
Microsoft Windows Common Controls-2.6.0 (SP4)
Microsoft DAO 3.6 Object Library

 

[PHV]

My guess is that the culprit is here:
Microsoft Windows Common Controls-2.6.0 (SP4)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cschnable]

Should I just remove this reference

Microsoft Windows Common Controls-2.6.0 (SP4)

or replace it with something else

 

[PHV]

Should I just remove this reference
Untick it and if the mdb compiles properly then recreate a mde.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cschnable]

Thanks!
I will give it a try.