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

using Word inside Access?

P: n/a
Trying to figure out the best way to accomplish this... I have a Purchase
Order form that we need to place an item "imprint" into with formatted
text, so that the manufacturer will see the exact imprint needed (size and
font). I felt that the best way to handle this was to place an OLE field
into the table, then place it on the form and have "word" as the text
editor.

Problem: how to get microsoft word to open when you double click on the
field. Right now it gives an error message on double click- that there must
be an "ole" object in the table in order to edit or open up bound control.
I diont want the operator chosing from the insert menu by right cklicking.
How can I get a blank "word" doc to open upon double click. OR... is there
a better method for a text field where you need to control formatting?
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a

"ivan" <in**@achieva.us> wrote in message
news:bH**********************@news4.srv.hcvlny.cv. net...
Trying to figure out the best way to accomplish this...


Why not just use the MS Rich Text control or do you need more functionality
than it offers?
Nov 12 '05 #2

P: n/a
How do you use the rich text control?

"Dale Green" <bi*******@home.com> wrote in message
news:59******************************@grapevine.is landnet.com...

"ivan" <in**@achieva.us> wrote in message
news:bH**********************@news4.srv.hcvlny.cv. net...
Trying to figure out the best way to accomplish this...
Why not just use the MS Rich Text control or do you need more

functionality than it offers?

Nov 12 '05 #3

P: n/a
How do you use the rich text control?

"Dale Green" <bi*******@home.com> wrote in message
news:59******************************@grapevine.is landnet.com...

"ivan" <in**@achieva.us> wrote in message
news:bH**********************@news4.srv.hcvlny.cv. net...
Trying to figure out the best way to accomplish this...
Why not just use the MS Rich Text control or do you need more

functionality than it offers?


Nov 12 '05 #4

P: n/a
My richtext control is not working.. I get a "You dont have the license
required to use the Activex control... " error. I tried to register it.
Didnt work. I tried regsvr32 on the file. Didnt work. Searching through
Microsoft knowledge base, it talks about a fix if this is caused by the
"developer edition". I am not using the developer edition.

Any ideas?

"Dale Green" <bi*******@home.com> wrote in message
news:46******************************@grapevine.is landnet.com...

"ivan" <in**@achieva.us> wrote in message
news:GR******************@news4.srv.hcvlny.cv.net. ..
How do you use the rich text control?


In form design "mode" you should have the Microsoft Rich Text Control
available from the Controls toolbar under "More Controls".

Make an appropriately sized Rich Text box on your form then feed it text
from your text control's double-click event like this

Private Sub Foo_DblClick(Cancel As Integer)
rtfPurchaseOrder.FileName = "PO.rtf"
End Sub

You'll probably want to feed the "output" to the Rich Text control in a
different way, I use it like above to display RTF files that are
pre-existing.

Nov 12 '05 #5

P: n/a

"ivan" <in**@achieva.us> wrote in message
news:UF*********************@news4.srv.hcvlny.cv.n et...
My richtext control is not working.. I get a "You dont have the license
required to use the Activex control... " error. I tried to register it.
Didnt work. I tried regsvr32 on the file. Didnt work. Searching through
Microsoft knowledge base, it talks about a fix if this is caused by the
"developer edition". I am not using the developer edition.

Any ideas?


Ah... I have Office Developer Ed. installed on this PC. I didn't link such
a common control to ODE... I figured it came with Office Pro.

If that's true then I'm sorry for wasting your time...

I have used Word in a Access form a long time ago but the details of what
control I used escape me right now. If I find the module later tonight I'll
fire you an email.

Here's an idea though... you can drop an IE control on a form, right? IE
will display Word files... soooo... use the IE control and instead of a URL
use a path to a Word file? That may require that each workstation has Word
installed though. There must be a more elegant solution... but I'm not
sure, I rarely need to integrate these features into databases.

D.
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.