Exporting to text file with variable name 1

[cobweb]

Hi Guys:
I am wanting to export an access table to a fixed length text file; but he file must have a name that refers to the contents of the table.
The first 8 characters can be fixed - say 99999999; but the 3 characters after the full stop must be the last 3 characters of the field "Orders" in the table exporting to file.

I could tell you what I have tried; but you would just laugh.

Thanks in anticipation!

 

[dbelsey]

How 'bout this:

Private Sub cmdExportToTextFile_Click()
'NOTE: This is attached to a command button
Dim strFileName as String

...

strFileName = "99999999" & Right(CStr([Orders]), 3)
Open strFileName for Output as #1

...

End Sub

That's pretty rough and answers only the file naming question. Yell if you need more....