Hey guys I have an INTERMITTENT problem. I am calling MS Word from a form command button and sometimes Word opens correctly and opens on top of Access, other times it activates on the taskbar but stays behind the Access form, and I have to click on the Taskbar to open the doc. I have no idea what is the trigger that makes it work - sometimes. Here is the code:
LWordDoc = "C:\MyForm.doc"
Set WApp = CreateObject(Class:="Word.Application")
WApp.Visible = True
WApp.Documents.Open filename:=LWordDoc
Wapp.Activate
I am using MS Access 2000 and MS Word 2000 running under Windows 7 Pro. I have tried all variations and scoured the net and tried all forms of code and the only thing I don’t understand is how the Running Object Table (ROT) may or may not be a factor.
Thoughts??
Thanx
Bill
BTW, Happy Holidays
LWordDoc = "C:\MyForm.doc"
Set WApp = CreateObject(Class:="Word.Application")
WApp.Visible = True
WApp.Documents.Open filename:=LWordDoc
Wapp.Activate
I am using MS Access 2000 and MS Word 2000 running under Windows 7 Pro. I have tried all variations and scoured the net and tried all forms of code and the only thing I don’t understand is how the Running Object Table (ROT) may or may not be a factor.
Thoughts??
Thanx
Bill
BTW, Happy Holidays