Creating and opening text files

[dporrelli]

I've been using a memo field for data entry in the form, but the amount of data is maxing out the field and getting the usual #error. I've decided the best option is to have a embeded txt document that is linked to that record. OK, tried a few things and nothing worked. Here is what I'm trying to do:
Firstly, write a bit of code which will take the customer name field from the database then create \\servername\database\'customer name', then create a text file inside that dir called history.This is something I would like to run once to create the dirs/files for all the records currently in the database.
From here I want either to have that file embeded into the form and it open the correct file on the form with each record or else have a icon for them to click which will open the coresponding txt file.
I would also like it to create the dir and txt file whenever a new record is created.
Not asking for much eh?

Thanks

 

[Remou]

Have a look at MkDir, Open Statement, FileSystemObject TextStream, and FollowHyperlink. I think that should do it.

 

[missinglinq]

I have to wonder at the design of your db. With a memofield holding better than 65,000 charatcters, at a font size of 10 you're talking about 14-15 pages, single-spaced, of text, or about 12,000 words! What exactly are you using this memofield for?

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!