Search results

  1. A

    Trim like an excel mofo

    " " is a doublespace which is converted to " " a single space. Am I getting it wrong somehow?
  2. A

    Trim like an excel mofo

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

    Trim like an excel mofo

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

    Trim like an excel mofo

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

    Get module to run from macro and not just open the editor.

    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"
  6. A

    Get module to run from macro and not just open the editor.

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

    Get module to run from macro and not just open the editor.

    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...
Back
Top Bottom