Opening/importing resumes in Word based on Access query

[Guest]

Resumes are in Word with a corresponding MS Access data base containing key
words and terms from the resume. After MS Access query selects the resumes
(the reference code to the resume) to be reviewed how can these resumes be
opened/imported/copied to a separate file so that they can be reviewed
further.
Thanks
Jack Miller

 

[pietlinden]

Resumes are in Word with a corresponding MS Access data base containing key
words and terms from the resume. After MS Access query selects the resumes
(the reference code to the resume) to be reviewed how can these resumes be
opened/imported/copied to a separate file so that they can be reviewed
further.
Thanks
Jack Miller

why not just store the path to the file (see the FileOpenSave API at
www.mvps.org/api It's the first article.

then you could just click on the hyperlink to read the resume. Just
don't use an OLE field. Your database will bloat very quickly.