Search results for query: *

I'm having alittle trouble getting started. I want to write some code that will go through each line of a text doc and parse out values based on the criteria I program. The tricky part is that the text file is basically a log file so there is no standard format to it. I want to go line by...

I have a table with cutomers/customer numbers like: 123 Customer1 123 Customer1 456 Customer2 456 Customer2 456 Customer3 I need to add a field that counts each customer record so I end up w/ a table like: 123 Customer1 1 123 Customer1 2 456 Customer2 1 456 Customer2 2 456 Customer3 3...

Is there a function that will show the table name that a report is built on? I built a report, and I want to show the source of the info in the header, much like the funtion =today() only I want the name of the table used to build it to be visible........ Any help appreciated!!!! Thanks in...

I'm trying to split an address field into 3 parts- City, State, Zip. The data looks like this---- New York City NY 10025 S. Yarmouth MA 02664 I've been using update queries, but this format is causing a bit of a problem. The conventional Instr, Left, Mid, Len functions will not seem to work...

I have a text file (that I'll paste below) it is address info with no clear delimination(there are commas--but not consistant all the way through) and broken up by admit dates. I'm trying to figure out a way to parse it but not sure where to start. Can anyone with a lot of experience in this...

as a new vba programmer, i'm trying to decipher some code that looks at a text file saved outside of access then runs thru a series of steps that parses it. Here is the first part of the code-- Public Function getitdone2() Dim lFileHandle As Long Dim sFileName As String Dim sLine...

thanks for the reply.... here is some code i found that attempts to do this. but as a non-experienced vba programmer, i not even sure if this is the correct way to do it. and i'm having a little trouble folowing it... Public Function getitdone() Dim lFileHandle As Long Dim sFileName...

I'm struggling to write a procedure that will: import a .txt file into access and then parse the data into fields. the data in the .txt file looks like this-- LAST NAME: Smith FIRST NAME: PAUL MIDDLE NAME: JOSEPH ADDRESS 1: 318 Palisade Avenue ADDRESS 2: CITY...