Recent content by silentwolf

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 ...