By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,948 Members | 663 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,948 IT Pros & Developers. It's quick & easy.

Open an ole-object from a table

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

"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

P: n/a
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.