[AccessD] TransferText Failling

Worked fine, thanks!
Jim

-----Original Message-----
From: Seth Galitzer [mailto:sgsax at ksu.edu]
Sent: Monday, March 10, 2003 4:27 PM
To: accessd
Subject: RE: [AccessD] TransferText Failling


Jim,

Try putting 
	On Error Resume Next
right before the Kill statement, and then
	On Error GoTo <error handler label>
right after to re-enable your error handler.

As for your formatting, have you tried looking in Help for User-Defined
Number Formats?  If you do, you'll see that the # character will display
a digit or nothing.  What you want to use is the 0 character, which will
display a digit or a zero.  So when you format your text for printing,
you want to use
	Format(<fieldname or string>, "-0000.00")

Hope this helps!  Happy exporting!

Seth

On Mon, 2003-03-10 at 16:12, Hale, Jim wrote:
> Seth,
> I happened to be writing a little routine to dump plan data to a text file
> so the mention of your code was very timely. Thanks! several comments: If
> the file doesn't exist the killfile line gives an error. I added a
filexists
> test. Second 
> "Open strOutfile For Binary As intFileDesc" doesn't seem to work with the
> Print statement. I changed binary to Append and the code works. 
> 
> I need my amount field in the text file formatted as "-####.##" but
-2000.00
> is printed as -2000; 2000.20 is printed as 2000.2, etc. How can this be
> correctly formatted in the print statement?
> Regards,
> Jim Hale
> 

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com