I'm having a textbox in my form. I'm using tc table with field description.
description
-----------
AAA
BBB
CCC
DDD
if i externally insert the field as E.E.E
and then if i add EEE in my textbox it should made a info thro msgbox like 'description already exists'
how to do this..
give some coding..
i've done stripping special character function like this
Public Function strip(ByVal des As String)
Dim strorigFileName As String
Dim intCounter As Integer
Dim arrSpecialChar() As String = {".", ",", "<", ">", ":", "?", """", "/", "{", "[", "}", "]", "`", "~", "!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "_", "-", "+", "=", "|", "", "\"}
strorigFileName = des
intCounter = 0
Do Until intCounter = 29
des = Replace(strorigFileName, arrSpecialChar(intCounter), "")
intCounter = intCounter + 1
strorigFileName = des
Loop
Return strorigFileName
End Function
please do help
Thanks in advance