Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. koengi01

    Replace commas and points in a field

    Sorry, I mistyped. And how do I do this??? I also tried to take a look at the Replace() function but in my helpfile (Acc 2000) there is nothing in it Thx Koen
  2. koengi01

    Replace commas and points in a field

    Hi Lupins46, Thx for your answer If I run this as an update query, the value 6.14 is updated to 614 instead of 6,14. I'm I doning something wrong? Regards Koen
  3. koengi01

    Replace commas and points in a field

    Hello, I have a Access db, in which I import a textfield. The Field Value contains the value eg. 10,800.00. I want to replace this after importing the file in 10800.00 Can anyone help me with this. At the moment I'm using manually find and replace. Rgards
  4. koengi01

    script performing certain actions

    Thx Wolluf got it running and working!!!! regards, Koen
  5. koengi01

    script performing certain actions

    Thx Wolluf, The import is running by a macro, so that's not a problem. Do you have any examples about this? regards Koen
  6. koengi01

    script performing certain actions

    Hello, Can anyone tell me if it's possible to make a script that opens a database, import a textfile, zip the textfile, move the zipfile to a directory and than delete the textfile. The textfile,zipfile, database and directory names are always the same. I want to click on the script so that...
  7. koengi01

    Cognos Transformer error TR0109

    Macintosh, Ok, but please tell me how 2 do it. The easy part is dividing one table into 2 tables. But how do I setup Impromptu???? regards Koengi
  8. koengi01

    Cognos Transformer error TR0109

    Thx for your reply. A bit strange cause 2 weeks ago I created one of 129.000 rec's from Access. If I split it into 2 tables, can I still create one cube???? Regards Koengi
  9. koengi01

    Cognos Transformer error TR0109

    Hello, When I run a cube I'll recieve the error TR0109 "Couldn't read source date" I'm using a iqd file and an Access table. When I run the cube with 100.000 records, there's no problem, if I run it with more records, this error message appears. Anyone got an idea?? Thx Koengi

Part and Inventory Search

Back
Top