Well I tried the replace method but it seems to not work as intended. Im still finding doublespaces in my descriptions.
I combined everything into one query so that I don't have to run extra queries afterwards to do the description modification...
Woot :)
Thanks stoph. Ure a life saver.
Up to now i've had to use excel to import the tables from access then use the excel trim function. After that I had to reimport into access and go further with it.
What a nub I am.
Hopefully ill get smarter :)
Btw i know this is only my 5th post but...
Hi there.
I have a little problem.
I have a file that I split into little code files each with their own little Code and description. Now whoever the smart one was that is making these codes and descriptions has put double spaces between some descriptions and before and after some others...
Too late :( It was late..........I was hungry......things happen.
If you want to save the kittens then faster replies are needed.
/me opens a fresh can of "little kittens in distress"........."aaaaaaah just as fresh as the day they were produced"
Just an update.
I've finally figured it out.
The problem was that I made two faults when writing this macro and module.
1: the module should have been a function (easily fixed by just renaming the sub to Function)
2: Using openModule was not the right way to go. I should have used RunCode>...
Hi there.
First post \0/
I know i'm a noob and i was wondering if someone can help me perchance with my little module/macro problem.
My problem is that I've got a module that works fine if i manually run it when i'm in it, but when i call that module from a macro then all that happens is that...