[AccessD] Good Code Bad Code Question

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



More information about the AccessD mailing list