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

    Parsing A Text Doc

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

    Numbering Records

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

    Show a Table Name in a Report

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

    Splitting Addresses

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

    Parse a non delimited text file

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

    referring to .txt file

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

    Parsing Text File

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

    Parsing Text File

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

Part and Inventory Search

Back
Top