Use checkboxes to Print/Save multiple hyperlink files

[Bob White]

Hi,
In Access 2007, I have a datasheet form that contains many records. Each record has the following fields: check box, hyperlink, and several other text fields. I would like to be able to select multiple check boxes and automatically print each hyperlink to a printer using Command_button1 and save to a folder using Command_button2.

Is this even possible?

Thanks

[NeoPa]

Yes.

The data is saved in the table so you just need to create a query based on the table with a filter selecting only those checked records. You can print from this query and even copy the results of the query to another table if you require (using another, APPEND, query).

[Bob White]

Ok - here's my demima. I know the steps neccessary to generate a query manually. I also know how to manually generate a filter based on selected (checkbox) records. What I don't know is (#1) how to automate these steps by putting them into code. (#2)How to write code that could print PDF files from a query. #3) How to save the results of a query to a folder.

Thanks,
Bob

[NeoPa]

1. Coding the creation is not necessary as the query can be created once and used whenever. Simply reuse the query you know how to create.
2. I believe more recent versions (2007 & 2010) have facilities built in for handling that, but I'm not familiar with those versions. I expect they are very similar in nature to the third point though.
3. Before you can save results to a file (in a folder) you need to know what format you want to save them in. Simple table data can only be saved within a database. The same data can be exported to one of various different file formats though, and be saved in a file to a folder. I can't help much if I don't know what format you want the data saved in. You can automate (code) exporting to any of the formats that are supported for the manual exports though, to give you an idea of what's available.