Results 1 to 2 of 2

I just need to take my access data, and output it in a note form

  1. #1
    beebop83 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2012
    Posts
    1

    I just need to take my access data, and output it in a note form

    So here's what I'm trying to accomplish:

    I've been working with a doctors office, and he always asks patients certain questions when he see's them. The answers are generally discrete, and the answer is chosen from a drop down.
    I've set everything up so that he just selects the patient he wants, and he can view what thier responses were from the last visit, then make any appropriate changes.
    I've setup a nice form for him to go through where he can make his selections, and save them to the patients access record.

    Here is where I'm stuck:

    This access database does not, and will not interface with the electronic medical record he uses. It's meant to be a standalone database to hold his patient interview questionnaires, so once he fills out the questionnaire, or makes a few changes to it, he will need to be able to generate a 'note' that displays the name of each database field, followed by the response given for that particular patient. Ideally, I want to set things up so that he completes the questionnaire and hits a button that creates a note from the questions and answers provided, and then copies that note automatically to the clipboard. Once the note has been copied, he can switch over to his web based EMR and paste the note there.

    Does anyone know of an easy way to create a note like document from the field names and responses given in a database, and then copy that document to the clipboard so that it can be pasted into another word editing program?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    10,960
    You may find this link useful: http://allenbrowne.com/func-07b.html
    (RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 Pro - acXP, ac07, ac10, ac13
    If your issue is resolved...go ahead and use the Thread Tools at the top of the thread and mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Can I add a note to a Query?
    By alexc333 in forum Access
    Replies: 2
    Last Post: 07-26-2011, 10:50 AM
  2. Form output data manipulation
    By bearsgone in forum Forms
    Replies: 1
    Last Post: 04-05-2011, 03:21 PM
  3. Replies: 0
    Last Post: 08-20-2010, 08:26 AM
  4. warning to make update note
    By ga3la in forum Access
    Replies: 1
    Last Post: 01-30-2010, 07:51 PM
  5. Need help with 'note book' idea.
    By Luk3y in forum Access
    Replies: 0
    Last Post: 06-26-2009, 08:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums