Memo Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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