Re: Change ROW colors in a grid.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes you are correct. I have been doing that but my problem comes when
I select one of the records from the cursor and modify that record I
have to remember where the record came from in the original database
so that I can put the record back in the correct record. I want to get
rid of the housekeeping that I am going through to keep track of it.
Just using the filtered table, picking out the record, modifying it
and putting it back eliminates all the record tracking.
Thanks
Tony

"Dave Tiffany" <dtiffany@xxxxxxxxxx> wrote in message
news:%23nxlg5zHHHA.536@xxxxxxxxxxxxxxxxxxxxxxx
TonySper,

Generally speaking, using a filtered table to populate a grid is a bad
idea. A view or a cursor will perform better and solve your even odd
problem. Be sure to use the "Nofilter" clause if you use a cursor.

select * from tblA where tblA.field1="ABC" into cursor XYZ nofilter.

David Tiffany

TonySper wrote:
I can change the colors of a row in a grid or browse screen by using
the record number odd or even so that ever other row is a different
color but when I do a filter to the table and then look at the
screen
the colors are not ever other row. Is there a way to change the
color
by counting the rows or something?? I do not want to append them to
another table or create another table if possible. Any ideas would
be
welcomed?
TonySper






.

Relevant Pages

  • Re: Change ROW colors in a grid.
    ... I select one of the records from the cursor and modify that record ... Be sure to use the "Nofilter" clause if you use a cursor. ... the record number odd or even so that ever other row is a ... color but when I do a filter to the table and then look at the ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Change ROW colors in a grid.
    ... I select one of the records from the cursor and modify that record I ... the record number odd or even so that ever other row is a different ... color but when I do a filter to the table and then look at the ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Change ROW colors in a grid.
    ... using a filtered table to populate a grid is a bad idea. ... A view or a cursor will perform better and solve your even odd problem. ... the record number odd or even so that ever other row is a different color but when I do a filter to the table and then look at the screen the colors are not ever other row. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Change ROW colors in a grid.
    ... TonySper wrote: ... I select one of the records from the cursor and modify that record I ... color but when I do a filter to the table and then look at the ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Selstart and cursor position
    ... I am trying to prevent the cursor from appearing at the beginning of the ... fires the after_update code to filter the data in a continuos form. ... cursor at the beginning of it, rather than the next textbox. ... All the filter code works correctly (filtering data dependant on 3 text ...
    (microsoft.public.access.formscoding)