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

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

    Author Comment

    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.
    LVL 1

    Expert Comment

    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

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

    Accepted Solution

    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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Read about achieving the basic levels of HRIS security in the workplace.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    6 Experts available now in Live!

    Get 1:1 Help Now