[AccessD] Combo Box Query Fails

Charlotte Foust cfoust at infostatsystems.com
Mon Mar 22 13:07:56 CDT 2010


If you have a reference to an office app like that, it has to be there or you'll get the failure you see.  You could write checks into your code to disable the Excel features if it isn't found but that's undoubtedly your issue.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, March 22, 2010 9:33 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Combo Box Query Fails

Yeah, pointing to the Launch exe.

He got another error that is common with a missing reference...and I think I
just figured it out - there's a reference to Excel 11 in the app - the
runtime isn't going to install Excel on a system where there's no Excel, is
it?  And if it's Excel 97 that reference may not resolve. 

Seem likely?

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Monday, March 22, 2010 8:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Combo Box Query Fails

Make sure whatever shortcut they're using points to the correct runtime
executable, which IIRC is NOT Access.exe.  You can get problems unless you
point to the Sagekey exe.

Charlotte Foust

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

Can't check the refs because it's an mde.  But there should be no ref
problem with the Wise/Sagekey install.  At least I've never had one before
with any mde.

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Friday, March 19, 2010 4:39 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

 


--
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




More information about the AccessD mailing list