Results 1 to 4 of 4

Thread: Insert Access Report into Word Doc

  1. Dec 8th, 2005, 09:40 PM #1
    kpaske
    kpaske is offline

    Thread Starter
    New Member
    Join Date
    Dec 2005
    Posts
    15

    Insert Access Report into Word Doc

    I have an MSAccess database and have generated some queries, which I have formatted nicely into reports. Now I want to generate a Word document, inserting the formatted report. I used bookmarks and the WordObj.ActiveDocument.TypeText command to insert several other fields. Can I use a bookmark to show where I want the report inserted, and if so, what command do I use? If not, is there another way to do this programmatically?
    Reply With Quote Reply With Quote
  2. Dec 8th, 2005, 11:38 PM #2
    Dave Sell
    Dave Sell is offline
    PowerPoster Dave Sell's Avatar
    Join Date
    Mar 2004
    Location
    /dev/null
    Posts
    2,961

    Re: Insert Access Report into Word Doc

    You may be able to if you can Export the report as an OLE type that can be inserted into a Word doc. I'm not sure if Word understands what an Access report is.
    Nobody knows what software they want until after you've delivered what they originally asked for.

    Don't solve problems which don't exist.

    "If I had eight hours to cut down a tree, I'd spend six hours sharpening my axe." --- Abraham Lincoln (1809-1865)

    2 idiots don't make a genius.
    Reply With Quote Reply With Quote
  3. Dec 9th, 2005, 08:08 AM #3
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Insert Access Report into Word Doc

    Moved to Office Development.
    Reply With Quote Reply With Quote
  4. Dec 9th, 2005, 08:41 AM #4
    kpaske
    kpaske is offline

    Thread Starter
    New Member
    Join Date
    Dec 2005
    Posts
    15

    Re: Insert Access Report into Word Doc

    I will look into exporting as an OLE... is there a better way to accomplish what I am trying to do?

    It's basically a memorandum, with some different fields from different tables inserted (using bookmarks). That part works perfectly. But I also need to include a list of records, based on a specific query, and I'd like to be able to format the data so it looks nice. I don't care if its done in Access or Word or whatever. Any ideas?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width