I have a simple SQL statement as:
strSQL = "SELECT SSN, LName_only(Full_name) AS LNAME FROM EMPLOYEES" .
oConn.Execute strSQL
Using VB6, ADO, Access97 MDB data.
Everything works fine, except my UDF LName_only() is UNDEFINED during runtime.
I have tried putting the UDF EVERYWHERE I could think of.
( The UDF merely grabs the first part of a name string up to the comma. )
I must be missing something really basic. Any ideas ?
Thanks much,
Steve H
Steve H