Walter-
I assume you have a set number of colors that can be assigned. If that's the
case, build separate GIF or JPG files that are a "blob" of each color, create a
table with the color code, and a text field that points to the picture file on
your hard drive. Join your base table with the color code table on the color
code, then use an Image control bound to the text field to display the correct
color.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
Sent: Wednesday, September 28, 2011 5:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Following the color change thread
Tim;
You know, that might work, build a table with an ID and a image control (OLE
doesn't seem to want to work reliably on my system with 2010 on it so I'm stuck
with an attachment type :-P) Just have to figure out how to build the color
image file in code and associate it with the "train" record. Or add an
attachment directly to the "Train" record and forget the linked table? Might get
complicated to change the value tho. May be over my head, too, Ain't no pro at
this!
Tim, your close, I'm in Pleasant Lake
Walter Griffin
--- In MS_Access_Professionals@yahoogroups.com, "juiceplustim" <tritter@...>
wrote:
>
> Learning some interesting depth about continuous forms, since I use those
frequently and am always looking for good layout ideas. This is always a pain,
but thanks to John below - I see more clearly why.
>
> Here's something that may (MAY) be worth a try. If you are storing the color
choice in the record, why not have a related table with 2 fields. One for the
color choice code number, and the other field storing an image of a simple line,
bar, or rectangle in the color you want with that code (whatever shape, size
works for your specific form). Then match that color image table to your record
source for the form and just display the linked image behind whatever part of
each record you want. Those types of images as a GIF are very small, and
shouldn't add much to the load time of the form for even a large set of records.
>
> Anyone see why that couldn't work? I don't have anything right now that I
would need to try it out on, but would love to know if that's a good work
around.
>
> Tim Ritter
> Fort Wayne, IN
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > Walter-
> >
> > It works in the report because the report formats each record one at a time.
It
> > would also work in Single Form view, but it doesn't work in Continuous form
view
> > because there is really only one copy of each control. You see multiple
rows
> > because Access "paints" all but the current row, and it honors Conditional
> > Formatting as it's doing the "painting." There is no event associated with
> > "painting" each row in a form like there is in a report (On Format).
> >
> > John Viescas, author
> > Microsoft Office Access 2010 Inside Out
> > Microsoft Office Access 2007 Inside Out
> > Building Microsoft Access Applications
> > Microsoft Office Access 2003 Inside Out
> > SQL Queries for Mere Mortals
> > http://www.viescas.com/
> > (Paris, France)
> >
> >
>
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar