Open an ole-object from a table

[jj]

Hi ng

I have a table called tbl_dokumentation which has two fields: Docname, And
DocID
The Docname is an ole-object field. I have stored three word documents in
the table. Now I wan't to Open each document by clicking a button on a form.

How can I do that.
I have read somewhere that I should use:
Me.fldOLE.Verb = acOLEVerbOpen
Me.fldOLE.Action = acOLEActivate

Unfortunately I'm not sure what to do :-(

TIA
JJ

[Steve Cartnal]

"jj" <[e-mail] in message
news:45*********************@dread11.news.tele.dk. ..

Hi ng

I have a table called tbl_dokumentation which has two fields: Docname, And
DocID
The Docname is an ole-object field. I have stored three word documents in
the table. Now I wan't to Open each document by clicking a button on a
form.

How can I do that.
I have read somewhere that I should use:
Me.fldOLE.Verb = acOLEVerbOpen
Me.fldOLE.Action = acOLEActivate

Unfortunately I'm not sure what to do :-(

TIA
JJ

JJ,

If you create a form, using that table as the record source, and then place
a bound object frame on the form, with the control source set to Docname,
you can display each of the Word documents, one at a time, and scroll
through them by clicking the navigation buttons at the bottom. You don't
really need to create a button to do that. If you want to use a button
somewhere else to open that form already set to a specific Docname, you can
do that. I'm not sure from your question if the button is as important as
seeing the Word docs.

Steve

[jj]

Hi Steve

Thx for your answer

I'm not interested in opening the dokument in a frame - I want to open it as
a word document - is that possible?

Thanks
JJ
"Steve Cartnal" <sc******@alltel.netskrev i en meddelelse
news:ed***************************@ALLTEL.NET...

>
"jj" <[e-mail] in message
news:45*********************@dread11.news.tele.dk. ..

>Hi ng

I have a table called tbl_dokumentation which has two fields: Docname,
And
DocID
The Docname is an ole-object field. I have stored three word documents in
the table. Now I wan't to Open each document by clicking a button on a
form.

How can I do that.
I have read somewhere that I should use:
Me.fldOLE.Verb = acOLEVerbOpen
Me.fldOLE.Action = acOLEActivate

Unfortunately I'm not sure what to do :-(

TIA
JJ

JJ,

If you create a form, using that table as the record source, and then
place a bound object frame on the form, with the control source set to
Docname, you can display each of the Word documents, one at a time, and
scroll through them by clicking the navigation buttons at the bottom. You
don't really need to create a button to do that. If you want to use a
button somewhere else to open that form already set to a specific Docname,
you can do that. I'm not sure from your question if the button is as
important as seeing the Word docs.

Steve