473,372 Members | 1,355 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 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 9543

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Asma | last post by:
Dear Sir, I am trying to find a way to open a Word document using C language and read the text of word doc into a variable. (Turbo C on Dos 6.0). Can anyone please tell me which libraries in...
3
by: sandycat05 | last post by:
Hello all, I am a new Perl programmer. Below is the beginnings of a code that I am using to manipulate an Excel spreadsheet via Perl using win32::OLE. However, what I'd like to do is the following:...
4
by: Terry Diederich | last post by:
I have a client with a VB6 application that uses the OLE Control to display PowerPoint slides. The PowerPoint slides are saved in a column in the database (Oracle). The problem is that the OLE...
8
by: Fly Girl | last post by:
I've been reading a number of postings on .Net that indicate that there is no OLE Container control for .Net applications. Has anyone successfully converted a VB6 or MS Access 2000/2002 app that...
3
by: Alan | last post by:
Hi, I'm converting a database application from Access 97 to C#/SQL Server. Old database contains some images in OLE fields. I've figured out that there's OLE header preceeding actual image data...
1
by: TheOne | last post by:
I'm using OLE DB model to insert long texts into ntext field. My code looks like : == BOOL COleDBRowData::Execute(CString strSQL) { if(!m_bIsOpen) return FALSE; CCommand<CNoAccessor,...
6
by: Rasputin | last post by:
Hello, I am new to this forum, but the activity I have noticed reading the posts helps me believe this is a good spot for wannabes programmer like me. I am also fairly new working under a...
1
by: valentju | last post by:
Hi, I am using VB 6 to do the following. I am currently saving a jpg image to a sql db, I read the jpeg via an OLE in binary tye 1 format and store in to the sql db. Attached is a portion of the...
1
by: mohanprasadgutta | last post by:
Hi, I need help to open a password protected excel file in perl using Win32:OLE. when I tried to open file in normal way at the time of program execution it is prompting me to enter password. I am...
1
by: Prasanna CRN | last post by:
Hi Friends, I am trying to open particular Worksheet from MS Excel workbook (WIN32 :: OLE). I cannot able to work on particular sheet. Please help me on this : $Excel =...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

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.