opening word docs from filemaker

[mlennox]

Hi there,

I work for a recruitment company and we have a database of around 3000 candidates. Currently, when a candidate is registered on to the database, a registration number is generated. This corresponds to a MS word file with CV documents named the same.

My question is; Is it possible to have a button on the database (each individual record) which, when pressed would open up a word document? If so, how could it be possible for this button to open up the corresponding CV?

Any help would really be appreciated.

Thanks in advance.

Mark

[stuj1026]

When you name the word doc what is your naming convention and how does this tie in with your reg# from fm? What is a cv document..

We do something very similar here at our company but I need to know the above info to help. We have become a 90% paperless office.

Stu

[mborgens]

I'll put any naming convention on the Word document, or better yet, Adobe Acrobat file that will allow you to open the file from within FM.

mb

[mlennox]

The reg number in our candidate database is for example: 00564 and would represent the 564th record on our database. The person's CV / resume would be saved in a file on microsoft word and would be 00564.doc.

How is it possible to click a button on the candidate record and get it to fire up the corresponding word doc?

Thanks for any help in advance.

[stuj1026]

Use the open url script step

OpenURL("c:path_to_item"&record number&".doc")

the record number is a field with the registration number

the path to the item is where on the hard drive the information is stored.

Stu

[Kundinger]

Hello 'mlennox',

I recently 'posted' a reply to another 'post' about how to 'open' MS Word documents from within FileMaker. In my 'reply post', I discuss how to store the MS Word files; how to 'reference' the MS Word files within FileMaker; and how to 'get' FileMaker to 'open' these MS Word files. Although my discussion relates to the legal industry, I think that it will have some ideas that could benefit you.

You can find my 'reply post' at the bottom of:

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB16&Number=41309

Good Luck!

Bob Kundinger

[stuj1026]

by the way bob.... The info you had posted was a great help to us.. Thanks for all your detailed input... it was put to good use. Sorry for the delay

Stuj