copy files to folder from search results.

[Guest]

Hi,

I created a form that allows me to search for files in 130 countries. When
the user select the country from the drop down combo box the file links show
and when I click on the link it opens the file in PDF format. That I know
how to do but I want the users to be able to select the files using a check
box for each of the search result and create a button that when I click on
the button, it will ask me where I would like to copy and paste the selected
files to? Let say for example I have search result for three files that i
would like to copy and past into a folder. I want to select the three files
links using check buttons and click on a button to copy and paste the file in
a folder that I created or will create. Is this possible at all in Access?

 

[Tom van Stiphout]

On Mon, 19 Nov 2007 14:21:35 -0800, E-mail report using Lotus Notes
rather t <[email protected]>
wrote:

Yes. I have done this many times as follows:
Create new table tblSelected with
PKValue longint PK
Selected yesno default=no

When user selects a country, first delete all records from
tblSelected, then copy all PK values to tblSelected.

Set the subform's recordsource to the join of tblCountryFiles with
tblSelected. Add a checkbox and bind to the Selected field. Now the
user can click on Selected checkboxes.
THen when user clicks the CopyFiles button, you can easily find out
which files have been selected (recordset), and copy them in a loop.

-Tom.