Hyperlink field to launch Word Document

[kptasteve]

I would like to have a hyperlink field in a database of records that contains patient information. The initial visit is dictation in a Microsoft Word Document. Is there a way to have a field in the Patient (client or subscriber) table that could have a hyperlink to the Microsoft Word document that would launch the document for editing or printing.

Steve Marcum PT
programmer

 

[KenReay]

Hi

When creating the column in the table (design view) set its type to Hyperlink, from the dropdown list, or do I missunderstand your question? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[merk]

Is there an easy way to do this where one could browse for a specific document?

 

[kptasteve]

that is what I would like to do, have some sort of dropdown list that would allow me to choose the document that belonged to that specific patient, ie initial evaluation, lab reports, home instructions, and discharge summary.

Steve Marcum PT

 

[KenReay]

Hi

Ok, so now you have changed the question.

Assuming you want a 'human readable' descripition (eg initial evaluation, lab reports, home instructions etc) you need two columns in the table, a string column to hold the descriptive text, and a hyperlink to hold the path to the actula document.

Again assuming you can have 'n' documents per patient the document addresses would be in separate table so you would have a patient table and a document table, related on patientid. Without knowing more about your application, I am not sure what the key of the Documents table would be.

So

TblPatient
lngPatientId (PK)
strName
strAddress
...etc

tblDocuments
lngPatientId
strDocumentDescription
hypPath

You can display the list of available documents using a combo box, with two columns (Description and hyperlink) the hyperlink is hidden from the user, but available to the application to call up the document


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[kptasteve]

I understand the concept, but there is only going to be a finite or fixed number of documents with this design. If needed a more variable table of contents then 2 tables would be the case.

Steve Marcum PT
Programmer

 

[KenReay]

HI

Well it is up to you, the number of documents may be fixed now, but next week, nextmonth who knows, users have a habit of changing their mind, better to go for the flexible approach.... in my view Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK