[AccessD] FMS Total Access Memo Question

Terri Jarus jarus at amerinet-gpo.com
Wed Mar 17 06:24:27 CST 2004


It's come up several times on the FMS forum and the answer from FMS is always the same.  I would assume these users got it worked out but no one answered my post in the forum when I asked for some specific examples.
 
Terri Jarus
Director, Contract Support Services
jarus at amerinet-gpo.com
314-542-1902

>>> john at winhaven.net 03/16/04 06:16PM >>>
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 



-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 





More information about the AccessD mailing list