Learn how to a build a cloud-first strategyRegister Now


Select the location of a file in microsoft access and store that location as a hyperlink

Posted on 2007-08-09
Medium Priority
Last Modified: 2012-06-27
Select the location of a file in microsoft access and store that location as a hyperlink
Question by:ittechdarren
  • 2

Author Comment

ID: 19664548
I was not very descriptive above; Please let me explain.
I need to build a pretty simple database that is being used for a transcriptionist to enter info about the patients from the doctors dictation. Here is the deal, 9 out of 10 times when the doctor sees a patient he will dictate same as last seen. If I had a way for the database to track word documents (they are word becasue thats what they transcribe into). I could click a button to take and open the last seen document. Of course that would be a query against the last seen date. I hope this is a little clearer.

Expert Comment

ID: 19669162
there is a journal feature in microsoft outlook you could enable. that tracks documents, dates, times and you can open them from there.

Author Comment

ID: 19671761
Thats not gonna work for me, I need a database Solution
LVL 18

Accepted Solution

bonjour-aut earned 1500 total points
ID: 19677396
Hi ittechdarren,

You can use Word VBA from MS-Access-Application.
So you can do nealy everything, which is supported from Word-VBA.
e.g. you can search for word documents, search the content, copy the content, make a new document, etc.
The real challenge is, that the content of a word document is not structured (there are no field like in a db or cell like in excel), so to extract specific parts of the text you will need reliable logical marks in the text, as e,g, Diagnosis: ..... End., Summary: ....End.,  Prescription: ....End
so if you think you have this prerequisites, i can supply sample code, how to open word document, search for a part of text and generate a new word documnet from access code.

regards, Franz

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question