opening word in access

[Ron]

Hi

On my access form I have buttons that open wordfiles
these files are connected to queries in access, when I click the buttons
the word files automatically open and the fields are filled with data. Till
sofar all fine
I renamed the database
the problem is that one specific wordfile is giving an error, the other
files are oke
I reconnected the file to the database
When I click the button the database connects to that wordfile end the
wordfile wants to connect to the database which creates an error message
such as "the database is locked".

The button vb for the button is
Private Sub antisprout_Click()
On Error GoTo Err_antisprout_Click
Dim stAppName As String
stAppName = "winword.exe c:\database\wordacces\antisprout.doc"
Call Shell(stAppName, 1)
Exit_antisprout_Click:
Exit Sub
Err_antisprout_Click:
MsgBox Err.description
Resume Exit_antisprout_Click

End Sub

How do I open the wordfile to see the programming for connecting the
database??


thanks for your help
Ron

 

[Albert D. Kallal]

I have a nice working sample that handles your problems quite well.

Give my sample a try:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html