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

    Problems with looping?

    Hi All, Need help with the following code. What I am trying to accomplish is to have: Record1 Record2 Record2 Record5 Record9 Record1..etc. With the following code my data is coming out as: Record1 Record2 Record5 Record9 Record2 Record5 Record9 Record1..etc. Any suggestions on how to have...
  2. mayonace

    Need help exporting as fixed width

    THANKS PHV!!! Got lotsa typing to do, but this solves my problem perfectly. Have a nice weekend!
  3. mayonace

    Need help exporting as fixed width

    Hi, The following code is working as I like, only problem is, I cannot seem to have it export to text as fixed width. Any help would be greatly appreciated. Option Compare Database Option Explicit Sub ExportTextFile2() Dim rst As ADODB.Recordset ' Used to open record1 Dim rst2 As...
  4. mayonace

    Export 3 tables into 1 text file

    Hi, I'm sorry if I was not clear in my first post. What I am trying to do is, export data from 3 tables into 1 text file. The tables have a relationship. Recordtype0 ID PName <--this is coming from table 1 Recordtype1 ID Phone Number <--this is coming from table 2 Recordtype1...
  5. mayonace

    Export 3 tables into 1 text file

    Hi, I'm new here. Any advice would be greatly appreciated. I have 3 tables that I have to extract into one text file. The required format is: Recordtype0 ID Name <--this is coming from table 1 Recordtype1 ID Phone Number <--this is coming from table 2 Recordtype1 ID Phone...

Part and Inventory Search

Back
Top