Memo Problem

Hello,
I have a form that shows details of members with a memo field displayed
which contains notes on conversations, renewals and general notes on the
member.

When they renew I have vba code put a note into the memo field, eg:
"17/11/05 Tel Mem Ren. " The code is Me.called = Me.called & vbCrlf & Date &
"Tel Mem Ren"
I have been getting a problem tho with the larger memo fields with lots of
notes, it doesnt work. It pops up saying "Could not update, record currently
locked by user on this machine" I have found this to be when the memo field
is over a particular size.

Is there a fix to this or is it a problem with Memo fields? Should I swap to
having another table for comments, each record would be a new comment linked
to the member?

Many thanks for your help.

James

Yes, what you are doing suggests that a related table of comments (one
member = many comments) would be the best solution. It woudl be normalized,
and easily searchable by date.

The particular problem you refer to happens when you have multiple forms
both showing the same memo field, and you are trying to edit in both forms.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"James" wrote in message
...
Hello,
I have a form that shows details of members with a memo field displayed
which contains notes on conversations, renewals and general notes on the
member.

When they renew I have vba code put a note into the memo field, eg:
"17/11/05 Tel Mem Ren. " The code is Me.called = Me.called & vbCrlf & Date
&
"Tel Mem Ren"
I have been getting a problem tho with the larger memo fields with lots of
notes, it doesnt work. It pops up saying "Could not update, record
currently
locked by user on this machine" I have found this to be when the memo
field
is over a particular size.

Is there a fix to this or is it a problem with Memo fields? Should I swap
to
having another table for comments, each record would be a new comment
linked
to the member?

Many thanks for your help.

James

OK will go down that route then,

Many thanks for your quick reply.

James

"Allen Browne" wrote:

Yes, what you are doing suggests that a related table of comments (one
member = many comments) would be the best solution. It woudl be normalized,
and easily searchable by date.

The particular problem you refer to happens when you have multiple forms
both showing the same memo field, and you are trying to edit in both forms.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"James" wrote in message
...
Hello,
I have a form that shows details of members with a memo field displayed
which contains notes on conversations, renewals and general notes on the
member.

When they renew I have vba code put a note into the memo field, eg:
"17/11/05 Tel Mem Ren. " The code is Me.called = Me.called & vbCrlf & Date
&
"Tel Mem Ren"
I have been getting a problem tho with the larger memo fields with lots of
notes, it doesnt work. It pops up saying "Could not update, record
currently
locked by user on this machine" I have found this to be when the memo
field
is over a particular size.

Is there a fix to this or is it a problem with Memo fields? Should I swap
to
having another table for comments, each record would be a new comment
linked
to the member?

Many thanks for your help.

James