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 Chriss Miller 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: Henc
  • Order by date
  1. Henc

    Parsing CSV file

    Hello, I have a strange CSV file which I am trying to parse using the code below. However, it only works on one line files. The file I really want to parse is 8 to 10Mb. The reason behind this is that there are instances in which a quotation mark is used to denote inches and the text...
  2. Henc

    parsing a csv file

    Stickarm, your reply is noted, but I guess I forgot to also include that the csv file has the text delimited by double quotes. Ex: 200,10,"Asphalt(10" deep)",20,50 Therefore, Access sees this as being seperate fields and then doesn't know what to do with the leftovers...
  3. Henc

    parsing a csv file

    Hello, I would like to parse a csv file before I import it into a table. The file is in csv format with one problem: Certain snippets of text also contain a double-quote character to denote inches. When I import this as a table, I get a bunch of import errors which I then go through manualy...
  4. Henc

    Continuous Form Focus

    I have sorted it by one field, so when I speak of the "top" record, I meant the first one. I think it has something to do with bookmarks. Do I need to somehow reset the bookmark to the first record? If so, how do I accomplish that? Henc
  5. Henc

    Continuous Form Focus

    Thanks fo the response, I have a form that has a recalc button which recalcs a subform based on a combo box on the main form. The subform looks similar to a datasheet, but I used text boxes so that I can lock some values and have others be updatable. I select a value in the main form's combo...
  6. Henc

    Continuous Form Focus

    How do you set the focus to the top entry in a continuous subform? If I edit values in the subform anywhere below the first line, and then recalc the values and requery the subform, I end up at the line that I left off with, but I want to end up back at the very top. Is there a way to do this...

Part and Inventory Search

Back
Top