Date and Time Stamp

[zoooza84]

Hello Everyone,

I'm new to the forum and access!
I created a database to store customer's details, i have a text box (memo) which enables me to add notes. I'm trying to get Date and time printed automatically and saved in the text box each time i use it so that i keep track of when the details have been entered. i tried using (RunCode --> (Expression Builder Now()) in event (On Got Focus) but nothing happens when i click on the notes box.
Is there a way of achieving this in access 2007?

Thanks in advance

[orange]

Your textbox is on a form, right? Is this form bound-- that is-- is it based on a Table?
I expect that you have a Customer table, and that each Customer is uniquely identified by an Identifier.
You could have a table called Notes that has fields, such as

NoteId (PK)
CustomerId (FK to customer table)
Date/Time
NoteText

This would allow
- a Customer may have 0 or many Notes, and
- a Note refers to 1 Customer
- a Note can be identified by Customer, or Date/Time

[zoooza84]

Thanks orange for ur reply, yes the text box z part of a form which z connected to a table that stores everything n that form. Was wondering if it's possible to use ( expression builder) or a macro that would write the date automaticcally as part of the text when focus on the text box.

Looking forward to ur replies.
Thanks