AlternateColorDetailSection code from Lebans fails on w2k3 boxes (2nd request)

  • Thread starter Thread starter mat
  • Start date Start date
M

mat

The AlternateColorDetailSection at
http://www.lebans.com/alternatecolordetailsection.htm
is pretty neat on most pcs. But on a windows 2003 terminal server box it
does not seem to render the alternate backcolor, no matter what color I
set it to. The color depth is very good via RD on that box, so it's not
that the color can't be rendered.

I've done some more testing and it's quite interesting. The class works
fine on winxp and vista. It does not work on 2nd windows 2003 box, one
which I'm not accessing via termial services (32 bit color depth!).
I can't imagine why the class would fail based on OS?

I posted here about this two weeks ago but didn't get any replies,
hoping a repost will get some attention.
 
Hi,

I have never used it so this is only a guess. He does not do any error
handling in his code so something is erroring out on Windows 2003
Server--perhaps one or more of the calls to the various DLLs. Perhaps he is
trying to call some function that has been changed or is not there in that
version of Windows. Or that requires some other DLL that is not there. Or
that just is not available in the version. You could add some error
handling, see if any errors happen. Note that a number of DLL functions
return success or failure codes that should be checked also. It looks like
he does that to some extent; perhaps completely. I am not sure as I don't
want to take the time to really check.

You may decide it is just not worth the effort.

Good Luck,

Clifford Bass
 
Hi,

Leban's code does not require any references other than the required
two. It is just standard VBA calling out to common Windows DLLs.

Clifford Bass
 
Hi,

Leban's code does not require any references other than the required
two. It is just standard VBA calling out to common Windows DLLs.

Clifford Bass
Click to expand...
That's true, there are no exotic refs required by this routine, as I
mentioned to linqadams when he posted the same response to my earlier
post on the topic. I will try to follow through on your other posting,
but I don't have a lot of expertise with dll error trapping.

It kind of looks like Lebans does not show up here much any more. I
posted a note via his website too, referencing the earlier thread I
started on this, and no reply for several weeks.
 
Hi,

A lot of the Windows API functions return 0 when they fail; although
not all by any stretch. It looks like he checks for 0 after of number of
those calls, but does not report the failure. So where you see something
like If variable <> 0 Then ... you could add an Else (report error) part.

Of course, you could just upgrade to Access 2007 which has alternate
coloring capability built into it. The runtime is free so you would really
only need to purchase one copy for development.

Clifford Bass
 
Back
Top