[AccessD] Combo Box Query Fails

Rocky,

My suspicion when "common" items such as these fail is that there is a
missing reference which has nothing to do with these particular  functions
but which just case Access to wobble.

Can he check the Refs to see if there  is a Missing one?

Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, March 19, 2010 11:14 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Combo Box Query Fails

Dear List:

New user of my E-Z-MRP system does not have A2K3 so I sent him the runtime
(Wise/Sagekey).  The program file itself is an mde.

Runs fine on his box.  All other boxes on his network fail when he tries
this combo box that has a query as its row source.  The query uses Left,
Instr, and Chr(10) and that is failing.  

I discovered one difference between his box and the other - he's got Office
2003 Standard (no Access); the box we were testing it where it failed has
Office 97 - Word, Excel, PowerPoint.  

Could that be creating the problem?

MTIA

Rocky