Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon May 1 09:43:38 CDT 2006
Dear List:
I have several manikin diagrams with boxes where a patient experience
pain. When they click the box it turns from green to red (and v.v.).
When the forecolor of the box changes I save it in a Yes/No field in the
patient record in the patient table - Yes for red, No for green.
On entering the form for the second or subsequent times, in the
Form_Open event I want to change the boxes to red which were previously
turned red but I'm having a problem with the syntax. The boxes are
uniformly named "Boxnnnnnn" (length can vary) and the corresponding
fields are named "fldPLnnnnnnn"
So I'm using:
Set db = CurrentDb
Set rs = db.OpenRecordset("Select * FROM tblPatient WHERE
fldPatientRecordID = " _
& Forms!frmPatient!fldPatientRecordID)
For Each fld In rs.Fields
If Left(fld.Name, 5) = "fldPL" Then
If rs(fld.Name) = True Then
strControl = ("Box" & Right(fld.Name, Len(fld.Name) - 5))
Set ctl = Me(strControl)
ctl.ForeColor = 255
End If
End If
Next fld
to find the fields beginning with fldPL and everything works, I get the
box name in strControl, OK except where I want to set the forecolor of
the box to red it doesn't work (property or method not supported). Does
someone know the correct method/syntax?
MTIA,
Rocky
P.S. - additional question for the future - this app is coming from a
back pain specialist who saw The Sleep Advisor and wants to do a similar
expert system to diagnose back pain. Very interesting idea. In the
meantime, the areas of pain on the manikins are, of necessity,
rectangles. But on his original drawings, they are irregular shapes
conforming to the outlines of the body. As it is now, it will do for
alpha and beta testing, but ultimately we'll need something more
precise. Does anyone have any ideas on how to draw irregular shapes on
a form which will respond to a mouse click?
MTIA again.
--
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com