William Hindman
wdhindman at dejpolsystems.com
Thu Mar 25 21:51:17 CDT 2010
...I'd build a set of separate references libraries ...deliver as mdes with the app ...call the applicable library based on their license ...build it once, run forever William -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Thursday, March 25, 2010 10:23 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Combo Box Query Fails > The function that requires Outlook and the function that requires Excel > are > both custom modifications for a specific customer. So they're not run by > anyone else. They obviously have Excel and Outlook because they wanted the > custom mod to my system to automate them. > > Anyone who wants a run-time of the system would not 'see' those two > programs. The command buttons are visible or invisible depending on the > license. So that way I only have to support one version of the system - > everybody's customizations are built in but only visible to them. > > In this case would late binding solve the problem? > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters > Sent: Thursday, March 25, 2010 5:31 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Combo Box Query Fails > > It's too bad when you spend a lot of time on something where someone else > just didn't tell you something. > > However, late binding wouldn't have solved the problem in this case. In > early binding, you have checked the reference during design time. In late > binding, your code effectively checks the reference during run time. But > if > the reference simply isn't installed on the PC, there isn't anything to > bind > to, early or late. > > Dan > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > Sent: Thursday, March 25, 2010 6:41 PM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Combo Box Query Fails > > Problem solved. I sent him a one-form mdb with the same references > checked > as the mde. And in the CBF I used the Left and CHR functions. Sure > enough > it failed, but this time I was able to see the problem. It was missing > the > Outlook library. Although he bought O2K3 Pro and installed it he didn't > tell me he had not installed Outlook. Adding Outlook solved the problem. > > But I think I have to figure out how to do late binding so that this > doesn't > happen again. > > 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 > > -- > 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 >