Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 11th, 2004, 03:47 PM
Registered User
 
Join Date: Feb 2004
Location: Guildford, Surrey, United Kingdom.
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Rich Text Box Controls In Access 2003

Hi All

I am using Microsoft Access 2003 and I have migrated my existing database from 2002. When working within the previous system I was able to succesfully use Microsoft Rich Textbox Control 6.0 (SP4), It now comes up with a message;

'Microsoft Access Dosen't Support this Active X control.':(

Some help in sorting this little problem would be nice

Simon
Reply With Quote
  #2 (permalink)  
Old March 11th, 2004, 08:20 PM
Authorized User
 
Join Date: Feb 2004
Location: Edmonton, Alberta, Canada.
Posts: 98
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Probably a dll version issue. There's a good chance you can find the error and explanation by searching the Microsoft knowledgebase but I haven't taken the time to do this. The solution may be as simple as reregistering the control's library with RegSvr32.

To avoid the dll hell, I never use the packaged controls. Ever. Mainly because I developed in an environment where Access was the only tool and security prevented install of any application or outside files and there was no possibility of getting authority to move any kind of dll or executable on to or off the systems. Would you believe locks in the floppy drives and on the cases so no one could add a drive? No authority to set the time or create a shortcut? I could go on.

I learned early on that you can harness the power of the built in Windows controls and I've never had a problem with a reference or library not working. I would suggest you take a look at the 'Older NON ActiveX solutions:' at:

http://www.lebans.com/richtext.htm

He has his own ActiveX newer versions as well but I tend to avoid them out of the habits developed in my earlier environments. One of his free Rich Edit textboxes may be worth a try if you can't find an answer by searching Microsoft's online resources.

Ciao
Jürgen Welz
Edmonton AB Canada
jwelz@hotmail.com
Reply With Quote
  #3 (permalink)  
Old April 15th, 2004, 10:57 PM
Registered User
 
Join Date: Apr 2004
Location: Beijing, , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I can't tell you exactly what causes this error, but I suspect someone is playing with the Registry, maybe a commercial RichText control vendor. Did you install a commercial RichTxt TRIAL control?
Anyway, the way I solved the problem was to UN-Register the ..\System32\RICHTX32.ocx version 6.0.88.4 (Latest? on my XP w/ Office 2003) control. Note that you may(?) have to stop several processes to UN-Register this control successfully.
Then when i RE-Registered it, ACCESS 2003 could use it without any messages or problems.
Good Luck, fred

Reply With Quote
  #4 (permalink)  
Old July 14th, 2004, 04:39 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Microsoft made a change in Office 2003 that prevents the use of the RichTextBox control. See KB Article 838010. Looks like there will be loads of broken code over this one!

Kevin Wornell

Reply With Quote
  #5 (permalink)  
Old July 14th, 2004, 04:41 PM
Registered User
 
Join Date: Jul 2004
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

A quick followup.

The RichTextBox 6 control will also cause issues if you apply SP3 to Office XP, again see the Microsoft propaganda at 838010 in the Knowledgebase.

Kevin Wornell

Reply With Quote
  #6 (permalink)  
Old August 8th, 2004, 11:16 PM
Authorized User
 
Join Date: Jun 2004
Location: Los Angeles, California, USA.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Try this to fix your ActiveX
http://www.access-programmers.co.uk/...ad.php?t=65363

and

Try this sample for your Rich Text Box Controls
http://www.dbforums.com/t997217.html
Reply With Quote
  #7 (permalink)  
Old December 7th, 2004, 11:12 PM
Registered User
 
Join Date: Dec 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Don't utilize the "solution" found at the http://www.dbforums.com/t997217.html link, unless you like having an email sent to the access db creator without your permission/knowing. Totally inappropriate and deceitful.

Reply With Quote
  #8 (permalink)  
Old January 14th, 2005, 09:16 PM
lil lil is offline
Registered User
 
Join Date: Jan 2005
Location: , , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here's the solution for you Access 2003 and some Access 2002/XP SP3 Users for using the RichTX32.OCX ActiveX control in your Access databases :)

This method will allow Internet Explorer to also use Richtx32.ocx which does open a security flaw to be opened up, but it's the choice you take. See the KB article at MS for more info on this.

To allow Access 2002 w/SP3 or 2003 to use this control, you need to edit the registry via regedit, find the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{3B7C8860-D78F-101B-B9B5-04021C009402}

This should be there, I am dead sure that RichTx32.ocx always takes the class ID of 3B7C8860-D78F-101B-B9B5-04021C009402

Within this key there should be a DWORD value called "Compatibility Flags".

If this is set to 0x400 (hexadecimal 400, decimal 1024) then change it to simply 0 (decimal or hex). You should now be able to insert the richtext control on your forms and use the control again as per usual in Access 2002 w/SP3 or Access 2003.

I tested this with IE 6 to check if it blocks it and Access 2003 and changing this registry key does indeed remove the block.

:)

Hope this helps.

Vicky (blueBase Design)
(lil@lilserenity.com - http://www.lilserenity.com)

Reply With Quote
  #9 (permalink)  
Old February 2nd, 2005, 03:39 AM
Registered User
 
Join Date: Feb 2005
Location: , , Denmark.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks to Vicky.

I changed the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{3B7C8860-D78F-101B-B9B5-04021C009402}
 and it works !!

How do I change this registry automaticaly? I like to have some code doing it for me?

/Romanov

Reply With Quote
  #10 (permalink)  
Old April 11th, 2007, 11:28 AM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The last message posted here was over a year ago..but in case anyone is still having to deal with this issue (which crops up periodically for me as Microsoft comes out with new security updates) I thought I'd post the following:

Creating the following .reg file will allow you to automatically clear the kill flag (as noted in Vicky's post) AND clear the entry that marks RichTx32.ocx as 'safe for scripting'. The latter change currently 'seems' to minimize the number of times I must 'un-kill' RichTx32.ocx by (perhaps) eliminating one of the security hole issues Microsoft has with this .ocx:

Fix_Richtx32.reg file
================================================== =======
Windows Registry Editor Version 5.00

[-HKEY_CLASSES_ROOT\CLSID\{3B7C8860-D78F-101B-B9B5-04021C009402}\Implemented Categories\{7DD95802-9882-11CF-9FA9-00AA006C42C4}] #this should be 'one' file line

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{3B7C8860-D78F-101B-B9B5-04021C009402}] #this should be 'one' line
"Compatibility Flags"=dword:00000000 #this should be on the next line

================================================== ===============================

If you create a .bat file you can edit the registry 'silently' (e.g. without having to answer the 'are you sure...' questions

Fix_Richtx32.bat file
================================================== ============================
regedit.exe /S "Fix_RichTx32.reg"
================================================== ============================

Put both files in the same folder then simply double-click the .bat file to make the changes in the registry.

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Rich Text Box aliirfan84 ASP.NET 2.0 Professional 1 February 23rd, 2007 05:35 AM
Rich Text Box spike010101 Pro VB 6 1 September 29th, 2004 02:37 AM
RICH TEXT BOX priyanka123 VB How-To 0 May 6th, 2004 01:46 PM
Printing from a rich text box snowy0 VB.NET 2002/2003 Basics 2 April 24th, 2004 10:04 AM



All times are GMT -4. The time now is 07:26 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.