 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / September 2007Archiving Notes
I am modifying an existing employee database which has a Notes field (text box). I want to add a second notes field called ArchivedNotes to the form (as a list box). I will place a button next the the first notes field (current notes) so that when the info there is no longer needed, the click of button appends the information to the ArchivedNotes. I have created seperate table with relationship (1-many based on employee ID) from the employee table to this archived notes table. I need help in completing this theory clicking the button, erasing the contents of the Notes field in the employee record - moving that data to a new record in the associated archivednotes table (adding a date/time stamp). Why use another table? Add Archive Yes/No and ArchiveDate fields. Then just flag when it is archived and update the ArchiveDate field.  SignatureKARL DEWEY Build a little - Test a little > I am modifying an existing employee database which has a Notes field (text > box). I want to add a second notes field called ArchivedNotes to the form [quoted text clipped - 6 lines] > contents of the Notes field in the employee record - moving that data to a > new record in the associated archivednotes table (adding a date/time stamp). Karl, thanks for responding. However, I don't fully understand your response, particularly the Yes/No option. But to revise on what I do gather from your response, I could use the same table, create an archiveNotes field, can append the current date as header when button is clicked to move the notes being archived into this new archiveNotes (memo type) field. If this sounds good, theory, I'm still not proficient enough w/ Access yet to invoke the actions. Can you lend that help? > Why use another table? Add Archive Yes/No and ArchiveDate fields. Then just > flag when it is archived and update the ArchiveDate field. [quoted text clipped - 9 lines] > > contents of the Notes field in the employee record - moving that data to a > > new record in the associated archivednotes table (adding a date/time stamp). Not quite what I meant. I misread your orginal post thinking you had 1-many employee-notes tables. Have Notes table with the following fields -- NoteID - autonumber - primary key EmployeeID - foreign key NoteDate - DateTime Note - memo Have an Event or macro that is triggered when you double-click the NoteDate field to append a new record and set the current date into the NoteDate field of the new record. Use a form (employee)/subform (notes in descinding date order) to display the information. SignatureKARL DEWEY Build a little - Test a little > Karl, thanks for responding. However, I don't fully understand your > response, particularly the Yes/No option. But to revise on what I do gather [quoted text clipped - 17 lines] > > > contents of the Notes field in the employee record - moving that data to a > > > new record in the associated archivednotes table (adding a date/time stamp). Thanks. That's exactly what i wanted to do. > Not quite what I meant. I misread your orginal post thinking you had 1-many > employee-notes tables. [quoted text clipped - 33 lines] > > > > contents of the Notes field in the employee record - moving that data to a > > > > new record in the associated archivednotes table (adding a date/time stamp). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.