Hello i need to find out how to open a word document from my access database any one know a good solution.

i have an ole object and you can drag and drop the file onto it but i need a way to have it load up in Word so it can be read/written/printed via word 2003.

There's a better way to open a word document using the Windows API.

Copy this code to the top of your form/module under Option Compare Database...

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

Copy this as a function in your form/module....

Private Sub OpenFile(File As String)
On Error GoTo cmdOpenFile_Err
'open the document in whatever application it requires
ShellExecute 0, "open", File, vbNullString, vbNullString, vbNormalFocus
Exit Sub
cmdOpenFile_Err:
MsgBox "An unexpected error has occurred.", vbOKOnly + vbCritical, "Error Conditon in Opening File"
End Sub

Then call....

OpenFile("C:\MyDocuments\MyWordDoc.doc")

This will cause word to open and the file to be displayed just as though someone double clicked the file. You don't need to know where word is stored as basically your asking windows to open the file for you.

This will work for images, pdf, any document at all.

They will all open in their default application.

The following code actually opens a Word document in Microsoft Office Word 2003 from a ASP.NET 2005 /Framework 2.0 Webform.

You can use Word objects to open a word document

Make sure that you include the Word 9.0 Object Library and then add the following code

Dim oWd as Word.application

Dim oDoc as Word.Document

Set oWd= New Word.application

Set oDoc = oWd.open(C:\MyDoc.doc")

'--- Now you get all the Word objects and you can print and play with them

' -- Finally destroy your objects

Set oDoc = nothing

Set oWd = nothing

Shasur

Thanks all both solutions seem to be perfect i have experience using the open file command though so i'll most likely end up using that 1.

thanks again for the help