Hyperlink to form question

[GuiGirl]

Question: Hyperlink to a Form

Access 2003 DB. I created a hyperlink to a form on my database. The color of the hyperlink if blue which is great. However, I would like the hyperlink color to change to red when the user enters information to the form. This form provides information on worker risk issues. The theory is that if the hyperlink titled "Work Risk" is red than caution for the worker when working with this client should be observed. Is there a way to have the hyperlink change to red to indicate to the user that there is a security risk for the worker on the particular record they are working with.

Many thanks in advance.

 

[James Dudden]

Hi,
Is there a field which you can decide if a worker is risky or not?

Also, when you say hyperlink to a form, do you just mean a button from one form to the next or an actual hyperlink?

Either way, assuming there is a field which sets the WorkerType do as follows:

On the AfterUpdate of the WorkerType do something like this:

If me!WorkerType = "Risk" then
Me!Hyperlink.ForeColor = 255
Else
Me!Hyperlink.ForeColor = 16711680
End If

Regards
JD

 

[GuiGirl]

Hi Tim,
Thanks for responding to my question.

Background. The DB is set up of clients names, addresses, phone numbers, date of birth and numerous command buttons to record various assistance given to a client. In order to assist a client, a worker needs to go to the client's home. The worker does not know if the home is safe until he/she makes the initial visit. I put a hyperlink titled Worker At Risk onto the main form.

To answer your question, there isn't one particular field to indicate whether or not the client is risky. I created a form WorkerAtRisk for that purpose. The form has several check boxs for questions such as Dangerous/Vicious Animal; Weapons; Verbal Threats, etc. plus a comments box. So if FieldWorker1 goes into the field and ecounters some sort of dangerous situation, he will be able to record the potential threat by updating the WorkerAtRisk form to alert future FieldWorkers that this home is not safe and to use caution when making a home visit.

When a FieldWorker looks at the main form to get address and telephone number to make a home visit, if the hyperlink is red then the FieldWorker should click into it and read the WorkerAtRisk form on potential threats before paying a visit to that home. If the hyperlink is blue that would indicate the WorkerAtRisk has not been updated and the home is safe to make a home visit.

Thanks for any advise.

 

[James Dudden]

Ok. So what I am thinking is the WorkerAtRisk form is a subform, if so then I would test to see if a record had been added to the subform (table behind the subform). Something like this:

If Not Isnull(Me!SubFormID) then
Me!Hyperlink.ForeColor = 255
Else
Me!Hyperlink.ForeColor = 16711680
End If

Regards
JD

 

[DCrake]

Another possible solution would be to check the status of the "At Risk" for the person and if there is a risk then bring up a message box that states "There are risks attched to this person. Do you want to view them now?" and use a yes/no type message box this will then give the user the choice as to whether to look at it or not. You can still have the other functionality in place but this ensures that they are aware of the at risk nature. Purely as a double check and prevents the users denying knowledge of the risk status.

David

 

[Orson9750]

Thanks David,
I like this approach. This should work well

Gui Girl aka Orson9750