John W. Colby
jwcolby at colbyconsulting.com
Sat Nov 27 23:14:23 CST 2004
Shopping for a laptop for my wife. 8~)
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: Sunday, November 28, 2004 12:07 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] code problem
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
--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com