Opening/creating external text files from Access

S

S.M.

I'm making a fairly simple customer database for my business using Access and
was looking for a way to open an external file related to the current
customer record. I want to use this external file simply for jotting down any
notes I may want to add to a particular customer. I've tried to find a way to
do this, but have come up empty so far. Does anyone have any suggestions?
 
D

Douglas J Steele

Dim intFile As Integer
Dim strFile As String

strFile = "C:\...." ' full path to file

intFile = FreeFile()
Open strFile For Output As #intFile
Print #intFile, "This is the first line of output"
Print #intFile, "This is the second line of output"
Close #intFile
 
Top