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

    Automating Improting .csv file into access table

    Hi All, I'm trying to write a program for importing multiple csv files into access table. All my csv files have the same headers and record layout.I have to import it and append into one big access table.. I have never done this before or write vb program extensively. Can somebody please point...
  2. johndoe12345

    Parse the last two character

    I apreaciate your help !! Thank you
  3. johndoe12345

    Parse the last two character

    Hi, I am new with access. I need help to parse out last two characters from the right. Sample Data as follow: Toronto ON <-- 1 field Manitoba AB <--- 1 field VAncouver BC <--- 1 field I need to make it two fields Thanks.... John
  4. johndoe12345

    Hi All, I'm trying to create a c

    Thanks all for your help
  5. johndoe12345

    Hi All, I'm trying to create a c

    Baltman, It's almost there but I want to reset the counter to 0 and and still counting when unique_id <> unique_id GO top thisid=Unique_id do while not eof() SCAN IF thisid=unique_id varpage=1 else varpage=0 ENDIF REPLACE counter with varpage varpage=varpage+1 endscan enddo this is from...
  6. johndoe12345

    Hi All, I'm trying to create a c

    Stella, Yes saperately and I want to keep the numbers on the table and it's group by unique_id
  7. johndoe12345

    Hi All, I'm trying to create a c

    Sorry, I'm trying to create a counter on field called page based on stream and another unique id which is Final_mail Name ADD POSTAL STREAM PAGE Unique_ID Johndoe 123 Avenue L1L 2L2 2 1 20 Johndoe 123 Avenue L1L 2L2 2 2...
  8. johndoe12345

    Hi All, I'm trying to create a c

    Hi All, I'm trying to create a counter based on page n of m. Here are the example of the data. Name ADD POSTAL_CODE STREAM PAGE Johndoe 123 Avenue L1L 2L2 2 1 Johndoe 123 Avenue L1L 2L2 2 2 JaneSmith 999 Avenue M1M 2P2 3 1 JaneSmith 999 Avenue...

Part and Inventory Search

Back
Top