By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

Format error

100+
P: 443
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.
Feb 9 '09 #1
Share this Question
Share on Google+
9 Replies


Expert 100+
P: 1,287
Can you check on the problem machine for missing references?
Feb 9 '09 #2

100+
P: 443
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.
Feb 9 '09 #3

Expert 100+
P: 1,287
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.
Feb 9 '09 #4

100+
P: 443
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.
Feb 9 '09 #5

Expert 100+
P: 1,287
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.
Feb 9 '09 #6

100+
P: 443
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
Feb 9 '09 #7

Expert 100+
P: 1,287
What was it, if you don't mind sharing?
Feb 9 '09 #8

NeoPa
Expert Mod 15k+
P: 31,418
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).
Feb 17 '09 #9

100+
P: 443
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.
Feb 17 '09 #10

Post your reply

Sign in to post your reply or Sign up for a free account.