Opening a Word document from an Access Form

[Jamie]

help again!

Can other office documents be created and opened from an
access form?

Jamie.

 

[GPO]

Depends what you wanna do. Do you want to open an existing
word doc?

Do you want to send data to a new word doc?

You can get data out of Access using Word's mail merge
feature but this has some big limitations in terms of
grouping data.

You can export reports etc to Word but it is just badly
formatted rich text and not worth the effort.

You can control MS Office applications by using Access as
an Automation client in VBA. Make sure you have the Word
object library selected in references. This aircode might
get you started.

Sub LaunchWord
Dim objWord As Word.Application
Set objWord = New Word.Application
objWord.Visible = True

'Muck around here

objWord.Quit
Set objWord = Nothing
End Sub

Cheers!

Greg

 

[Jamie]

Greg,

thanks for your reply. I have put together a simple
database which controls proposal numbers. All I want to
do is be able to press a button on a form and then open a
word document with the proposal number identified from
the database. I do not need to pass any information into
the word document, just simply open word.

I shall play with what you have given me, but if you have
any more information then I would appreciate it.

Thanks

Jamie

 

[Sue]

You can import an Excel chart into Access. I'm using
Access 2000. It takes a little monkeying around, but I
like how it worked for me!