[AccessD] Access to Word - colour an area

It's a fair point William, and one I was thinking about too. I'll have to
wait and see what if anything they want in terms of being able to easily
modify the print themselves. If it's pretty much set in stone I'd be good
with just Access, but if I have to go Word (which is what they currently
use) I'd just like to know I can do the colour thing.

Thanks for the input.
--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Access to Word - colour an area
Date: 16/03/07 15:20


....just a wag here Andy but if that were put to me I'd be thinking about
dumping Word and doing the entire thing as an Access report using Lebans rtf
control ...I've converted almost all of my client's Word mail merge docs to
Access reports this way ...takes a bit more work on your part but once the
forms are up, the clients love the things that can be done with a report
while retaining the ability to change text content and formatting.

William

----- Original Message -----
From: "Andy Lacey" <andy at minstersystems.co.uk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Friday, March 16, 2007 10:23 AM
Subject: Re: [AccessD] Access to Word - colour an area


> It's still a what-if at the moment. I'm going to see a potential client
> next
> week. He's described the project and this is a part of it. I'm just
> wanting
> to be forearmed.
> I suspect it's possible anything could be inside the box, most likely text
> and mailmerge entries, and all of it would want the coloured background.
> But
> could it be done in a generic way by, I dunno, putting bookmarks at top
> left
> and bottom-right of the area and selecting all between them, or something
> like that? OTOH I don't know how you set a bookmark as the bootom-right of
> an area.
> --
> Andy Lacey
> http://www.minstersystems.co.uk
>
>
>
> --------- Original Message --------
> From: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Access to Word - colour an area
> Date: 16/03/07 14:05
>
>
> On 3/16/07, Andy Lacey <andy at minstersystems.co.uk> wrote:
>> Hi all
>> If you have a Word doc, to be used as the master for a mailmerge, and an
>> area on it has a border round it, how would you (from Access) go about
>> filling that area a different colour depending upon a value on someone's
>> record? In its simplest form how would you use the Word object to
>> identify
> a
>> bordered area and give it a different colour?
>>
>> (Thinks - wonder if anyone will get this before Bryan. There's a
> challenge.)
>
> On my way to a 2 hour meeting, but I do have a couple of questions.....
>
> What is the area that is bordered? Text Box, Paragraph, table? Would
> the merge field be in the area to be coloured?
>
> I am assuming that you want to keep all your code in Access, correct?
>
> PS, since this is Mail Merge, you'll probably get a better answer from
> someone else, 'cause I don't use mm very often. Oh who's kidding who,
> I don't do much any more besides sit in meetings. <sigh>
>
> --
> Bryan Carbonnell - carbonnb at gmail.com
> Life's journey is not to arrive at the grave safely in a well
> preserved body, but rather to skid in sideways, totally worn out,
> shouting "What a great ride!"
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> ________________________________________________
> Message sent using UebiMiau 2.7.2
>
> --
> 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

________________________________________________
Message sent using UebiMiau 2.7.2