Okay, I give up!!!

[Bill]

Where's the counter operation/method to
Line Input #filenumber, varname ??
VBA gives a compiler error with a statement
like: "Line Output #filenumber, varname"

Thanks,
Bill

 

[Dirk Goldgar]

Where's the counter operation/method to
Line Input #filenumber, varname ??
VBA gives a compiler error with a statement
like: "Line Output #filenumber, varname"

Print #filenumber, varname

 

[Minton M]

Where's the counter operation/method to
Line Input #filenumber, varname ??
VBA gives a compiler error with a statement
like: "Line Output #filenumber, varname"

Thanks,
Bill

I use Print to write to files, eg...

i = FreeFile()
Open GetLogFileName For Append As i
Print #i, Now() & ": Something"
Close #i

Is this what you were looking for?

 

[Bill]

PERFECT!
Thanks,
Bill

Print #filenumber, varname

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Bill]

Just changed the "Line Output #2, varname" to
"Print #2, varname" and everything went as
desired.
Thanks,
Bill

 

[Minton M]

Just changed the "Line Output #2, varname" to
"Print #2, varname" and everything went as
desired.
Thanks,
Bill

You're welcome, have a great New Year.

 

[boblarson]

If you ever want double quotes encapsulating text field data you can also use

Write #1, WhateverHere

Write will include double quote text delimiter and Print excludes it.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[Douglas J. Steele]

You shouldn't hard-code the file number: you can never be sure what else is
running and is using the file handle you hard-coded.

Instead, use the FreeFile function to assign a file number for you, like
Minton did in his example.