Recent content by Darkwater

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