Runtime - Function Not Available In Expressions

Question

I have a database partially created in 2002 and then upgraded and developed in 2010. It is working as a BE connected to tables in the FE. The setup works very well as an accde in a recently downloaded 2010 Runtime version.

I installed the configuration on a client computer also using a recently download of 2010 Runtime. I now get this message relating to a number of separate date calculations.

Function is not available in expressions in query expression.

The various problem calculations relate to these date parameters and include:

Format([VolunteerDate],”yyyy”)

IIf([VolunteerDate]< (Date()-[InactivityPeriod]),”Inactive”,”Active”)

DateValue(Format([VolBirthdate],”mm-dd”)

I can't figure out why would it run on one computer with 2010 Runtime and then not on another with the same 2010 Runtime.

Any help solving this would be greatly appreciated. Everything else in the database works as it should.

Thanks.

Answer 1

Testing on your machine wouldn't necessarily prove anything since your machine has the libraries and the Runtime should pull those in as needed.

One thing you can do to check references is to add a form to your database that checks them. I'll be happy to send you a sample DB if you conact me through my website, www.thatlldoit.com. I don't like putting my email address in forum posts.

Answer 2

One thought on this problem. Would it be of any benefit to save the db's including the Runtime into an installation package?

I am not sure if the right library would go with the package. I am also not sure if I can package a FE and BE together with that utllity.

Thanks.

Answer 3

Thanks again, I'll make contact.

One other note, the Runtime I use is on a machine separate from my development machine.

Answer 4

Thank you for the information. I checked with the client; their Runtime version is the same as the version I use for testing (which works OK).

I looked at the References in my Access 2010. The only older versions of what is being used would be for ActiveX.

Answer 5

Built-in functions that fail are usually due to missing libraries in the code's references. Maybe the runtime does not have the same versions as your computer has.

Using your computer, go into th ereferences and select the oldest version of all the ones you are using. Then create a new accde to see if that fixes it.

If no older versions are available check to see if the runtilme version numbers are the same on both computers. The problem one might need an update.