Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Outlook Access/Word Forms (2000)

    Hello,
    As of right now I have a database in Access which I may enter to daily, Upon entering the data I then run "today's" query and merge it with a document in Word. It becomes a 2 page document that I then have to copy and make it a 2-sided form (Please don't ask.. LOL) and send out to a few different people. I have only filled out side one as the outcome from the physician will be handwritten on side 2 and then that will be entered back into the database. I was just hearing about forms in outlook and was wondering if there was some way that Outlook (or Access) can help automate this procedure, by having the physician enter the data directly into Outlook and have that information fall into Access so we can still get all of out numbers that we need to report out. Any help???

    Thanks in advance (I have added the form here)
    Joanne <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

  2. #2
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Access/Word Forms (2000)

    That can be done. To get a feel for the scope of a project like this you might want to browse over to http://support.microsoft.com and do a search in your version of Outlook for the words Access and Automation. Depending on your requirements this could be easy or hard. I have to ask, though, if it wouldn't be simpler to let the doctors use the Access application?

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Access/Word Forms (2000)

    Thank you for the help, As for the doctors using the Access database, that's a whole other issue, with the IT Department and it's like pulling teeth to get shared access to anything around here.
    Thank you
    Joanne

  4. #4
    5 Star Lounger
    Join Date
    May 2001
    Location
    Washington, USA
    Posts
    750
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Access/Word Forms (2000)

    Joanne, I was afraid you'd say something like that. Unfortunately, it suggests a difficult time in doing the solution in outlook too. The problems at a high level are: 1) They would still need to have rights to the Access database; 2) They would probably need what's called an ODBC connection to the database set up on their systems, and; 3) Unless this could all be done in VBScript, someone would have to get the code into their Outlook VB project.

    Those issues aside, it is possible for Outlook to read and write to Access. The automation searches that I suggested would provide some examples of how that's done. I hope this has helped somewhat.

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Outlook Access/Word Forms (2000)

    Could you persuade them to type into the Word document, save, and forward it back to you? There's a potential for grumbling if the changes get lost (e.g., forgetting to let Outlook save the changes to "the message"), but it could simplify your life in other ways.

  6. #6
    Star Lounger
    Join Date
    Feb 2003
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Outlook Access/Word Forms (2000)

    I think the best solution in this sort of environment is the old distributed solution - consider having a form (not Access - Word or Excel, whichever you like the most). The form has been configured with named cells (Excel) or bookmarks (Word) - it can have drop downs, and check fields are valid etc. The user fills in the form and either sends it to you via email, or saves into a shared directory. You manually open the document, and run your macro, which rips the data from the names/bookmarks, and put it into the database. At least no retyping, and no need for any "help" from corporate IT.

    (If you need closer direction, let us know - we all love these sorts of solutions!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •