Search results for query: *

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

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

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

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

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

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