[AccessD] code problem

Joe Hecht jmhla at earthlink.net
Sat Nov 27 23:06:39 CST 2004


Thanks John,
	You have a family. What are you doing here on a Sat Night? ; )

JOE HECHT
LOS ANGELES CA 
 jmhla at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Saturday, November 27, 2004 8:57 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] code problem

>    strMsg = "'"& NewData &"'" is not in the list. "

Use:

    strMsg = "'" & NewData & "'" & " is not in the list. "


John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Saturday, November 27, 2004 11:41 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] code problem


I am copying and will attribute the following code from KG et al ADH

 

Private Sub cboEmpName_NotInList(newdata As String, Response As Integer)

Dim strMsg As String

Dim rst As Recordset

Dim db As Database

 

 

    strMsg = "'"& NewData &"'" is not in the list. "

    strMsg = strMsg & "Would you like to add them?"

 

Does any one know why the first strMsg line is evaluating to to red ?

 

Thanks 

 

JOE HECHT

LOS ANGELES CA 

jmhla at earthlink.net

 

-- 
_______________________________________________
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