NeoSoft Support Forum

[The Not Man]

That would be great to have a way to put a background color for a row in DBPro.

I know that by default there is a row bkg color and alternate row bkg color, Which is woking properly. But I would need the option to be able to set a bkg color of my choice depending of a status.

Example: A field that the status is New, then the color should be red for urgent. Blue for processed. Orange for callback and white for close.

That could be pretty cool!

[Neosoft Support]

I'm not sure if it's possible, but I will add it to the list of things to consider.
_________________
NeoSoft Support

[The Not Man]

Thank you!

[fieldhopper]

Well, i need this function too. When can it be used ?
_________________
Regards fieldhopper

____________________________________________________
Es sind schon viele erfroren, aber noch keiner ist ermieft.
____________________________________________________

[Wrangler]

I would imagine it can be used when and if it is done.

There are other ways to do this. One would be to draw a rectangle around the grid, and change the border color accordingly. Or, you can locate an icon near the grid that changes as required. Or a text box somewhere would work. Even a popup box. Or an audio file announcing it.

Yes, it would be nice to have this feature built-in, but I wouldn't consider it a "need". It's just eye candy.
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[beno]

Hi,

Another approach can be achieved creating a customized grid in a WebBrowser Object. Your imagination would be the limit.

My cent,

beno
_________________
---------
http://www.benitoestrada.net

[fieldhopper]

Ok, that are some ways to generate eyecatcher, but that is not the way for my custom. This is a wish of mine and i need it for my veterinary surgeon software and it is a proposal of the custom.
So it would be nice to realize this function asap.
_________________
Regards fieldhopper

____________________________________________________
Es sind schon viele erfroren, aber noch keiner ist ermieft.
____________________________________________________

[Neosoft Support]

How would you envision this feature would work? How would the grid know which cells to highlight?
_________________
NeoSoft Support

[fieldhopper]

How to work ?

If a column have a particularly contents like my program contains '1-U' in the first column , the row may be red. the first column can change in dependence of the contents and so the color will change.

Hope you understand my wish, cause my english is not the best.
_________________
Regards fieldhopper

____________________________________________________
Es sind schon viele erfroren, aber noch keiner ist ermieft.
____________________________________________________

[The Not Man]

Hi all,

I finally find out how I could do this!

In my access database I added a field "GRAPH" to my table, and set it up as Object OLE.

I created 6 different color buttons (bitmap file). With the exact name as the field dropdown list.

EX: Red color button name is New.bmp. Green color button name is Retry.bmp etc...
My Droplist contain New,Retry,Failed,Waiting,Completed,Closed

So what I am doing is that each time that someone change the status in the status field, They it the refresh push button and execute a subroutine that check the name of the field status and copy the exact name with extension bmp and then refresh the database. :

:Indice
. write name of field status to graph field in current query.
. doing a loop from record 1 to toatl of record found depending of the query
Loop "1" "[ACD.Retry.$RecCount]" "[LN]"
dbpGotoRecord "ACD" "Retry" "[LN]"
SetVar "[ACD.Retry.GRAPH]" "![ACD.Retry.STATUS].bmp"
EndLoop
dbpFirst "ACD" "Retry"
dbpRefresh "ACD" "Retry"
Return

This is my way of doing it since we cannot execute anything when a field is edited. Finally, it would be very good to have action options like the push button "On change" on a field edited in the grid

Again, hoping that this can help anyone. Meantime, I will wait to see if this can be done in the next dbpro version

[fieldhopper]

A field in a database can't be an option.

_________________
Regards fieldhopper

____________________________________________________
Es sind schon viele erfroren, aber noch keiner ist ermieft.
____________________________________________________

[Wrangler]

The Not Man: Did you try specifying the subroutine as an onchange subroutine when you open the table?
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[Wrangler]

fieldhopper: Why is adding a field not an option? It can be done on the fly with dbpaddfield.
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com

[fieldhopper]

It is a commercial software and is straight in the use.
_________________
Regards fieldhopper

____________________________________________________
Es sind schon viele erfroren, aber noch keiner ist ermieft.
____________________________________________________

[Wrangler]

I see. Can it be upgraded? What I do in that situation is issue an upgrade that checks for the field in startup and adds it if it isn't found.
_________________
Wrangler
--------------
Before you criticize someone, walk a mile in their shoes. Then when you criticize them you're a mile away and you have their shoes. - Wrangler

Software made with NeoBook
http://highdesertsoftware.com