
Signature
Dave Hargis, Microsoft Access MVP
Beautiful, Thank You. Rob
> First, you need a field in the table that is the record source for the form
> so you will know who created the record. Then create a field on the formI
[quoted text clipped - 23 lines]
> >
> > Any help with this would be greatly appreciated. Rob
You're going to run afoul of JCAHO with this approach, to say nothing of
malpractise lawyers! In hand written notes, a health care provider cannot
remove a written note and then write another, which is essentially what
you're trying to allow them to do. They have to strike thru the old notes
with a single line and initial it, then write another note in it's place! The
only way to emulate this in online notes is to only allow notes to be emended.
The old text has to remain, with the person adding an additional note stating
something like "Correction to note of thus and such day and time."
The general way that I do this is to make the memo field itself always locked.
I mput a button next to it, call it "ADD a Note." Clicking it brings up a
text box for adding notes. The user enters their notes and DoubleClick the
note field. The note gets added to the old text, along with a date/time stamp
and the user username.
If JCAHO or an attorney comes along, you can show that the use has no means
of changing a previously entered note.
I'm 4+ busy right now, but I'll dig around and post some example back here in
a day or two, if you're interested!

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
RobUCSD - 29 May 2007 23:09 GMT
Yes, I'm interested. Thanks,
Rob
> You're going to run afoul of JCAHO with this approach, to say nothing of
> malpractise lawyers! In hand written notes, a health care provider cannot
[quoted text clipped - 16 lines]
> I'm 4+ busy right now, but I'll dig around and post some example back here in
> a day or two, if you're interested!
Dirk Goldgar - 29 May 2007 23:48 GMT
> You're going to run afoul of JCAHO with this approach, to say nothing
> of malpractise lawyers! In hand written notes, a health care provider
[quoted text clipped - 17 lines]
> I'm 4+ busy right now, but I'll dig around and post some example back
> here in a day or two, if you're interested!
Well posted, missinglinq!

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
RobUCSD - 30 May 2007 00:27 GMT
Surely there must be a way to only allow the current new record to be editable;
If Me.NewRecord And Me.CurrentRecord Then
Me.allowedits = True Else
Me.allowedits = False
I've tried this and it doesn't work, Why not?
Thanks, Rob
> > You're going to run afoul of JCAHO with this approach, to say nothing
> > of malpractise lawyers! In hand written notes, a health care provider
[quoted text clipped - 19 lines]
>
> Well posted, missinglinq!
Dirk Goldgar - 30 May 2007 03:15 GMT
> Surely there must be a way to only allow the current new record to be
> editable;
[quoted text clipped - 4 lines]
>
> I've tried this and it doesn't work, Why not?
I think all you need is this:
Me.AllowEdits = Me.NewRecord
Me.CurrentRecord is just the record number of the current record, so
using it in a logical expression like the above makes no sense.
Me.NewRecord always refers to the status of the form's current record.

Signature
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)