SynapseDirect

Should I have done the rich text thing before populating the database (ie. before linking the tables) ?

Should I retry all these steps on your original synapse.mdb  ?

Jason, don't change the property of the field of the source database.

Click the button "Property Sheet" while highlighting the Rich Texbox control.  Under "Data" tab, first item "Control Source", select "CONSULT".  Then go back to form view, you should see the correct format now.

Warning: DO NOT attempt to modify the data in this box, use this for viewing purpose only - Under the same "Data" tab, changed "Locked" to "Yes".  If you type in this box, the Rich Textbox Control will add codes to the original data and mess up your data.  Rich Textbox Control and Blob are not completely compatible with each other.

qilin:

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.

I start to get the same problem in the office too, it tends to happen more on the list view but not on the preview form view.  Need a real MS Access guru to debug this I guess.  Otherwise, I will have to live with this.

I messed up.

Jason:

I messed up.

Indeed.  Open form "frmVisits", replace the big fat plain text box with a Rich Textbox. 

qilin:

Indeed.  Open form "frmVisits", replace the big fat plain text box with a Rich Textbox. 

Ahhh .. I get it now  :)

Rich Text looks good. !!!

I am going to start over again though.

I must messed a few things up.   

Jason:

Ahhh .. I get it now  :)

Rich Text looks good. !!!

Glad it finally worked for you. Now you can use the same method to populate demographic info to your forms I guess.  You don't even need to create a query for this if all you need is demographics, you can just use the table "USERS".  My patient list view lists all the visits.  You can modify this form, change the datasource of the subform to table "USERS" so it will only list the patients, and modify the mailmerge VBA codes accordingly.

Thanks . I've obviously lost all my Office Suite skills !  (I appreciate your patience).

I think that Access/Office could provide an interesting alternative "VIEW" of Synapse patient data.

Firebird and Synapse do the hard work and Office just leeches off the hard work and puts a pretty face on the data presentation  :)

(best of both worlds).

Rich Text in full glory :)

Jason:

Firebird and Synapse do the hard work and Office just leeches off the hard work and puts a pretty face on the data presentation  :)

(best of both worlds).

Well put.  We are having a good start.  A lot can be done with this combination.

I used one of my old database file to do this and didn't change all the buttons, the code of that exit button was to shut down the databae. You can just delete it from design view, no use of this button here.

Question for Graham: do you think you can provide your database structural/relationship information?  I can guess many of them by looking at the field names and values, but whould be easier if this is available.

the schema is currently undocumented .. if you can't guess a field, ask me...

qilin:

Question for Graham: do you think you can provide your database structural/relationship information?  I can guess many of them by looking at the field names and values, but would be easier if this is available.

Can't IBOconsole or something of that ilk generate a relationship structure ?

Jason:

Rich Text in full glory :)

Would be better if the Rich Textbox control is fully compatible with Blob field, meaning you can also edit.  Maybe there is a third party one out there, we haven't looked hard enough.