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: *

  • Users: koie
  • Order by date
  1. koie

    Reading CSV file

    [hairpull2] that easy...Looks like time for bed.
  2. koie

    Reading CSV file

    Mission Accomplished!! Thanks guys for all your great input. I am certain that the code below could be rewritten in a neater way but it does what it has to do and that's what counts for me. [smile] There is one big no-no I did and that was an error I encountered on a blank line at the bottom...
  3. koie

    Reading CSV file

    Wonderfull...I am learning a lot here. There are certainly of lot of nice tricks to do. I have been working on the Code TallOne provided and made some progress. Perhaps not the best way to write code but this is what I have so far. Debug.Print .Fields(0).UnderlyingValue, .Fields(1).Value...
  4. koie

    Reading CSV file

    Thanks you all for your responses. It is grately appreciated. I have tried the above examples but still no luck. With the code from TallOne i am getting a "invallid us of NULL" on this line bolStartComponentData = (Left$(.Fields(0).Value, 3) = "VOR") This is were the blank line appears in the...
  5. koie

    Reading CSV file

    I am getting close.... But i just discovered that there are "'s in my file what screws up my output. This is what I have so far: Open inputfile For Input As #1 look_for_sampleid: While Not EOF(1) Line Input #1, tmpstr If Left$(tmpstr, 3) = "VOR" Then tmpArray = Split(tmpstr, ",")...
  6. koie

    Reading CSV file

    Whow...you guys are fast!!. I will give it a try Thanks.
  7. koie

    Reading CSV file

    Hi guys, I am strugling here with a CSV file. The file starts of with a lot of blablabla.. After that is starts of with a line beginning with VOR_ where I want to fetch the second field. After this line it I want to fetch all the fields in this line for about 20 lines. Then it starts over with a...
  8. koie

    Adding hours more than 24

    I have been spending hours on searching the topics on how to display the amount of hours correctly in my reports. Instead of 21:00 + 7:00 = 04:00 I want to display 28:00 or 1 day 4 hrs. I know now that this is a familiar problem in Access but somehow I cannot seem to get it to work. I have in...

Part and Inventory Search

Back
Top