Jim Lawrence
accessd at shaw.ca
Mon Jan 21 16:03:19 CST 2013
It does sound like a reference error. I have had that error when working with mixed Office versions. If there is some Windows offset reference missing that may be the error. Some references are positional. Is your client running Access, on Parallel, in an installed version of Windows? Has the client run updates or mixing and matching? Off the top, I would suspect your client has been mixing Office versions? Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Monday, January 21, 2013 12:51 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Error 3075 in app running on a Mac with Parallels Dear List: I have a user of my commercial app, distributed as mde compiled in 2003. Runs fine under windows. This client is running on a Mac using parallels, and gets an error 3075 - Function is not available in expressions in query expression 'left(OrderNumber,7) = '2013501' where '2013501' is an order number and its a filter that's being created. He's running Access 2010. Looks like a broken reference but, of course, it runs fine here on my 2010 test bed. Any ideas? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com