John Bartow
john at winhaven.net
Tue Mar 16 18:16:12 CST 2004
Terri, Have you discussed this issue on the FMS forums? John B. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Terri Jarus Sent: Tuesday, March 16, 2004 3:36 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] FMS Total Access Memo Question The Total Access Memo feature is a Wordpad clone for all intents and purposes. I probably misrepresented what they state in the FAQs, but what you have to do is copy the memo field to the Windows Clipboard and then paste from that to the bookmark in the Word document. The code for some of that is at this link: http://www.fmsinc.com/faqs/tamemo.htm#Clipboard Here's more info from their message board: "For the Bookmark trick, you can also copy the contents to the clipboard and work with an open object (the MS Word Document with bookmarks) directly. In other words, programamtically control the MS Word document by finding the bookmark and pasting the copied text directly into the bookmark instead of exporting to a file, then importing that file for the bookmark." My problem is that I don't know how to do this and could use an example if someone had one. I already have a Word template set up with bookmarks that is functional with the current memo fields that I want to change to TAM formatted fields, but my programming skills are minimal and I don't understand exactly how to approach this. I just don't ever get to spend very much time on database design and programming to develop a sound understanding of how things function. It's not my main job - it's my way of putting something together that is more efficient than what we currently have and our IS team does not believe in Access nor has the time to devote to developing applications that I need. Thanks for your response, if you can provide some further assistance - that would be great. Terri Jarus Director, Contract Support Services jarus at amerinet-gpo.com 314-542-1902 >>> gustav at cactus.dk 03/16/04 06:51AM >>> Hi Terri > There are a lot of memo fields that might need special formatting - > bolding, italics, bullets, etc. When I looked into using the > richtext ocx, you had to set up buttons for each formatting need. Yes, for a client I have Normal, Bold, Italic, and Underline - that's all they need. Of course, if you need more elaborate formatting you'll soon find yourself designing a WordPad clone. By the way, both the ocx and WordPad depends on the same richtex dll. > The issue would still be the same since the richtext feature is an > ActiveX control and that does not translate to Word - unless you can > tell me how to do that. There's nothing to do ... every memo field is an RTF document on its own and the control even has methods for reading and writing the content to a file. > That's FMS' pat answer - ActiveX controls don't translate over to Word. I don't know what FMS is talking about here. Again, there is nothing to translate - Word eats RTF files for lunch. /gustav > Terri Jarus > Director, Contract Support Services > jarus at amerinet-gpo.com > 314-542-1902 >>>> gustav at cactus.dk 03/16/04 05:43AM >>> > Hi Terri > Well, if all you need is some simple formatting, the MS richtext ocx will > do if you add some buttons and associated code. > /gustav >> Is anybody using this software? I purchased it a few weeks ago and I'm running into some issues of which I was unaware. >> My key reason for getting this software was to have the ability to format memo fields and then export them to Word. However, I was unaware of the difficulty in doing this. >> Is there some other 3rd party software that allows this functionality? >> Thanks for any hints, tips or advice. >> Terri Jarus >> Director, Contract Support Services >> jarus at amerinet-gpo.com >> 314-542-1902 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individuals or entities to whom they are addressed. If you have received this email in error please return it to the sender, and erase any copies thereof. Copyright 2004 Amerinet 1nc. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com