PDA

View Full Version : Command Button Problem



UglydogNH
10-05-2011, 04:16 AM
OK, I’m stumped! I need to put a command button on a form that will open and fill in the fields of the open record to a MS Word template. Can someone please help me!!??

HiTechCoach
10-06-2011, 08:18 AM
This may help:

How to send the current record to Word with automation (http://www.hitechcoach.com/index.php?view=weblink&catid=84%3Aaccess-vba-office-automation&id=407%3Ahow-to-send-the-current-record-to-word-with-automation&option=com_weblinks&Itemid=23)

UglydogNH
10-06-2011, 12:39 PM
This is a great article. I've read it and tried working with it but I don't know how to change the code to work with Word 2007. I would be great if you could help out.

Thanks

HiTechCoach
10-06-2011, 10:12 PM
This is a great article. I've read it and tried working with it but I don't know how to change the code to work with Word 2007. I would be great if you could help out.

Thanks

The only things that will be differen5t will the the refence you set. The rest of teh code should work.

Where it says: "Set a reference to the Microsoft Word 9.0 Object Library" you will need to select the Word 12 object library.