Rocky Smolin
rockysmolin at bchacc.com
Thu Mar 25 21:23:46 CDT 2010
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