Export single record from form...

[PronetSolutions]

Hi everyone!
Can anybody help? I'm looking for a way to export the current data displayed within a form to a fixed width text file. Any ideas?

Thanks,
Scott

 

[PHV]

In the VBA help file take a look at Open, Print #, Close.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[PronetSolutions]

Ok, more specifically, using MS Access 2003, I have a table which contains user data records. I have created a form to create new records within the table. After the manager enters the necessary data in the form, I need to find a way for the manager to export only the current record data from the form to a standard fixed width text file. Each record in the table must be exported into individual text files.

I have already created an Export Fixed Width Macro. This function exports data properly except that it exports all records into one file.

Any ideas???

Thanks, Scott