OutputText.mdb (intermediate)

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Please consider donating $1 per sample downloaded, find out why here. 

OutputText.mdb
This illustrates a simple way to precisely format data for text output. Assuming the following table:
ID  Field1  Field2         Field3         Field4
1   111     1/2/1999    4.2587        3.5%
2   222     1/3/1999    3.598745    5 %
where Field1 is an integer, Field2 is a Date, Field3 is a Single, and Field4 is a Single formatted as percent, and assuming you want the following output:
1,"000111",#Jan 02, 1999#,4.26,00350
2,"000222",#Jan 03, 1999#,33.60,00500
The code in Module1 will produce the called "Table2.txt" in your "My Documents" folder.
Download
Access 97 (23 KB): uploads/5/OutputText97.zip
Access 2000 (30 KB): uploads/5/OutputText2k.zip

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Roger Carlson Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Microsoft MVP Joined: 20 Feb 2008 Status: Offline Points: 249	Post Options Post Reply Quote Roger Carlson Report Post Thanks(0) Quote Reply Topic: OutputText.mdb (intermediate) Posted: 29 Jul 2008 at 10:50pm
	Please consider donating $1 per sample downloaded, find out why here. OutputText.mdb This illustrates a simple way to precisely format data for text output. Assuming the following table: ID Field1 Field2 Field3 Field4 1 111 1/2/1999 4.2587 3.5% 2 222 1/3/1999 3.598745 5 % where Field1 is an integer, Field2 is a Date, Field3 is a Single, and Field4 is a Single formatted as percent, and assuming you want the following output: 1,"000111",#Jan 02, 1999#,4.26,00350 2,"000222",#Jan 03, 1999#,33.60,00500 The code in Module1 will produce the called "Table2.txt" in your "My Documents" folder. Download Access 97 (23 KB): uploads/5/OutputText97.zip Access 2000 (30 KB): uploads/5/OutputText2k.zip
	Consider donating $1 per sample downloaded, find out why here.<

Sponsored Links