Results 1 to 4 of 4

Thread: How to save/export my formatted report from Access-DB to Word-File?

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Dec 2005
    Posts
    26

    How to save/export my formatted report from Access-DB to Word-File?

    hi, all!

    It's a simple question. I'm sorry, but I couldn'd find an answer in this forum

    I have formatted several nice reports.
    Could you be so kind to help me in VBA to save/export for example my Report1 from DB1.mdb to Report.DOC (I need to save format of pages too: fonts, colors, footers, etc...).

    Code/example would be very much appreciated

    thanks in advance!
    kind regards.
    Baloo.

  2. #2
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: How to save/export my formatted report from Access-DB to Word-File?

    if it is in crystal the option is already there...just check the export options...otherwise include word object into your project and create a word file but this is a tedious work...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.


  3. #3
    Lively Member
    Join Date
    Apr 2006
    Posts
    68

    Re: How to save/export my formatted report from Access-DB to Word-File?

    G'd morning!!!
    To export your report to ms word, you can do it in two (i guess) ways, depending on the report layout itself.
    The easy one, is to add a button in your form and let the wizard to write the code to export the report to word.
    The hard one is to automate ms word. To do that you will need create a .dot
    document, make all the design by hand and place bookmarks for every data field.
    The first one is ok if your report is doesn't need parameters and with very basic layout.
    In the second, you have full control. You can have the word report just as you have it in access.
    I may dare to add another "option". If the report just for reading you can send your
    Access report to any pdf printer, you can find a lot of them for free.

    Good luck
    Estuardo

  4. #4
    Super Moderator RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,717

    Re: How to save/export my formatted report from Access-DB to Word-File?

    See my code examples in thi shtread.
    http://www.vbforums.com/showthread.php?t=395689
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

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



Click Here to Expand Forum to Full Width