Charlotte Foust
cfoust at infostatsystems.com
Wed Jun 22 14:57:12 CDT 2005
Joe, To decompile, use a command line argument in opening the database. That means you have to fully reference the path of the Access executable and the full path of the target database or the /decompile switch will be ignored. After you open the Access database that way, close the Access session, then reopen the database normally without the decompile switch, go to the VBE and use Debug-->Compile... To recompile the app. This clears out some crud that may otherwise cause you grief. There was a suggestion about using a bang instead of a dot in Me.cboPartNum.Column(2) and I encourage you to try that without delay because I have found that there are places and times in Access where you must do so. If that solves the problem, you're ahead of the game. Also make sure that cboPartNum has at least 3 columns specified in its property sheet, since the column numbering is zero based for the collection. 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