Images in Tables/Listboxes

[Ima Loozer]

OK folks I'll try to explain my objective as clearly as I can... Might
be hard...
I want a list box on one of my forms. List box will have the persons
name in column 0. Next three columns will be blank (white) or the
designated color for that column based on a true/false condition. These
will be used as flags to indicate whether the person in that row of the
list box has one or more of the three possible certifications. So that
column 1 might be flag someone as having CPR training. If they do not
have training I want the column blank, if they do lets say we want it
green. Next might be fire training and blank of not trained, red if
trained. We might eventually have up to 6 columns however that (at this
point) is irrelevant.

In the table where the people are listed, I have Yes/No fields for each
of the certifications. I am thinking of something along these lines (if
it is possible). Store a small gif of each color in a table, and
identify each color to a given certification. Then when building the
query that populate the list box, if the given flag is false populate
that field of the query with the white gif, otherwise populate it with
the gif if the appropriate color.

Any suggestion, ideas, hints, etc?

[Tom van Stiphout]

On Thu, 14 Sep 2006 20:46:52 -0400, Ima Loozer
<no****@EyeDontWantSpam.foowrote:

No graphics in a standard listbox. Keep it simple, and use Y and N
(or X and <blankcharacters.

-Tom.

>OK folks I'll try to explain my objective as clearly as I can... Might
be hard...
I want a list box on one of my forms. List box will have the persons
name in column 0. Next three columns will be blank (white) or the
designated color for that column based on a true/false condition. These
will be used as flags to indicate whether the person in that row of the
list box has one or more of the three possible certifications. So that
column 1 might be flag someone as having CPR training. If they do not
have training I want the column blank, if they do lets say we want it
green. Next might be fire training and blank of not trained, red if
trained. We might eventually have up to 6 columns however that (at this
point) is irrelevant.

In the table where the people are listed, I have Yes/No fields for each
of the certifications. I am thinking of something along these lines (if
it is possible). Store a small gif of each color in a table, and
identify each color to a given certification. Then when building the
query that populate the list box, if the given flag is false populate
that field of the query with the white gif, otherwise populate it with
the gif if the appropriate color.

Any suggestion, ideas, hints, etc?

[Ima Loozer]

In article <92********************************@4ax.com>, no.spam.tom7744
@cox.net says...

On Thu, 14 Sep 2006 20:46:52 -0400, Ima Loozer
<no****@EyeDontWantSpam.foowrote:

No graphics in a standard listbox. Keep it simple, and use Y and N
(or X and <blankcharacters.

-Tom.

OK folks I'll try to explain my objective as clearly as I can... Might
be hard...
I want a list box on one of my forms. List box will have the persons
name in column 0. Next three columns will be blank (white) or the
designated color for that column based on a true/false condition. These
will be used as flags to indicate whether the person in that row of the
list box has one or more of the three possible certifications. So that
column 1 might be flag someone as having CPR training. If they do not
have training I want the column blank, if they do lets say we want it
green. Next might be fire training and blank of not trained, red if
trained. We might eventually have up to 6 columns however that (at this
point) is irrelevant.

In the table where the people are listed, I have Yes/No fields for each
of the certifications. I am thinking of something along these lines (if
it is possible). Store a small gif of each color in a table, and
identify each color to a given certification. Then when building the
query that populate the list box, if the given flag is false populate
that field of the query with the white gif, otherwise populate it with
the gif if the appropriate color.

Any suggestion, ideas, hints, etc?

If I COULD use Y/N I would. You should keep it simple and read what the
requirements are.

[pietlinden]

If I COULD use Y/N I would. You should keep it simple and read what the

requirements are.

You're right. You really are a loser. Biting the hands that feed you
is no way to get help. If you're smart enough to be a smartass, you're
probably smart enough to create a subclassed control to do what you
want. So have at it.

[Ima Loozer]

In article <11**********************@i42g2000cwa.googlegroups .com>,
pi********@hotmail.com says...

If I COULD use Y/N I would. You should keep it simple and read what the
requirements are.

You're right. You really are a loser. Biting the hands that feed you
is no way to get help. If you're smart enough to be a smartass, you're
probably smart enough to create a subclassed control to do what you
want. So have at it.

If the hand indeed fed me I would have been appreciative of the reply.
However since it was a smart ass reply with no assistance what-so-ever I
replied in kind.

[pietlinden]

so crack open VB6, extend the listbox control to do what you want,
compile it into your own DLL, register it, and use it in your app.
What's so hard about that?

[Arno R]

<pi********@hotmail.comschreef in bericht news:11**********************@i42g2000cwa.googlegr oups.com...

so crack open VB6, extend the listbox control to do what you want,
compile it into your own DLL, register it, and use it in your app.
What's so hard about that?

So people just have to *think* to create their own solutions....
Would be a bit unfair to expect that ... ;-)

Arno R

[Rick Brandt]

Ima Loozer wrote:

>
If the hand indeed fed me I would have been appreciative of the reply.
However since it was a smart ass reply with no assistance
what-so-ever I replied in kind.

You don't find information that will prevent you from wasting your time on
something that is not possible useful?

Have you ever seen an Access app with what you are describing? It sounds pretty
cool so I would imagine that a solution would be in common use if there were
such a thing.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[RoyVidar]

"Ima Loozer" <no****@EyeDontWantSpam.foowrote in message
<MP************************@newsgroups.comcast.net >:

In article <92********************************@4ax.com>,
no.spam.tom7744 @cox.net says...

>On Thu, 14 Sep 2006 20:46:52 -0400, Ima Loozer
<no****@EyeDontWantSpam.foowrote:

No graphics in a standard listbox. Keep it simple, and use Y and N
(or X and <blankcharacters.

-Tom.

>>OK folks I'll try to explain my objective as clearly as I can...
Might be hard...
I want a list box on one of my forms. List box will have the
persons name in column 0. Next three columns will be blank
(white) or the designated color for that column based on a
true/false condition. These will be used as flags to indicate
whether the person in that row of the list box has one or more of
the three possible certifications. So that column 1 might be flag
someone as having CPR training. If they do not have training I
want the column blank, if they do lets say we want it green. Next
might be fire training and blank of not trained, red if trained.
We might eventually have up to 6 columns however that (at this
point) is irrelevant.

In the table where the people are listed, I have Yes/No fields for
each of the certifications. I am thinking of something along
these lines (if it is possible). Store a small gif of each color
in a table, and identify each color to a given certification.
Then when building the query that populate the list box, if the
given flag is false populate that field of the query with the
white gif, otherwise populate it with the gif if the appropriate
color.

Any suggestion, ideas, hints, etc?

If I COULD use Y/N I would. You should keep it simple and read what
the requirements are.

You are asking a question, where I understand your simple requirements
to be about native Access listboxes.

What is it with Tom van Stipouts reply of "No graphics in a standard
listbox" that prompts you to accuse him of not reading your
requirements? That is an accurate answer - the native Access listbox
does not have any graphic capabilities, neither does it expose any
possibilities for conditional formatting.

Going outside your requirements - you could probably get something
like that, or close to that, using either subform or listview. The
latter I have no experience with, as I like to "keep it simple" ->
native listbox. Perhaps something can be found at Stephen Lebans site,
(www.lebans.com) too+

--
Roy-Vidar

[Ima Loozer]

In article <45**********************@text.nova.planet.nl>,
ar***********@tiscali.nl says...

>
<pi********@hotmail.comschreef in bericht news:11**********************@i42g2000cwa.googlegr oups.com...

so crack open VB6, extend the listbox control to do what you want,
compile it into your own DLL, register it, and use it in your app.
What's so hard about that?

So people just have to *think* to create their own solutions....
Would be a bit unfair to expect that ... ;-)

Arno R

:) God I love humor!

