Charlotte Foust
cfoust at infostatsystems.com
Wed Jun 22 14:48:18 CDT 2005
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 ignored. Then if you open a database, it will decompile. The recompile is just going to the VBE and using Debug-->Compile, but do this after closing the Access session and restarting normally, without the /decompile switch. If you hover the mouse over Me.cboPartNum.Column(2) in the code, what do you see in the tooltip? And for that matter, how many columns does cboPartNum have? Column numbering in the collection starts at zero, so Me.cboPartNum.Column(2) refers to the third column in the combobox. Charlotte 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