Pasi12
01-31-2018, 04:35 PM
Hi ,
I have below code that only does search for one item (using FORMS), like to know how can I modify the code to be able to search for multiple values within dB?
thanks, for example I can only search for SSN number but like to search for bdates, home phone etc... separated by ',' "comma.
Pasi.
cn.Open StrConn
Set rs = New ADODB.Recordset
With rs
.ActiveConnection = cn
.Open "select TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,IS_NULLABLE from INFORMATION_SCHEMA.COLUMNS " _
& "where column_name = '" & Me.CMNumber & "' " _
& "order by TABLE_NAME"
I have below code that only does search for one item (using FORMS), like to know how can I modify the code to be able to search for multiple values within dB?
thanks, for example I can only search for SSN number but like to search for bdates, home phone etc... separated by ',' "comma.
Pasi.
cn.Open StrConn
Set rs = New ADODB.Recordset
With rs
.ActiveConnection = cn
.Open "select TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,DATA_TYPE,IS_NULLABLE from INFORMATION_SCHEMA.COLUMNS " _
& "where column_name = '" & Me.CMNumber & "' " _
& "order by TABLE_NAME"