Add Analyze with Word/Excel Office Links Buttons to Form

[headly]

Want to add the Analyze with Word/Excel buttons on my form, but can't see how
to get them there. Do I tie in a VBA procedure to the button's on click
event? Any examples floating around I could follow?

 

[Joan Wild]

DoCmd.RunCommand acCmdWordMailMerge - merge it with MS Word
DoCmd.RunCommand acCmdOutputToExcel - analyze it with Excel
DoCmd.RunCommand acCmdOutput to RTF - publish it with Word

http://home.clara.net/tkwickenden/

 

[headly]

Hi JW,

Thanks for the assistance.

When I use the acCmdWordMailMerge I get the following error message:

The command or action WordMailMerge is not available now

Any thoughts? TIA

 

[Joan Wild]

Yes I had forgotten that. You need to select a query or table. Select your
query that the form is based on
DoCmd.SelectObject acQuery, "qrySomething", True
and then do.
DoCmd.RunCommand acCmdWordMailMerge

Another alternative is to use Albert Kallal's Super Easy Word Merge; it's on
this page
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html