Priting all files in a Directory

[Mink]

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

[Salad]

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.