A.D.:
That could also work, would introduce the need for a separate, single record, form to edit/add/delete data, but not huge issue. I may resort to that if I have no luck going with the attachment route
Thanx
Walter Griffin
--- In MS_Access_Professionals@yahoogroups.com, "A.D. Tejpal" <adtp@...> wrote:
>
> Walter,
>
> One way of realizing your objective could be to use a simulated continuous form with multiple rows (say 12) of unbound controls. With such an arrangements you can display unlimited number of color strips row-wise.
>
> Best wishes,
> A.D. Tejpal
> ------------
>
> ----- Original Message -----
> From: John Viescas
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, September 28, 2011 11:58
> Subject: RE: [MS_AccessPros] Following the color change thread
>
>
> 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)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> Sent: Wednesday, September 28, 2011 4:09 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: 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
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar