Recent content by Disabledg

Next Question. Where can be found Access runtime command line properties? I want to make it auto.

Yeeeees. I found utility.mda for windows xp on internet, copy it to office/1033/utility.mda and UPDATE table1 SET attr1 = replace([attr1 ], chr(10), " ") works!

Yes. The same error. Undefined function left $ in expression. I google it and find some material about utility.mda - in my vb -> tools -> references -> utility.mda is missing. Maby it matter?

Now i try it in access 2016. Left$ not help. From query wizard i see all this functions. Maby it can't be used with old mdb format?

Possible im stupid and do not understand how to use it(. Acess 2016. "undefined function Left in expression".

I try it. Execute UPDATE table1 SET attr1 = replace([attr1 ], chr(10), " ") shows warning "undefined function CHR in expression".

No(. It used by program what understand only old format.

Line break not on all lines. So if i cut data for 2 chars - i broke data :(

Hello! I have old mdb base with invisible line break. After export to excel i got new lines - and it brokes data structure. How can i remove line breaks from datatable? UPDATE table1 SET attr1 = trim(attr1) dont help. UPDATE table1 SET attr1 = replace([attr1 ], chr(10), " ") not working -...