[AccessD] Combo Box Query Fails

William Hindman wdhindman at dejpolsystems.com
Sat Mar 20 20:41:13 CDT 2010


...have their A2k3 runtimes been updated to the latest version?

William

--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Saturday, March 20, 2010 8:38 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Combo Box Query Fails

> Here's a communication from the client and my questions:
>
> **************************************************
> Hi Rocky,
>
> I installed the new 2319 file on my wife's Sony VAIO and it works fine.
> *** Was E-Z-MRP connected to the back end on your server or running 
> locally
> on her machine?
>
> It also works fine on my Sony VAIO.
> *** Was E-Z-MRP connected to the back end on your server or running 
> locally
> on your machine?
>
> Both computers run XP as well as Office 2003 (without Access and Outlook).
> Based on this it seemed reasonable to assume that the lack of Office 2003
> was the problem.
> *** I think getting Office 2003 with Access will be the ultimate solution.
>
> I also installed the new 2319 you sent on another computer and still had
> the problem.
> *** Did this other computer have Office 97 installed?
> *** On this other computer was E-Z-MRP connected to the back end on your
> server or running locally on this machine?
>
> I then installed Office 2003 on said computer but the problem persisted.
> *** Was Office 97 also installed?  If so try uninstalling both versions of
> Office and E-Z-MRP and reinstalling Office 2003 and then E-Z-MRP.
>
> I started thinking that maybe Windows 7 on the server was the problem.
> *** I don't think that the OS on the server is relevant. The mdb on the
> server is being read by Access in the client machine.
>
> I then installed the TSi company file on the old server--still had the 
> same
> problem.
> *** Again, the server is not the problem.  I think we checked that out by
> running the back end locally on one of the machines with Office 97 and
> generated the error.
>
> The error message is now random
> *** Random how?  Does it work sometimes and not other times?  Or are you
> getting different errors?
>
> --when I click on the arrow I don't see any address information except on
> the two VAIOS. This is REALLY STRANGE. HELP!!!!
> *** But consistent.  I have never encountered this problem before at a
> client site and am polling my forum for clues.
>
> Again, I think the ultimate answer will be to upgrade all the clients to
> Office 2003.
> **************************************************
>
> Any clues there?
>
> MTIA
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Saturday, March 20, 2010 5:03 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Combo Box Query Fails
>
> No deal.
>
> I can't roll this app back to 97.  Too many differences.  I'm urging him 
> to
> get Office 2003 w/Access.
>
> Rocky
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Saturday, March 20, 2010 2:06 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Combo Box Query Fails
>
> Ok, but I still think it is one of the  references.  Different versions
> perhaps.
>
> Can you provide a 97 version for the other boxes?
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Saturday, March 20, 2010 1:16 AM
> 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
>
> -- 
> 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