Search results

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 could adjust it a bit so it is a little nicer. Public Function IbanPos(ByVal TextToCheck As String, Optional ByRef Iban As String) As Long Const Pattern As...

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 in my previous post :rolleyes:

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 date. e.g. "ÜBERWEISUNG INTERNET AM 2022-06-30: " others are without ":" "ÜBERWEISUNG INTERNET AM 2022-08-12 AT1245xxxx" and have a different pattern so those...

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 regex ;-) That would be fantastic Cheers

Hi guys, just wondering if someone could help me with this below function= I like to find words starting with AT followed by any digits and the same with DE followed with digits This is what I got so far.. Public Function ReturnZahlung(strText As String) As String If strText Like...

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 temp file. No linked linked tables or no two field with same data in a table.

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 planty of speed. But never know when it comes down to alot of data there is always good to know that there are different ways and perhaps better ones.

Hi Doc, thanks will keep that in reference ! Cheer -) But finally was able to get it working again.. buhh

Never mind. Worked it out! strSQL = "UPDATE AUSZUG, UmsatztextTable SET AUSZUG.Umsatztext = [UmsatztextTable].[Umsatztext] " & _ "WHERE (((AUSZUG.Umsatztext) Like ""*"" & [UmsatztextTable].[Umsatztext] & ""*""));" This does the job :-)

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" Because there are always multiple same names in that table I created a different table where this Text is shortend so. 125 Cr Avenue, Mr. Bill Sorrow AT1245...

Hi 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 , FieldA , with TableB, When TableA FieldA is LIKE TableB, FieldB Sure had it already found but did not need it for a while and Now I am stuck getting errors in...

Hi arnelgp, yes that is what I done now and it works just fine. Cheers Guys :)

@ebs17 just have tested your code but unfortunatelly same thing nothing changed...

Yes I guess so David lol Thanks Gasman !!

I will try that" Thanks Eberhard! Cheers

Hi David, I tried your code but unfortunatelly that does not change it.. Same issue Cheers

Hi, I just checked the "LongText" field for the Data and all went in correctly.. Not exactly sure why it does that but as I mentioned it is not the end of the world so I just need to see which option is best suited. Cheers anyway )

Btw is there now a button somehwere to close the treat or does it stay open?

In my database are no spaces in table names but I am aware of that thanks for pointing it out Eberhard. @Gasman.. it was all performed via vba and no concatinations in a form.. And yes there was also missing a space lol but I tried so many different things got stuck .. Anyway it all works...

Hi guys, could not find proper help from the net and maybe some of you guys know what the issue could be and if there is a way to go about it. Via VBA I am importing CSV Files into my system and for that mater I need a LongText "Memo" field However I am updating that field via code ...