Results 1 to 13 of 13
  1. #1
    Join Date
    Feb 2010
    Location
    Yorkshire UK
    Posts
    76

    Unanswered: Using Word Templates in Access

    I am trying to learn more about using word templates in Access as I am having problems with the layout of Access reports when I e-mail them. None of my text books seem to cover this area very well. Does anyone know of any good books or sites where I can learn more?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    What's a word template?
    I have written stuff to populate word mail merge documents from Access. Dunno if that's the same thing.

  3. #3
    Join Date
    Feb 2010
    Location
    Yorkshire UK
    Posts
    76
    Setting bookmark within WORD and then populationg the WORD document.

    e.g.

    Dim oWord As New Word.Application
    With oWord
    .Documents.Add "Film Details.dot"
    .Selection.GoTo wdGoToBookmark, , , "bmkFilmTitle"
    .Selection.TypeText Me.FilmTitle & " (" & Me.FilmYear & ")"
    .Selection.GoTo wdGoToBookmark, , , "bmkDirector"
    .Selection.TypeText Me.DirectorFullName
    .Selection.GoTo wdGoToBookmark, , , "bmkStudio"
    .Selection.TypeText Me.Studio
    .Visible = True

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Actually, just noticed what started this. What format do you send your reports in?

    Re the bookmarks - I think I played with those too. I prefer Mail Merge myself.

  5. #5
    Join Date
    May 2010
    Posts
    601
    I like using a true Word Template (.dot). In my opinion they are generally under utilized.

    I agree that mail merge is a lot easier way to go. I generally mail merge with a Word Template as the source document.

    See this Word Merge example Click Here
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by HiTechCoach View Post
    I like using a true Word Template (.dot). In my opinion they are generally under utilized.
    I suck with Word. What's the advantage?

  7. #7
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by pootle flump View Post
    I suck with Word. What's the advantage?
    Why you should use a Word Template Document format
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  8. #8
    Join Date
    Feb 2010
    Location
    Yorkshire UK
    Posts
    76
    I send my reports as RTF files. I am not using 2007 and have struggled converting to PDFs. I have a great report which is an order acknowledgement for our customers. Once this is e-mailed, I lose all my boxes and it looks very untidy.

  9. #9
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Jabber View Post
    I send my reports as RTF files. I am not using 2007 and have struggled converting to PDFs. I have a great report which is an order acknowledgement for our customers. Once this is e-mailed, I lose all my boxes and it looks very untidy.
    Have you tried sending in snapshot format? That is a perfect render of the report, but read only.
    You are right, exporting reports to any Office files sucks.

  10. #10
    Join Date
    Feb 2010
    Location
    Yorkshire UK
    Posts
    76
    Looked at snapshot but customers who receive the report may not have Access and would have no idea how to download software etc.

  11. #11
    Join Date
    May 2010
    Posts
    601
    If you want to use a PDF, then I would recommend this free tool:

    Reports to PDF

    I have had great success with it. I even use it with Access 2007 and Access 2010 to combine PDF's together.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

  12. #12
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by Jabber View Post
    Looked at snapshot but customers who receive the report may not have Access and would have no idea how to download software etc.
    This is the beauty of snapshots - it is not well known but they render perfectly in Internet Explorer (or at least they did last time I tried - not tried in IE 7 or 8).

  13. #13
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by pootle flump View Post
    This is the beauty of snapshots - it is not well known but they render perfectly in Internet Explorer (or at least they did last time I tried - not tried in IE 7 or 8).
    It is true that you can view snapshot files in IE if you have the snapshot viewer files installed on the PC.


    I have an app that publishes reports as snapshots (.snp) to a web server. I have always had to have the client PC install the snapshot viewer before they could view the snapshot in IE.

    Also note: the snapshpt format is not longer support in Access 2010. That is why I have started using to PDFs.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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