If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Memo Problem
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 |
#3
|
|||
|
|||
Memo Problem
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Preventing query from converting memo field to text field. | Dennis In Forks | Database Design | 1 | December 22nd, 2004 04:08 AM |
memo field truncation: new problem | whincup | Running & Setting Up Queries | 2 | November 16th, 2004 08:40 AM |
Memo Field data truncated in query | Joel | Running & Setting Up Queries | 3 | August 4th, 2004 03:40 PM |
Powerpoint97 - Automate EMail | Simon | Powerpoint | 5 | July 28th, 2004 05:46 PM |
Productkey problem when installing office 2003 on network | Stefan Schreurs | Setup, Installing & Configuration | 1 | June 1st, 2004 11:16 PM |