S
Senexis
Hello,
I have an import question concerning .prn files. We have a program that
prints out management notices and forms which has been printing out a copious
amount of unwanted management notices recently, so we’ve opted to engage the
“print to file†option appending to a single file. This then forces us to
have to sift through this huge file and cut out the documents that we wanted
printed and then we do a DOS command to print out the selected documents.
What I would like to do is import in this .prn file and provide the user
with an interface to see a shortened listing of all of the documents in the
file and then select those documents, export out a .prn file and then execute
a batch file that will print out said .prn file seamless to the user. This
can be done if I could isolate out each appended page in the .prn file into a
record. The only problem that I see with this is that with a standard
import, Access imports horizontally in columns by either delimited or fixed
width criteria. What I need to be able to do is import vertically somehow by
either keying in on some standard syntax that begins on each new document
image “!R!†or the fixed width between each new appended document to the .prn
file. If this can be done and each document be input into a memo type
record, I can isolate out what kind of document it is for the user and do the
rest myself. Is this possible, if anything it will probably have to be a VB
solution…
And yes I am aware that there are programs out there that do what I’m
looking to do with .prn files, but it takes possibly years for any software
to be approved for my network, which is why if I can find an Access 2007
solution, that would make my life and everyone else’s a whole heck of a lot
easier! Lol
Thank you,
-Sen.
I have an import question concerning .prn files. We have a program that
prints out management notices and forms which has been printing out a copious
amount of unwanted management notices recently, so we’ve opted to engage the
“print to file†option appending to a single file. This then forces us to
have to sift through this huge file and cut out the documents that we wanted
printed and then we do a DOS command to print out the selected documents.
What I would like to do is import in this .prn file and provide the user
with an interface to see a shortened listing of all of the documents in the
file and then select those documents, export out a .prn file and then execute
a batch file that will print out said .prn file seamless to the user. This
can be done if I could isolate out each appended page in the .prn file into a
record. The only problem that I see with this is that with a standard
import, Access imports horizontally in columns by either delimited or fixed
width criteria. What I need to be able to do is import vertically somehow by
either keying in on some standard syntax that begins on each new document
image “!R!†or the fixed width between each new appended document to the .prn
file. If this can be done and each document be input into a memo type
record, I can isolate out what kind of document it is for the user and do the
rest myself. Is this possible, if anything it will probably have to be a VB
solution…
And yes I am aware that there are programs out there that do what I’m
looking to do with .prn files, but it takes possibly years for any software
to be approved for my network, which is why if I can find an Access 2007
solution, that would make my life and everyone else’s a whole heck of a lot
easier! Lol
Thank you,
-Sen.