Pop Up Warning

[Darkwater]

I need to be able to cause a warning box to appear when records for high risk clients are viewed. When a risk assessment is carried out I need to show the result as being either High, Medium or Low on the Client Form. If the result is high I want every worker accessing the record to be in no doubt as to what they need to do if a visit to the individual is being made. Thanks in advance.

Doug

 

[Tezcatlipoca]

Should be as simple as a few lines of VB code to check the status of a client (record) is high upon the record being accessed.

Can we just clarify, is there an actual box on your standard form that contains the status (high, medium, low) of the client?

 

[Darkwater]

Can we just clarify, is there an actual box on your standard form that contains the status (high, medium, low) of the client?[/QUOTE]

Thanks for responding so quickly. There are three tick boxes, one each for High, Medium and Low. The Warning Box should only appear if the High tick box is chosen.

 

[RuralGuy]

I would have used an OptionGroup since I believe the risks are mutually exclusive. Why not have a label (red background if you like) that is only visible when High Risk is selected? It would take code in the Current event and the AfterUpdate event of the OptionGroup to implement.

 

[Darkwater]

Thanks

Hi guys, Thanks for your help, although I'm none the wiser. I won't cause any further frustration for you or I on this. Gotta get me an idiots guide to Access.

Thanks again
Doug

 

[Tezcatlipoca]

Hi Darkwater,

Sorry for taking so long to come back to you, but I've been dying of man-flu for the past few days and haven't been feeling in the mood for Access programming!

Anyway, I've now recovered and taken a look at your requirements. Please see if the little example database I've attached to this post is the kind of thing you need.

All I've done is added the following VB code to the OnCurrent aspect of the form:

Private Sub Form_Current()
If Me.High = True Then
Beep
MsgBox "This person is HIGH ranking!", vbExclamation, "High Selected!"
Else
'Do.Nothing
End If
End Sub


Obviously, this is just a very quickly coded solution. If you like, I can add further code that will lock off two of the checkboxes if you select one, ensuring that only one option can ever be chosen, assuming you don't already have that on your own database.
Let me know if you want any aspect of this example changed, or if you need help with anything else.

 

[Darkwater]

Huge Thanks

Hi Tezcatlipoca,

Thank you so much for this, it works a treat and is great as is. I'm glad to know that you are over the worst of the 'man flu' (nothing worse!!! ) lol.

Seriously, I'm overwhelmed by the time you and the guys (and I say guys in a non-gender specific way) take up your time in helping newbie's like me. I can't wait for the day when I can say 'obviously its just a quick bit of code' as though it isn't really blummin' amazing!

So thanks again, and please don't pick up any more 'man flu' bugs for a while, I may (actually I know I WILL) be seeking your wizdom again.

Regards
Doug

 

[Darkwater]

Pushing It

I know this may be pushing my luck a little but I'm just wondering if it is possible to have the form open, click through records and have it pop up user alerts for more than one situation? As it stands I have identified several other situations other than "Client is a High Risk (precautions to be taken)" where I would like to remind users of:

Client may need an Interpreter or signer (using Interpreter field in Table_tblClient.)
Client Review Required (using a date three months from Date of first contact, and thereafter three months from the last review date​

both taking in to account overdue date following weekends, staff absence etc.

I hope I can make clear what I need by this short scenario?:

Form_frmClient is accessed by user.
Client clicks through or searches for a particular record
One of the conditions is met (or several conditions are met) and they are alerted of such​

Do all these questions make me an Access Developer et al Groupie?

Regards
Doug

 

[ghudson]

I suggest you use a Case Select statement to account for the different situations you want evaluated. I also recommend that you use a form label to display your warning. Popup message boxes will irritate your users. Especially if they are scrolling through the records. Lots of samples posted around on both.

 

[Darkwater]

Thanks

Thanks for the assistance, it's been very helpful.

Regards
Doug