ACCESS FEED: Re: [MS_AccessPros] Following the color change thread

Selasa, 27 September 2011

Re: [MS_AccessPros] Following the color change thread

Hi John;

It has a different color code for each record, each record represents a train ( back to the model RR thing) and the color is printed on a bar at the top of a "waybill" report attached to each freight car as a visual aid in assembling a train in the classification yard by the yard master/operator. The color bar prints OK on the reports because I can use the "on format" event in the report, but a 5 to 8 digit number in the "Define Trains" form is meaningless. I use a color picker control to assign the number to the field in question.
I played with this before but got bogged down and decided to move on and return when I felt more ambitious ;-)

Walter Griffin

--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> Walter-
>
> No can do. If this were a single form view, you could use the Current event to
> pick up the color code and assign it. How many different color codes do you
> have, and why is it stored in the table?
>
> 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: Tuesday, September 27, 2011 7:47 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Following the color change thread
>
> Hi Group;
> I followed along on the color change field thread and tried the conditional
> format thing on a form of mine I have that displays a decimal number value of a
> color in a bound textbox on a continuous form the number is really meaningless
> tot he user so I want to show the color,I set the background to "Normal" and I
> tried this
> [txtRecordColor.BackColor]=[txtRecordColor] from the conditional format wiz in
> 2010, No joy!
> Tried this also
> [txtRecordColor.BackColor]=hex([txtRecordColor])
> just in case, also no joy!
> What am I doing wrong?
>
> Walter Griffin
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>