Gary Kjos
garykjos at gmail.com
Wed Jan 9 13:57:22 CST 2013
Hi Tony, Have you checked for missing references on your client's PC? Sometimes it's a matter of changing the sequence of the references. Here are some links that show how to check references that may be applicable. http://www.access-diva.com/d5.html http://allenbrowne.com/ser-38.html http://www.pcreview.co.uk/forums/undefined-function-date-expression-t1171993.html http://www.wiredbox.net/forum/Thread486297_Undefined_function_Date_in_expression.aspx http://www.anysitesupport.com/access-undefined-function-right-in-expression/ GK On Tue, Jan 8, 2013 at 5:50 PM, Tony Septav <TSeptav at uniserve.com> wrote: > 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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Gary Kjos garykjos at gmail.com