[AccessD] ACCESS2003 Function is not Expression

Hi Tony

To relief your frustration, you just have to realize that your frontend is
not a program; Access is the program, your frontend is data.
The Program Files folders are not to be tampered with by non-admin users.
Use the ProgramData folder.

/gustav


-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Tony Septav
Sendt: 9. januar 2013 00:51
Til: 'Access Developers discussion and problem solving'
Emne: [AccessD] ACCESS2003 Function is not Expression

Thanks to all who have responded

It is a simple 

Variable response in a field in the Query Grid

eg - Something: left([Field],1)

 

I have tried the same thing using many different tables. Each query when run
generates the same error message on the client's machine (not mine).  As
mentioned I have his laptop so I can try different scenarios.

As many of you have mentioned (myself included) I have seen this before, but
thinking at the time I would never forget what caused the message I never
wrote it down. 

I do not want any cheese with my "Whine", but Windows 7 security has caused
me endless grief in my coding.  The latest being, on my install I put the
front end in a subfolder in the Program Files (or (x86) )folder, when the
program tried to do a "repair and compact on exit" a message would appear
telling me something like I did  not have ADMIN rights to do this. 

So I had to change my install location for the front end. 

 

This is "mystery meat" and I either solve it or rewrite it to come at it
from a different direction. Ask me if I am frustrated.

 

Thanks Again