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

Priting all files in a Directory

P: n/a
I have a code that checks a directory to see if it exists, and then if
it does not, the code creates the directory and allows the user to
add/view files in the directory. Weekly I print a report containing a
copy of each record entered during that week (we are still no paperless
here) and I have to manually select the files and print them as well.
I have seen a code for Access to pick all the files in a directory, but
after that is there a way to send the print command to Windows to make
it print all the files in the directory?

Alternately, the formats of these files will either be jpgs, excel
sheets, or pdf files. Can they be displayed in the report and printed
out there?

Thanks in advance!
Mink

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


P: n/a
Mink wrote:
I have a code that checks a directory to see if it exists, and then if
it does not, the code creates the directory and allows the user to
add/view files in the directory. Weekly I print a report containing a
copy of each record entered during that week (we are still no paperless
here) and I have to manually select the files and print them as well.
I have seen a code for Access to pick all the files in a directory, but
after that is there a way to send the print command to Windows to make
it print all the files in the directory?

Alternately, the formats of these files will either be jpgs, excel
sheets, or pdf files. Can they be displayed in the report and printed
out there?

Thanks in advance!
Mink


Check out DIR() in help to see how to get file names in a folder.

I entered
Type C:\Test.Txt >Prn
to print the text file from Dos.

Maybe with Shell you can execute that command to print Txt files. I
doubt this would work with Jpegs or PDFs.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.