Access 2003 Runtime Error - Function is not available in expressions

[esvee]

I encounter the following error when running an Access 2003 MDE application.

"Function is not avaiable in expressions in query expressions".

The VBA functions this error refers to are "InStr" and "Format" which have been used within 2 queries.

The application works fine on the developement PC which has a full version of Access 2003 installed.

The PC in question runs Windows XP, Office 2003 Standard and Access 2003 runtime. I've also installed MDAC 2.8 which is the version the original MDB uses.

Seeing that the PC has only the runtime Access installed, I'm unable to check if there are any references missing.

Even running the following code from within a command button to see which references are missing produces an error.

Dim ref As Reference
Dim strOut As String

For Each ref In Access.References
strOut = strOut & vbCrLf & ref.Name & IIf _(ref.IsBroken, " Missing", "OK ") & vbCrLf & _ ref.FullPath & vbCrLf
Next ref

MsgBox strOut

I get the following error when trying to run this:

"The expression On Click you entered as the event property setting produced the following error: There was a problem referencing a property or method of the object."

Has anyone encountered a similar problem or have any ideas?

Thanks in advance for your assistance.

Steve