Tony Septav
TSeptav at Uniserve.com
Mon Jan 7 10:55:47 CST 2013
Thanks Steve It is running on the client's machine as an Access 2003 runtime. I think if I remember correctly I ran into a similiar problem a couple of months ago when I tried running an old application on my machine and a got a similar message, the message was misleading as the solution had nothing to do with the error message displayed but with Windows 7. Anyway the client is dropping off his laptop today, so I guess it is time to do a "Sherlock Holmes" and try and figure out what is going on. Jeez I hate having to deal with "mystery meat". Tony Septav Nanaimo, BC Canada -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel Sent: January-07-13 3:31 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] ACCESS2003 Function is not Expression Tony So is it running on the client's machine under Access 2010, or Access 2003 Runtime? I have an application that I develop in Access 2003, but runs on my server under Access 2010. I ran into similar sort of problem, which I never properly got to the bottom of. The only way I have found around it is to put it on the Access 2010 machine as an MDB, and then save as MDE there... in which case it works fine. (Of course, this is relatively easy for me because it's my own computer, and would be a pain to do on a customer's system unless you have remote access or something.) Regards Steve -----Original Message----- From: Tony Septav Sent: Saturday, January 05, 2013 10:08 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] ACCESS2003 Function is not Expression It is a standalone alone install app, the client I think has Access2010. I have run into some funky things with Windows 7 and Access code. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: January-04-13 2:57 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] ACCESS2003 Function is not Expression Same Office version as well? On 4 Jan 2013 at 14:10, Tony Septav wrote: > Hey All > > I have an app (mde file) that works fine on my machine but creates an error > on the clients machine. We are both running Windows 7. It is a simple query > > . > > Field: First Char:Left([KeyWord],1) > > > > Seems to me that there is a reference missing somewhere, as it is an mde I > cannot get the client to check for missing references. Any suggestions????? > > > > Thanks > > Tony Septav > > > > -- > 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 -- 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