Format error

[CD Tom]

I have an option in my application that the user can export their master file to an excel spread sheet, Again this works fine on most machines but on a vista machine the user gets an error message “Functions is not available in expressions in query expression ‘Format ([Birthday], “mmm”)’.” but this only happens in a compiled version of the program .mde. Any answers
Thanks for all your help.

[ChipR]

Can you check on the problem machine for missing references?

[CD Tom]

When I run it program in an uncompiled mode ,mdb on a Vista machine it works fine but when I compile it and create the .mde and run it on the same Vista machine I get the error. Is there a way to check references in a compiled .mde program.

[ChipR]

The references will be specific to the machine rather than the version of the program because they refer to what DLLs are found on the system. If there are any missing references, you can see them on the target machine in the .mdb under VBA Editor Tools -> References.

[CD Tom]

Yes I know where to look for the references, but the problem machine is in a different state and doesn't have the .mdb program only the .mde so is there a way to find out what reference is missing. The end user only has MS Access runtime.

[ChipR]

It does sound like a reference problem, but it seems difficult to determine with just the runtime version. Maybe you can use this code:
Modules: References Wizard
I found the link to that on Access Reference Problems.

[CD Tom]

OK, I've found the problem and have got it fixed. Thanks for you help your advise lead me to find and fix the problem. Thanks again

[ChipR]

What was it, if you don't mind sharing?

[NeoPa]

I would guess that it's that the double-quotes (") used within a SQL string are not valid in SQL-92 compliant SQL. SQL expects single-quotes (') for strings and later versions of Access default to enforcing these standards more (I expect in an MDE but not necessarily in an MDB).

Although Tom doesn't mention where the code is found, I suspect it must be in a SQL object (including QueryDefs; Forms; Reports; etc).

[CD Tom]

The problem turned out to be a different mousewheel.dll I had two different versions, when I put the newer version on my machine that was giving the error it fixed it. The way I happened to find it, I was looking at the different .dll's and found that the mousewheel one had different dates. I don't know why that would have given me the function error.