jmtinvt
|
| Posted: 11/20/2005, 1:44 PM |
|
I would like to be able to append information to an existing field, but with out changing the existing data. This will be used in a notes tracking tool, so I don't want to change the previous notes. I thought that I saw something post here a while back about this but I can't find it now.
|
|
|
 |
Edd
Posts: 547
|
| Posted: 11/20/2005, 1:49 PM |
|
Not sure why you would want to do this, but you could do this in the BeforeUpdate routine, calling existing data from the database or form and adding any additional comments.
Not knowing your application, but would you not find it better to keep a history of notes as a sub-item of the main note. I do this all the time and people can then see who an when the note was added.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
|
jmtinvt
|
| Posted: 11/20/2005, 2:05 PM |
|
Edd that is exactly what I would be looking to do. Where can i learn how to accomplish this?
|
|
|
|
Edd
Posts: 547
|
| Posted: 11/20/2005, 5:47 PM |
|
Quote :Edd that is exactly what I would be looking to do. Where can i learn how to accomplish this?
Which one - BeforeUpdate OR sub-items?
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
jmtinvt
|
| Posted: 11/20/2005, 5:49 PM |
|
Both actually
|
|
|
|
Edd
Posts: 547
|
| Posted: 11/20/2005, 6:22 PM |
|
BeforeUpdate
Create a form with the NoteField as a label (called NoteLabel) and also a hidden field (called NoteField).
Also Create a TextArea called NoteEntry below it with Control Source Type as "Code Expression". This area is where the person can append their comments.
On the form create a BeforeUpdate event and in the event put in the code such as
Dim NoteEntry
NoteEntry = CCGetParam("NoteEntry",Empty)
If Not IsEmpty (NoteEntry) Then
NameOfForm.NoteField.value = NameOfForm.NoteField.value & NoteEntry
End If
For the sub-items (simple Technique)
You need to have your database structure so you can have Notes that are Parent and SubItems.
Create a grid where a person can add a Parent Item Note.
In the Maintenance Screens (Create 2 screens) one for Additions and the Other for Updates and Deletes.
The Addition Screen only allows Additions. The Update and Delete Screen has not part of the Note form editable. It has underneath another grid of the Subitems where people can put their notes by linking to a SubItem Maintenance Screen.
The above can be varied greatly as your experience grows.
Have a look at the example pack in the Master Detail area. for a couple of the techniques. It will get you started.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
