Gustav Brock
gustav at cactus.dk
Wed Mar 17 03:04:49 CST 2004
Hi Terri OK, in that case it looks more like an Access-Word programming task where the clipboard-bookmark "trick" must be the last resort. I avoid Word if at all possible but other listers may be able to help you as it does require coding skills at some level. By the way, do you really need Word? Can't you create a report in Access? The FMS control should be able to be included in a report as well; if not - if the FMS control produces pure rtf - the Richtext ocx could be used. /gustav > 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