notepad entry

[abz_y2k]

Hi

I just designed a database for personal record. i want to add notepad to the form so i can add any notes/information when required regarding any person. and when I enter any additiona notes i want it to automatically put date next to the note. so if we look back after 3 weeks we know when the data was entered.

I want the notepad to be part of ms access database not the tab button which opens notepad and you had to save externally to your folder/s.

your help would be much apreciated

 

[boblarson]

You should just use a separate table for notes and then have it as a subform. You can have a field which has

=Now()

as the default and so when a new record is added it will add the date/time to the record. You should set the subform to AllowAdditions = YES and AllowEdits = NO so you can't edit existing records. Also the AllowDeletions should be set to NO as well.