Jayalakshmi
May 11th, 2000, 12:07 AM
Hi,
We are a group of two developers currently working on Visual Basic 6.0
with MS-Access 2000 as the back-end.
We are currently involved in a educational project in which the Access database
stores questions(in a Memo type of field in Access) pertaining to different subjects like
Physics, Mathematics etc.
The questions are entered through a VB form into a richtextbox which then gets
updated in the database as a memo field.
The questions are stored in the database table as richtext symbols as shown below:
So when a picture(i.e. containing a graph etc.) or a chemical equation is saved through
the richtextbox of VB into the database, this is the following format in which it gets
saved in the Access table.
"{\rtf1\ansi\deff0\deftab720{\fonttbl{\f0\fswiss MS Sans Serif;}{\f1\froman\fcharset2
Symbol;}{\f2\froman\fprq2 Times New Roman;}{\f3\fswiss MS Sans Serif;}}
{\colortbl\red0\green0\blue0;}
\deflang1033\pard\plain\f2\fs24\i The earth originated about\plain\f3\fs17
\par }
"
The issue is that we are UNABLE to create a report containing the questions using
DataReport
of VB as it does not support richtext control. Image controls of Datareport too don't work!!!
Creating a report in Access containing richtextbox ActiveX control also does not work.
This is a issue confirmed by Microsoft and the workaround for the Access report has
been provided by a company FMS Inc.. But their package is a trial version only!!
So could u please help us out 'coz this is posing a major problem to us as the end-users
(in our case , students) need to see the subject questions in a report format!!
RTF readers were also not of much help.
Help pleeeeeeeeaaaaaaassssssssseeeeeeee!!!!!!!!
Its urgent!!
U could please get back to us for any further clarification on this issue!!!
either on this site or to our personal e-mail ids:
mh_jaya@usa.net
manjula_rani@usa.net
Thanx,
Expecting a solution,
Jaya & Manju
We are a group of two developers currently working on Visual Basic 6.0
with MS-Access 2000 as the back-end.
We are currently involved in a educational project in which the Access database
stores questions(in a Memo type of field in Access) pertaining to different subjects like
Physics, Mathematics etc.
The questions are entered through a VB form into a richtextbox which then gets
updated in the database as a memo field.
The questions are stored in the database table as richtext symbols as shown below:
So when a picture(i.e. containing a graph etc.) or a chemical equation is saved through
the richtextbox of VB into the database, this is the following format in which it gets
saved in the Access table.
"{\rtf1\ansi\deff0\deftab720{\fonttbl{\f0\fswiss MS Sans Serif;}{\f1\froman\fcharset2
Symbol;}{\f2\froman\fprq2 Times New Roman;}{\f3\fswiss MS Sans Serif;}}
{\colortbl\red0\green0\blue0;}
\deflang1033\pard\plain\f2\fs24\i The earth originated about\plain\f3\fs17
\par }
"
The issue is that we are UNABLE to create a report containing the questions using
DataReport
of VB as it does not support richtext control. Image controls of Datareport too don't work!!!
Creating a report in Access containing richtextbox ActiveX control also does not work.
This is a issue confirmed by Microsoft and the workaround for the Access report has
been provided by a company FMS Inc.. But their package is a trial version only!!
So could u please help us out 'coz this is posing a major problem to us as the end-users
(in our case , students) need to see the subject questions in a report format!!
RTF readers were also not of much help.
Help pleeeeeeeeaaaaaaassssssssseeeeeeee!!!!!!!!
Its urgent!!
U could please get back to us for any further clarification on this issue!!!
either on this site or to our personal e-mail ids:
mh_jaya@usa.net
manjula_rani@usa.net
Thanx,
Expecting a solution,
Jaya & Manju