By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,852 Members | 955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,852 IT Pros & Developers. It's quick & easy.

Set Lines Per Page for Space Delimited Text Output of Report

P: n/a
Does anyone know how to create a set number of data lines per page when
creating an Access report that is ultimately being used to export as a
space-delimited text file?

OR, is it possible to set a page break so that the exported
space-delimited text file still contains the page break?

I am trying to take an Access report and COLD (Computer Output to Laser
Disk) process it into a document managment system. The only problem is,
without the page breaks, the processor is reading the whole thing as
one page.

Any help is greatly appreciated!!!

-Heather

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
he**********@gmail.com wrote:
Does anyone know how to create a set number of data lines per page when
creating an Access report that is ultimately being used to export as a
space-delimited text file?

OR, is it possible to set a page break so that the exported
space-delimited text file still contains the page break?

I am trying to take an Access report and COLD (Computer Output to Laser
Disk) process it into a document managment system. The only problem is,
without the page breaks, the processor is reading the whole thing as
one page.

Any help is greatly appreciated!!!

-Heather

If the file is a text file, you could look at Open, Close, Print, Input
in onlone help and their examples. You could then open the file, read
line by line at at a specific counter of the page print an ascii 12 for
a form feed.

You could also use these command to create/write the file out yourself.
Select all the records and then write the line and formfeed where
required.

Nov 13 '05 #2

P: n/a
no idea, but I would check with Stephen Lebans. www.lebans.com

If there's a way to do that, I would check with him first thing.

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.