SynapseDirect

I have found ways to use Microsoft Rich Textbox control in MS Access version 2003 and 2007 thanks to the help of my programmer friend.  Blob field will have correct display in all these versions. 

Steps to do this in 2007:
1. copy richtx32.ocx to windows\system32 folder if you don't have one.
2. go to visual basic window, tools - references - browse button and add richtx32.ocx file
3. open regedit, go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compability\{3B7C8860-D78F-101B-B9B5-04021C009402}
double click "Compatibility Flags", change value to 1
4. Close regedit and restart MS Access, you should be able to see this control listed in "Insert ActiveX Control" from form design view.  Add this control and link to "CONSULT" Blob field.  Go back to form view.  You should see all the text format corretly displayed.
The above GUID for this control is the same for 2002 and 2003, I assume you should have the same key, If you can't find this register key, I will tell you how to look for it.

For 2003, the file should already be in system32 folder. If it's not registered, you need to go to menu "tools - ActiveX Controls - Register button" to register it.  Then follow the same Steps 3-4 as above.

Jason:

qilin:

I can put a button on all other forms to go back to the list view

Is there another way ? (Manually).

Sure, Click the big Office button on the right upper corner, click "Access Options" on the bottom, under Current Database, check "Display Navigation Pane" under Navigation.

You should have a navigation pane now on the left side of your window, you can navigate to different tables, forms etc.

Screenshot for regedit mentioned above. Courtesy of my helpful programmer friend.

Jason:

If I keep generating different word documents, I eventually get this.

Not sure why.  Are you using this in office or home LAN or remotely?  If this happened only remotely, I am not too concerned since I don't plan to use it remotely in the future for security reason as Graham pointed out why.

qilin:

1. copy richtx32.ocx to windows\system32 folder if you don't have one.

I did this a while back when I was having richtx32.ocx errors.  Maybe I have the wrong version ? 

2. go to visual basic window, tools - references - browse button and add richtx32.ocx file

Done. 

3. open regedit, go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compability\{3B7C8860-D78F-101B-B9B5-04021C009402}
double click "Compatibility Flags", change value to 1

Hexadecimal or Decimal ?

4. Close regedit and restart MS Access, you should be able to see this control listed in "Insert ActiveX Control" from form design view.

What is the name, I don't see it in the List. 

Add this control and link to "CONSULT" Blob field.  Go back to form view. 

Lost me.

The above GUID for this control is the same for 2002 and 2003

Same for 2007. 

For 2003, the file should already be in system32 folder. If it's not registered, you need to go to menu "tools - ActiveX Controls - Register button" to register it.

Maybe that is what I need to do, I can't find it in 2007.

Rich Text Would be nice  :)

Hexadecimal or Decimal ?

Hexadecimal

4. Close regedit and restart MS Access, you should be able to see this control listed in "Insert ActiveX Control" from form design view.

What is the name, I don't see it in the List.

Microsoft Rich Textbox control 6.0.  When you click "insert ActiveX control" button, you will see a long list, you should be able to find this name for you to select.  Then you can draw a Rich Text box in your form.

The Search Patient via Last Name is Case sensitive.  Not a reliable method.

I noticed.  I need to figure out why it does so in 2007.  It's not case sensitive in 2002 and 2003

Do you prefer Access 2003 ?

The only thing I really need in Office 2007 is OneNote.

Outlook 2007 integration in OneNote 2007 is a bonus.

What are you going to use ?

When I click the ActiveX icon ... I get this list .. there is no Microsoft Rich Textbox control 6.0.

Despite (as above) it was listed as an available reference.

I am hoping to be able to place text (demographic data) on "an image of my typical forms".  Graham did a custom version of my Lab Form (which I LOVE) but an easier (end user) solution for populating demographic data on forms is needed.

One thing that could be neat is that I could INK on Word documents easily.

I could populate a referral form with patient information and HPI and then INK some details as needed.

Forinstance, I'd like to fill this form out. (see attached image below)

Workflow:

(1) Populate the patient demographics onto the Form.  (2) Ink some clinical information / Sign it  (3) Fax to the Radiology Office or Print to my Secretary's printer.

I guess the only saving here is populating the Form (not that much).  Other Problems: where would the filled out form be stored ?   I guess you could manually save it to the patient's folder.  

Wait, you should be able to write some code to auto save it to the patient's folder because you know the patient's name !  (thus you know their folder name !).

Probably would be best to save it to a sub directory called \forms\ because I am unlikely to ever want to see the Requisition again.

Sometimes we have to FAX and print a copy for the patient.

Interesting. 

Jason:

When I click the ActiveX icon ... I get this list .. there is no Microsoft Rich Textbox control 6.0.

Despite (as above) it was listed as an available reference.

Did you do this step?

2. go to visual basic window, tools - references - browse button and add richtx32.ocx file

Even though it's listed, you still need to register it using the browse button and point to the correct file.  After I did that, the control showed up on the list.  You may need to restart Access.

I will be using 2003, just for convenience since our EMG machine comes with this version.  I still need to play with the 2007 to get familiar with it.  The problem is I installed 2007 on x64 system and I can't use a lot of programs including paperport, firebird ODBC, etc.

qilin:

Jason:

When I click the ActiveX icon ... I get this list .. there is no Microsoft Rich Textbox control 6.0.

Despite (as above) it was listed as an available reference.

Did you do this step?

2. go to visual basic window, tools - references - browse button and add richtx32.ocx file

Yea I did.

I downloaded a "NEW" richrx32.ocx from this site:

http://www.aislebyaisle.com/help.htm 

and now the forms shows it

Jason:

Add this control and link to "CONSULT" Blob field.  Go back to form view. 

Lost me.

I added the Rich Text Control to the form (see. jpg)

How do link the Rich Text Control to the BLOB Field ? 

Might have found it

:) 

Problem ..