Results 1 to 3 of 3
  1. #1
    cphelps48 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    13

    Recreate Word document in Access Report

    I have the following Word document that is used by a department of ours. They would like the document to have the upper section automatically filled in from a database for our vehicles.



    Originally I showed them a mail merge between the original Word document and the output of a query. Unfortunately that seemed too labour intensive.

    My latest thought was to have a table where they could enter the form name and have that linked to several records in another table that would contain each individual item number. This way they could maintain the items for themselves without having to get an Access designer to rework the report.

    I have prototyped this and am kind of happy when using a report/subreport setup. However I was wondering how I might duplicate the effect or layout that looks like a Word table in the Access Report.

    I can do it by putting a border around each field and nudging them up against each other. However as soon as the description for one item becomes more than one line it all looks out of wack.

    If anybody can give me an example or ideas on how to duplicate this I would appreciate it. My main objective is to design it once and then allow them the power to add/delete items as needed, change the Note info, etc.

    I should add that we are using Access 2003.
    Last edited by cphelps48; 10-18-2011 at 12:17 AM. Reason: Correction

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,228
    Is the textbox CanGrow property set to No? If the textbox isn't wide enough, the data will be cut off.

    Reports don't have a Datasheet view like forms. So option is the one you have tried or to have a subform/report control on the report use a form set to Datasheet as SourceObject.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cphelps48 is offline Novice
    Windows 7 64bit Access 2003
    Join Date
    Aug 2011
    Posts
    13
    Solved this by using a subreport in a report with some finite design work to have fields butted up against each other with the borders turned on to make it look like a table.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-19-2011, 10:20 AM
  2. Closing Word Document From Access
    By bburton in forum Programming
    Replies: 2
    Last Post: 04-25-2011, 10:23 AM
  3. Open a word document from access
    By natalia in forum Programming
    Replies: 1
    Last Post: 10-13-2010, 08:04 AM
  4. Replies: 7
    Last Post: 08-31-2010, 12:15 PM
  5. Word document INTO Access form
    By jonathonhicks in forum Forms
    Replies: 0
    Last Post: 04-30-2007, 05:59 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 - Senior Forums