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 >