[Ima Loozer]

In article <mn***********************@yahoo.no>,
ro*************@yahoo.no says...

"Ima Loozer" <no****@EyeDontWantSpam.foowrote in message
<MP************************@newsgroups.comcast.net >:

In article <92********************************@4ax.com>,
no.spam.tom7744 @cox.net says...

On Thu, 14 Sep 2006 20:46:52 -0400, Ima Loozer
<no****@EyeDontWantSpam.foowrote:

No graphics in a standard listbox. Keep it simple, and use Y and N
(or X and <blankcharacters.

-Tom.
OK folks I'll try to explain my objective as clearly as I can...
Might be hard...
I want a list box on one of my forms. List box will have the
persons name in column 0. Next three columns will be blank
(white) or the designated color for that column based on a
true/false condition. These will be used as flags to indicate
whether the person in that row of the list box has one or more of
the three possible certifications. So that column 1 might be flag
someone as having CPR training. If they do not have training I
want the column blank, if they do lets say we want it green. Next
might be fire training and blank of not trained, red if trained.
We might eventually have up to 6 columns however that (at this
point) is irrelevant.

In the table where the people are listed, I have Yes/No fields for
each of the certifications. I am thinking of something along
these lines (if it is possible). Store a small gif of each color
in a table, and identify each color to a given certification.
Then when building the query that populate the list box, if the
given flag is false populate that field of the query with the
white gif, otherwise populate it with the gif if the appropriate
color.

Any suggestion, ideas, hints, etc?

If I COULD use Y/N I would. You should keep it simple and read what
the requirements are.

You are asking a question, where I understand your simple requirements
to be about native Access listboxes.

What is it with Tom van Stipouts reply of "No graphics in a standard

The "Keep it simple, and use Y and N
(or X and <blankcharacters." part.

[Bob Quintal]

Ima Loozer <no****@EyeDontWantSpam.foowrote in
news:MP************************@newsgroups.comcast .net:

>

If I COULD use Y/N I would. You should keep it simple and
read what the requirements are.

And when the requirements cannot be met because of technical
limitations, only loozers refuse to consider modifying the
requirements.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Tom van Stiphout]

On Fri, 15 Sep 2006 21:49:32 -0400, Ima Loozer
<no****@EyeDontWantSpam.foowrote:

I did. They can't be met with the standard listbox. That's all I
wanted to say, and offer a simple work-around.
More complicated work-arounds include:
* Write your own listbox COM control and use subclassing to make it do
whatever you want to.
* Conditional formatting in a subform in datasheet view.
* Check what Stephen Lebans has done on his site, if you want to know
what can be done with some fancy GDI calls.

Next time, can you please count to 10 before responding like you did?

-Tom.

>In article <92********************************@4ax.com>, no.spam.tom7744
@cox.net says...

>On Thu, 14 Sep 2006 20:46:52 -0400, Ima Loozer
<no****@EyeDontWantSpam.foowrote:

No graphics in a standard listbox. Keep it simple, and use Y and N
(or X and <blankcharacters.

-Tom.

>OK folks I'll try to explain my objective as clearly as I can... Might
be hard...
I want a list box on one of my forms. List box will have the persons
name in column 0. Next three columns will be blank (white) or the
designated color for that column based on a true/false condition. These
will be used as flags to indicate whether the person in that row of the
list box has one or more of the three possible certifications. So that
column 1 might be flag someone as having CPR training. If they do not
have training I want the column blank, if they do lets say we want it
green. Next might be fire training and blank of not trained, red if
trained. We might eventually have up to 6 columns however that (at this
point) is irrelevant.

In the table where the people are listed, I have Yes/No fields for each
of the certifications. I am thinking of something along these lines (if
it is possible). Store a small gif of each color in a table, and
identify each color to a given certification. Then when building the
query that populate the list box, if the given flag is false populate
that field of the query with the white gif, otherwise populate it with
the gif if the appropriate color.

Any suggestion, ideas, hints, etc?

If I COULD use Y/N I would. You should keep it simple and read what the
requirements are.

[pietlinden]

Tom van Stiphout wrote:

On Fri, 15 Sep 2006 21:49:32 -0400, Ima Loozer
<no****@EyeDontWantSpam.foowrote:

I did. They can't be met with the standard listbox. That's all I
wanted to say, and offer a simple work-around.
More complicated work-arounds include:
* Write your own listbox COM control and use subclassing to make it do
whatever you want to.
* Conditional formatting in a subform in datasheet view.
* Check what Stephen Lebans has done on his site, if you want to know
what can be done with some fancy GDI calls.

Oh, I can't wait to see his new subclassed listbox control!!!!

[Tim Marshall]

Ima Loozer wrote:

>>What is it with Tom van Stipouts reply of "No graphics in a standard

The "Keep it simple, and use Y and N
(or X and <blankcharacters." part.

Then next time just specify you want a "yes/no it can/can't be done"
answer and don't want any other advice from an experienced developer on
use of the tools you propose using.

Actually, there *IS* an easy and attractive way to achieve what you
want, though not with a list box. But I'll be damned if I'm going to
help someone who behaves the way you have done.

Shag you.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me