Memo Problem

[Guest]

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

 

[Allen Browne]

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.

 

[Guest]

OK will go down that route then,

Many thanks for your quick reply.

James