471,337 Members | 805 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

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
Mar 18 '07 #1
2 9256

"jj" <jj@get2net.dkwrote 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
Mar 18 '07 #2
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" <jj@get2net.dkwrote 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

Mar 19 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Asma | last post: by
4 posts views Thread by Terry Diederich | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.