Rabu, 28 September 2011

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
>

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar