Hyperlink field and linked files management

[eugenioca]

Hi there programmers



My name is Eugene and I'm a (not so) access 2003 sp3 power user. In particular my macro and programming skills are poor and rusty. I have created a db with names and info about customers. One of my db tables has a hyperlink field with the link to a customer's pdf curriculum file. All the files are in a directory. There are several hundreds of customers in the db and I have some query to select them.
What I need is a macro or a script that copies the CV of all selected customers in an empty folder. How can I perform this task?

Thanks in advance for every (even little) hint You can hand me

Eugene

[June7]

What is CV? Copy to where?

[eugenioca]

What is CV? Copy to where?

Hi,

CV stands for curriculum vitae (a resume)
I have a set of people and I have a dir full of resumes. I have a query that select people given their age, skills, etc and I need to copy the resumes of selected people from this big basket to an empty folder.

[June7]

Use VBA procedure that loops through recordset object and copies each relevant file.

So how are the resumes named? What field in recordset can be used to match file name?

[eugenioca]

So how are the resumes named? What field in recordset can be used to match file name?

the resumes are named like this: 'surname name.pdf' but I can rename them like this 'codice.pdf' where codice is the key field of the table 'Dati candidato'.
Here U can find an empty copy of the db.

https://drive.google.com/open?id=0B_...nFzVnNpUFJ3RGM

The table to work at is 'Dati candidato'

[June7]

Don't think I want to download db. You should attempt building suggested code and when you encounter specific issue post question. Many examples of code manipulating recordset object as well as how to copy a file. Provide your code for analysis.