purplesky
04-08-2013, 07:40 PM
Hi,
I have multiple textboxes. Let say I give my users to key in any data in textboxes then I will retrieve them from Ms Access. I have a code to check for blank'checking for every empty textbox.
For Each tb In ActiveSheet.OLEObjects
If TypeName(tb.Object) = "TextBox" Then
If ctl = Empty Then
MsgBox ("Please enter * to retrieve all")
Exit Sub
End If
End If
Next tb get by some website.
my question is if user key in "*" then SQL will select unique from that column, means select all for 1 column.
"AND (PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PROCESS_CLASS)='" & c & "' " & _
"AND (PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PRODUCT_TYPE)='" & d & "' " & _
I have something like this in my excel vba code where c or d = sheets.txtbox.value.
thanks
I have multiple textboxes. Let say I give my users to key in any data in textboxes then I will retrieve them from Ms Access. I have a code to check for blank'checking for every empty textbox.
For Each tb In ActiveSheet.OLEObjects
If TypeName(tb.Object) = "TextBox" Then
If ctl = Empty Then
MsgBox ("Please enter * to retrieve all")
Exit Sub
End If
End If
Next tb get by some website.
my question is if user key in "*" then SQL will select unique from that column, means select all for 1 column.
"AND (PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PROCESS_CLASS)='" & c & "' " & _
"AND (PS_DWH_ADMIN.DWH_WIP_DATA_YEAR.PRODUCT_TYPE)='" & d & "' " & _
I have something like this in my excel vba code where c or d = sheets.txtbox.value.
thanks