I have resolved the problem :) It wasn't the word application, oword which had to be reset. The problem lied with the dataset having to be reset. DS which is used in the function is a global dataset this is declared. At the start of that function I reset the dataset and now my problem is...
I have had another go at tackling my problem and I now believe the problem lies where I have created the word.application object.
oWord = CreateObject("Word.Application")
This code is creating an object but the object is not emptying after it has been used. I have read up on emptying objects...
Hello,
My aim is to export data from my SQL database into a word document. I have managed to export data into the word document from my database however if I was to go back onto the word form and type another service ID from the database and click export to word document it would export the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.