Charlotte Foust
cfoust at infostatsystems.com
Wed Jun 22 19:26:13 CDT 2005
You need quotes around any path with spaces in it, so both the executable path and the mdb path need to be enclosed in a pair of double quotes each. Charlotte Foust -----Original Message----- From: Joe Hecht [mailto:jmhecht at earthlink.net] Sent: Wednesday, June 22, 2005 5:11 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Good Code Bad Code Question C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE C:\Data\K fernan\62205\PosiChargeFS Programs.mdb /decompile The installation path for access is the MS default. When I run the above I get error message Windows cannot find C:\Program ( Bla Bla Bla) Any thoughts Joe Hecht Los Angeles CA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, June 22, 2005 12:48 PM To: access at joe2.endjunk.com; Access Developers discussion and problem solving Subject: RE: [AccessD] Good Code Bad Code Question To decompile, you start Access with a command line /decompile argument. Any command line argument requires the full path to the executable be in the shortcut or the command line arg is ignoredCharlotte Foust -----Original Message----- From: Joe Hecht [mailto:jmhecht at earthlink.net] Sent: Wednesday, June 22, 2005 11:37 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Good Code Bad Code Question See inline Subject: RE: [AccessD] Good Code Bad Code Question You lost me, Joe. You say it works correctly but you get a compile error? If you get a compile error, it shouldn't work. ^ Yes I agree Have you tried decompile and recompile? ^ I have read posts here but maybe I am thick.(Well I am heavy : )) I do not understand how to decompile and recompile I have to say that in later versions of Access, I've had better luck using the afterupdate of a combo to put a non-value column value into another control. Have you tried that? ^That is where the code is. Charlotte Foust Thanks -----Original Message----- From: Joe Hecht [mailto:jmhecht at earthlink.net] Sent: Wednesday, June 22, 2005 11:01 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Good Code Bad Code Question The following line of code works correctly Me.txtCost.Value = Me.cboPartNum.Column(2) When I try to compile the code I get an error message that .cboPartNum Method or Data member not found. Any Idea what is up? Option Explicit is set Thanks Joe Hecht Los Angeles CA -- 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