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!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- mayonace
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- mayonace
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- mayonace
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
