Printing several word documents from within a form

daytona89

New member
Local time
Today, 02:49
Joined
Jun 24, 2009
Messages
2
Hi.

I am trying to create a database to track students' missing assignments (word documents stored in c:\data). I want to be able to select the assignments they're missing, then print them from within Access. (eventually, with a cover sheet that briefly explains each assignment).

So far, I've found two useful scripts (one to list files from a given directory in a dropdown box, and one to print a specified word document. What I don't know is how to link these two functions together (or how to select a series of word documents to print at the same time. Ideally, I'd like to have a list of the files in the directory, each with a checkmark beside it, so that I can check off the required files and then just hit a "print" button.

Can anyone give me a hint in the right direction? Thanks for any information you can provide.
 
Logic states that you need to employ both scripts with a little bit of tweeking. First change the combo box to a list box. This enables you make the list multi select. Next when you hit the print button your code will go though all the selected items in the listbox and run the script to print the selected report by way of a For Each varItem Selected


David
 

Users who are viewing this thread

Back
Top Bottom