Rocky Smolin
rockysmolin at bchacc.com
Mon Jan 21 17:16:29 CST 2013
I originally sent him the run-time version and it had this problem. So he bought Access 2010 and Excel 2010 and installed them a la carte. Same problem. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Monday, January 21, 2013 2:03 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Error 3075 in app running on a Mac with Parallels 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com