Opening word document through Access

[jo.stanley]

I am using Access 2000 and I am trying to open a word document within Private Sub Command103_Click()
and it isn't working - the code I am using is as below - can anyone see why it won't work

Dim objWord As Word.Document
Set objWord = GetObject("C:\BATS\BATS\Exports\Incorrect.doc", "Word.Document")
On Error Resume Next
objWord.Application.Visible = True
objWord.Application.WindowState = wdWindowStateMaximize
objWord.Application.Activate

 

[ChrisUK]

Can you not do it the other way round ?

Open your word document and then use this to query the DB ?

ChrisUK