John;
That may be the best(chickens)way out. I'll have to generate a "Pick a canned color" form with a warning if they choose the same color more than once.
Off to the multi-colored brick road :-)
Walter Griffin
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> Maybe pick 64 nice unique colors. By using the color picker, you're being a bit
> too user-friendly! Note that the user *could* pick two colors only one color
> number apart in the color picker. The numbers would be unique in the table, but
> would appear virtually the same on the screen. Better to give the users a
> selection of enough different "canned" colors.
>
> 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 8:58 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Following the color change thread
>
> John;
>
> Actually no, I'm using a color picker control and the user can generate
> something like 16000000 colors.
> When I originally set up the "trains" table and form I made a dozen or so "color
> swatch" files and realized some users may need a LOT more than that (certainly
> not 16 million! but 50 or 60 would not be out of the question)
> After that I thought to "automate" the color choices with the color picker and
> now I can't format the form the way I would like, That's what I get for
> thinking!
> I may have to revert to the original plan (with a lot more choices than before)
> if I can't figure out how to generate them on the "fly".
>
> Walter Griffin
>
> --- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@> wrote:
> >
> > 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
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Tidak ada komentar:
Posting Komentar