Results 1 to 7 of 7
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How do I add a Publish It with MS Word short cut to the tool bar for Report

    How do I add a Publish It with MS Word short cut to the tool bar for Reports

    Using Microsoft Office Outlook 2007 (12.0.6423.1000) SP2 MSO (12.0.6425.1000)
    Windows XP

    I have a report printed to the screen and I want to Publish It with MS Word

    I'm having problem with Access 2007 Customize Quick Access Toolbar

    I added a Office Links shout cut to the Tool Bar, however it is dimmed out and mouse hover reads Specify a Table or Query as the Data Source

    I also added Publish and ir is dimmed out without any options

    On previous versions of Access I would click Publish It with MS Word and the Access report would copy into a Word document

    How do I add a Publish It with MS Word short cut to the tool bar for Reports

    Thanks, John
    11397335

  2. #2
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    In Office and Access 2007 and later it has got a lot harder to do what you want.

    If it were me, I would create a shortcut/pop up/right-click menu.

    See:

    How to: Create a Shortcut Menu for a Form, Form Control, or Report
    http://msdn.microsoft.com/en-us/libr...ice.12%29.aspx

    Create custom menus and shortcut menus by using macros
    http://office.microsoft.com/en-us/ac...010282509.aspx
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the references

    I have a customiezed Menu Bar that has most of the functions in the standard File, Edit, Insert, Tools, Windows and Help Menu Bar

    And I have a mod_Tool_Bar_Menu module that has all the equivelent functions

    Function Menu_FormView()

    DoCmd.RunCommand acCmdFormView

    End Function

    What would be the equivlent DoCmd.RunCommand ????????? to put the on screen report into Office Links Word?

    Thanks John

  4. #4
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Try:

    acCmdExportRTF
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  5. #5
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts
    1. With the report on the screen, you right click on the document

    2. Click Export

    3. Click Word RTF File

    I'm looking for the equivlent DoCmd.RunCommand ????????? to put the on screen report into Office Links Word?

  6. #6
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Sorry, I should have been more clear that acCmdExportRTF is a Runcommand option.


    Try this:
    Code:
    DoCmd.RunCommand acCmdExportRTF
    Last edited by HiTechCoach; 2013-06-28 at 11:45.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  7. #7
    3 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    200
    Thanks
    0
    Thanked 31 Times in 30 Posts
    Did you find a solution?
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Tags for this 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
  •