Results 1 to 3 of 3
  1. #1
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    Passing variables to a Word Doc.

    I am trying for the 1st time to pass Access variables to a Word document.



    I used this as a starting point http://support.microsoft.com/kb/260410

    It seem fairly straight forward.

    I made a little db with one table - one record - and I am attempting to have it pass the data and open a Word document.

    Without success.

    Attached are files that show the works.

    My Access DB
    My instructions on how to with the marco code i am trying to use
    The Word document i am going to
    Screen shots of the failure


    Thanks for any pointers.
    fyi - Office 2003 for the software - Russ

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    try using the Word merge feature of Word working inside Word instead. see if you can get that to work...

  3. #3
    techexpressinc's Avatar
    techexpressinc is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Dec 2008
    Location
    Indiana, USA
    Posts
    151

    fixed

    I think i am up and going. At least the Word document is popping up with some of the fields getting loaded.

    It was a bit tricky - I needed to get an MS Word Object loaded and getting the MS Word object to load was not obvious - you need to do it in the right place. Which is like in the Visual Basic screen Tools not the main MS-Access screen Tools, the reference option is different.
    Russ

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

Similar Threads

  1. Shell with Batch Variables
    By robbyaube in forum Programming
    Replies: 2
    Last Post: 12-19-2019, 11:06 AM
  2. Variables in Forms
    By NewDeveloper in forum Forms
    Replies: 1
    Last Post: 06-20-2010, 08:04 AM
  3. Append Query using variables
    By hawg1 in forum Queries
    Replies: 2
    Last Post: 06-09-2010, 08:59 AM
  4. Eval function with variables
    By tuna in forum Programming
    Replies: 3
    Last Post: 05-14-2010, 06:02 PM
  5. sql in vb variables
    By emilylu3 in forum Programming
    Replies: 3
    Last Post: 03-04-2006, 01:26 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
  •  
Other Forums: Microsoft Office Forums