Hey experts

Am trying to get a string, then go character by character in the string, find a corresponding number value from a table and find the total. The problem i face is, A and a have different values in the access table but when i query it just returns the first one guess it is not case sensitive. How can i find the difference...

thanks
brat


mono1 = Len(Text1.Text)
cnt1 = 1
While cnt1 < mono1
t2 = Mid(Text1.Text, cnt1, 1)
If t2 <> "*" Then
nbr1 = nbr1 + t2
Text4.Text = t2

Text5.Text = Text4.Text + Text2.Text

If t2 <> " " Then
SQLStr4 = "Select nostch from stchtime where monostch = " + "'" + Text5.Text + "'"

Set dn = OpenDatabase(App.Path & "\sriram.mdb")
Set RecSet4 = dn.OpenRecordset(SQLStr4)
stchind = (RecSet4.Fields(0))

stchtot = stchtot + stchind

End If

Hi pal,

Ur code's a bit confusing... i mean all those variables really confuse some1 who's trying to understand the code for the first time...

A tip: Use DESCRIPTIVE words as variable names...

As for ur query, i think u can use the ASC() function.. The capital letters start from 65 -96, and small leters from 97-whatever...

Hope that solves ur problemo.. Best of luck


Regards

____________________________
lOsT...