using Word inside Access? - Microsoft Access / VBA

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?

Nov 12 '05 #1

Subscribe Reply

4307

Dale Green

"ivan" <in**@achieva.u s> wrote in message
news:bH******** **************@ news4.srv.hcvln y.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

ivan

How do you use the rich text control?

"Dale Green" <bi*******@home .com> wrote in message
news:59******** *************** *******@grapevi ne.islandnet.co m...

"ivan" <in**@achieva.u s> wrote in message
news:bH******** **************@ news4.srv.hcvln y.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

ivan

How do you use the rich text control?

"Dale Green" <bi*******@home .com> wrote in message
news:59******** *************** *******@grapevi ne.islandnet.co m...

"ivan" <in**@achieva.u s> wrote in message
news:bH******** **************@ news4.srv.hcvln y.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

ivan

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******** *************** *******@grapevi ne.islandnet.co m...

"ivan" <in**@achieva.u s> wrote in message
news:GR******** **********@news 4.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(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.

Nov 12 '05 #5

Dale Green

"ivan" <in**@achieva.u s> wrote in message
news:UF******** *************@n ews4.srv.hcvlny .cv.net...

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

Similar topics

6560

Modifying a Word document without using Word Automation

by: Michael G. Schneider | last post by:

I know that using Word Automation inside an ASP page is no good idea. Anything I want to do in the current project is: open document, change some text, save and close document. Basically changing some variables, consting of a name embraced by special chars, to some value. As for example: change "" to "Michael". Does anybody know whether there is a way for achieving this with basic "file input / output". Can I regard a Word document as...

ASP / Active Server Pages

20341

Using setInterval inside an object

by: Daniel | last post by:

Hello =) I have an object which contains a method that should execute every x ms. I can use setInterval inside the object construct like this - self.setInterval('ObjectName.methodName()', this.pinginterval); - but is there no way to do this without using the literal ObjectName? If I write 'this.methodName()' I get "Line 1 Char 1: Object doesn't support this property or method." in IE, and nothing happens in Firebird.

Javascript

7758

Printing a Word Document from ACCESS

by: Jeff Harbin | last post by:

I've got an ACCESS 2000 application that I'm developing. One of the outputs of this app will be to generate a series of 'jobs' which corresponds to a record in the database. Each record will be printed on its own page which I've set up as a report and that's working fine. Accompanying each job is a Word (or Excel) document. Most jobs will have Word (or Excel) documents unique to the record. I know how to establish a hyperlink field...

Microsoft Access / VBA

1563

word dude...

by: Juan Antonio | last post by:

Hi to the forum... I have this code that allows to me the access to the text of each paragraph, in a word document: foreach Word.Paragraph x in myapp.ActiveDocument.Paragraphs { MessageBox.Show("this is the paragraph="+x.Range.Text); }

C# / C Sharp

2507

Web User Control and using session, request and response

by: George G. | last post by:

Hi there, I am busy writing a new asp.net application and I am reusing some of my existing asp functions and methods in a user control. I need access to session, request and response in some of the functions and I can't find out how to do it. Here is an example of what I do and I get the following Cannot refer to an instance member of a class from within a shared method or shared member initializer without an explicit instance of the...

ASP.NET

1863

Using LIKE to perform a database match

by: Nathan Sokalski | last post by:

I am trying to do a database search using LIKE using the following code: Private Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click If Page.IsValid Then Dim logictype As String

ASP.NET

2931

From Word Document to Memo field

by: rlntemp-gns | last post by:

Re: Access 2003/Word 2003 I have about 100 motivational documents that I am wanting to import into a small database and put a front end on it that would allow the user to select one, read it and print it. Some of these original documents have bold formatting, a picture, and some italics. To try and preserve the original formatting would it be better to reference the actual Word document object on the hard drive and

Microsoft Access / VBA

2589

Python Feature Request: Add the "using" keyword which works like "with" in Visual Basic

by: samjnaa | last post by:

Please check for sanity and approve for posting at python-dev. In Visual Basic there is the keyword "with" which allows an object- name to be declared as governing the following statements. For example: with quitCommandButton .enabled = true .default = true end with

Python

1328

Using vectors is a class

by: jimv1983 | last post by:

I have a class that takes a vector. I want to create a new instance of a class. The Word class has a vector and I want to assign the incoming vector to the vector in the class so i can have access to the vector inside the class. My constructor looks like this: Word::Word(string word, string out,vector<string>& dict,vector<string>& final, int numHops) in the private of my class i have

C / C++

9522

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9336

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10111

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9948

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9902

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9765

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7327

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6603

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5215

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration