Search results

Thanks again CraigDolphin, What you advise makes great sense and I will work on it later. You are correct in your assumption that the disagreement field relates to a specific area of need. Really appreciate your help on this, and can't help but be impressed by the speed in which you...

Hi CraigDolphin, Thanks for the quick response, and sorry for the confusion. I'll try and answer your questions as best I can. I appreciate your assistance and can only apologise again if I have confused you further. Regards Doug

:confused: Fingers crossed I'll get some direction to resolve an issue that I can't even begin to imagine how to search for. My database is used to record detailed work done with clients who are receiving regular support. I'm designing it around a Common Assessment Support Framework that I...

Thanks for clearing that up for me RuralGuy, and again thanks for all your help. Regards Doug

Noted Paul, and thanks. Doug

Paul, Thanks for this advice; it isn't something I had even considered. I'd still like to stick with the labels to give a clear indication that the record is well and truely closed but I'd like to take your advice also! I take it there shouldn't be any conflicts with the two being done? You...

Thanks Very Much RuralGuy, Thank you again for your help. This works brilliantly and saved me yet more days of trying to figure it out. As an aside; I have asked a question or two in the Microsoft Community and have had responses, and a great deal of help from someone with your name, is it...

Evening All! (Old enough to remember Dixon of Dock Green (stupid enough to mention it!)) I'm working on a small database for a small team of support workers with a client base of 60 clients at anyone time, although the turnover is quite substantial. I have done some searches on archiving...

Thanks for that Mark. Apologies for delay in responding been too busy pullin' me hair out with other Access related stuff. Doug

I'm wondering if the following is possible? I have a Review Date field where a client needs to be re-assessed either on a monthy, bi-monthly or tri-monthly basis. I suspect I could create a table to store successive review dates and include it as a sub-form on my main form but I am guessing...

It's Still Me I've just been running a couple of test and realised that I may have asked the wrong question! So, I have my InitialContactDate field which is the start date + 90 days for my ReviewDate field that when reached or passed will show the ReviewDue Label. What I need is: 'once the...

No Matter I worked out the problem...... duh me! lol Thanks again Paul, your code was top totty, it WAS me that was the problem. Regards Doug

Thanks Hi Paul, Thanks for this: However, this is what I'm getting with the following code: Run-time error 94 Invalid Use of Null Private Sub Form_Current() Me.HighRiskLabel.Visible = Me.High Me.InterpreterLabel.Visible = Me.Interpreter Me.ReviewDueLabel.Visible = (DateDiff("d"...

Ok, I am getting well excited about what Access can do, and how the database I'm working on is coming along. It's the things that you guys find simple that I'm having problems with. So my question is: I have fields called InitialAssessmentDate and ReviewDate. I want to be able to have a bold...

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

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...

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!!! :rolleyes: ) lol. Seriously, I'm overwhelmed by the time you and the guys (and I say guys in a non-gender specific...

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

Can we just clarify, is there an actual box on your standard form that contains the status (high, medium, low) of the client? 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.

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...