If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back  dBforums > PC based Database Applications > Microsoft Access > Winword Error sending Access data to Word

LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Registered User
Join Date: May 2012
Location: Boynton Beach, Florida
Posts: 7
Winword Error sending Access data to Word

Wasn't sure where to post this being that there is so many programs involved here, but here it goes. I have a 2010 Access database front end with a SQL back end and we had a term server created with VMWare on our 2003 server so that no matter what version of MS Office people had they could still use the Access Database. My problem is that almost every time they run the command button to create a Word document it freezes and I have to go into the task manager of the term server and end process on the multiple Winword instances to unfreeze it. I have been searching high and low trying to find some VBA to add so that it would not do this, but so far I haven't found anything that works. If anyone has any ideas I would be so grateful. I attached the code that generates the word document, this is the code that the form command button calls.
Attached Thumbnails
Winword Error sending Access data to Word-generateonedocvba.jpg  
Reply With Quote
  #2 (permalink)  
Join Date: Mar 2009
Posts: 5,201
Just a few ideas:

1. Can you trace, step by step, in the procedure and try to determine which line of code causes the problem?

2. What's the code for the MakeWord procedure?

3. Personally I would use an early binding for the wordApp object variable:
Dim wordApp as Word.Application
Set wordApp = ...
Have a nice day!
Reply With Quote
  #3 (permalink)  
Registered User
Join Date: May 2012
Location: Boynton Beach, Florida
Posts: 7
Whoohoo! I think I may have found the problem, I added the reference “Microsoft Remote Data Services Server 6.0 Library” and I have ran the Word outputs several times from different computers and no errors! The only people using this term server setup is the people who have not upgraded to Office 2010 and that was the only people having this issue of it locking up and multiple Winword instances. The database runs fine for everyone else. We basically used a form and some VB defining what we wanted Access to create and then it makes a Word document from a single blank template, otherwise I would have a hundred different templates to contend with which would have been a pain every time someone wanted to make a change.
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On