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

Topic

New Reply

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

Reply | Quote

Replies

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/library/office/ee336038%28v=office.12%29.aspx

Create custom menus and shortcut menus by using macros
http://office.microsoft.com/en-us/access-help/create-custom-menus-and-shortcut-menus-by-using-macros-HA010282509.aspx

Reply | Quote

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

Reply | Quote

Try:

acCmdExportRTF

Reply | Quote

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?

Reply | Quote

Sorry, I should have been more clear that acCmdExportRTF is a Runcommand option.

Try this:

Code:

DoCmd.RunCommand acCmdExportRTF

Reply | Quote

Did you find a solution?

Reply | Quote