using Word inside Access?

[ivan]

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?

[Dale Green]

Re: using Word inside Access?


"ivan" <info@achieva.u s> wrote in message
news:bHj5b.1418 13$yg.39884063@ news4.srv.hcvln y.cv.net...[color=blue]
> Trying to figure out the best way to accomplish this...[/color]

Why not just use the MS Rich Text control or do you need more functionality
than it offers?

[ivan]

Re: using Word inside Access?

How do you use the rich text control?

"Dale Green" <bitbucket@home .com> wrote in message
news:59213b3622 68fad1da63158e2 4cdf6c7@grapevi ne.islandnet.co m...[color=blue]
>
> "ivan" <info@achieva.u s> wrote in message
> news:bHj5b.1418 13$yg.39884063@ news4.srv.hcvln y.cv.net...[color=green]
> > Trying to figure out the best way to accomplish this...[/color]
>
> Why not just use the MS Rich Text control or do you need more[/color]
functionality[color=blue]
> than it offers?
>
>[/color]

[ivan]

Re: using Word inside Access?

How do you use the rich text control?

"Dale Green" <bitbucket@home .com> wrote in message
news:59213b3622 68fad1da63158e2 4cdf6c7@grapevi ne.islandnet.co m...[color=blue]
>
> "ivan" <info@achieva.u s> wrote in message
> news:bHj5b.1418 13$yg.39884063@ news4.srv.hcvln y.cv.net...[color=green]
> > Trying to figure out the best way to accomplish this...[/color]
>
> Why not just use the MS Rich Text control or do you need more[/color]
functionality[color=blue]
> than it offers?
>
>[/color]

[ivan]

Re: using Word inside Access?

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" <bitbucket@home .com> wrote in message
news:46351ae9f3 0bc9e12df2396cf 4faf6fa@grapevi ne.islandnet.co m...[color=blue]
>
> "ivan" <info@achieva.u s> wrote in message
> news:GRy5b.475$ Ay2.169800@news 4.srv.hcvlny.cv .net...[color=green]
> > How do you use the rich text control?
> >[/color]
>
> 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(Ca ncel As Integer)
> rtfPurchaseOrde r.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.
>
>
>[/color]

[Dale Green]

Re: using Word inside Access?


"ivan" <info@achieva.u s> wrote in message
news:UFF5b.1541 6$Ay2.1395814@n ews4.srv.hcvlny .cv.net...[color=blue]
> 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?[/color]

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.