silentwolf's latest activity
-
SVBA Like Operator If strtext Like "AT#*" Or strtext Like "DE#*" Then ' ...
-
SAre you looking for the IBAN position? public Function IbanPos(ByVal TextToCheck As String, Optional ByRef Iban As String) As Long...
-
SAny reason you can't use? If strText Like "Überweisung:AT*DE*" or If strText Like "Überweisung:*AT*DE*" Some example data with the...
-
Ssilentwolf replied to the thread Help with Instr Function.Hi David, thanks yes I was trying that too.. now I have it sorted but I am sure there is a much better way of doing it. Maybe someone...
-
Ssilentwolf replied to the thread Help with Instr Function.Hi Josef, yes I need to get the Iban position :-) just testing your code.. but how can I get reg ex to get this part out as dicriped...
-
Ssilentwolf replied to the thread Help with Instr Function.Hi CJ, the issue is that "Überweisung does continue with Dates so each of them is different and the double dots are at the end of that...
-
Ssilentwolf replied to the thread Help with Instr Function.Thanks Gasman I will do that :-) maybe arnelgp could also let me know what to do if you like to replace some string with blanks with...
-
SHi guys, just wondering if someone could help me with this below function= I like to find words starting with AT followed by any...
-
Ssilentwolf replied to the thread Solved Update one field with another using like operator.Hi Pat, yes I am aware of this but in this case it has nothing to do with relational database. One table only updates one field with a...
-
Ssilentwolf replied to the thread Solved Update one field with another using like operator.Hi there, thanks for the input! I would need to look into that but in my case there a not really alot of data so it is for my need...
-
Ssilentwolf reacted to theDBguy's post in the thread Solved Update one field with another using like operator with
Like.
But it's probably a little bit slow, because the query has to produce a cartesian product first and then filter the result down to the... -
Ssilentwolf replied to the thread Solved Update one field with another using like operator.Hi Doc, thanks will keep that in reference ! Cheer -) But finally was able to get it working again.. buhh
-
Ssilentwolf replied to the thread Solved Update one field with another using like operator.Never mind. Worked it out! strSQL = "UPDATE AUSZUG, UmsatztextTable SET AUSZUG.Umsatztext = [UmsatztextTable].[Umsatztext] " & _...
-
Ssilentwolf replied to the thread Solved Update one field with another using like operator.Hi Pat, thanks for your reply. Well I have data from a CSV File the field names are long or to long. The Field is called "Umsatztext"...
-
SHi guys, I rememer that I had this already found somewhere on the net but seam not be able to find it. I like to Update TableA ...