Timing error writing to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am sending data from Access to Word. In Access there is a form with
selection criteria. There is also a query that contains the selected data.
There is code behind a form button that writes the data in the query to Word.
As each record is written the code selects the appropriate table in the Word
document and adds new rows to the table, adds and resizes cells and sends the
data. The code works if I step through it but fails if it runs free. I
suspect that Access sends commands and data faster than Word can process
them. Is there a way for Word to talk to Access? Specifically Word needs to
tell Access that the previous process is complete and it is OK to send the
next.

Thanks,
 
Please post your code to see what may need slowing down. I know that when i
send individual query field values into formfields in Word it is fast enough.
 
i hmadyson,

Thanks for your reply. I have solved the problem and want to post the
solution. For each record I was writing to Word I needed a table with 4
rows. Each row had a different number of cells and the cells had different
widths. Initially, (when I was having the problem) I was creating a table
from scratch for each record including adding and sizing cells. I switched
approaches and now have a complete, but unpopulated table in the template
that I copy and paste for each record written.
 
Back
Top