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.
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.