Re: How do I insert date and time before typing a new note in Access 2
- From: John W. Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 08 Oct 2007 10:15:26 -0600
On Mon, 8 Oct 2007 06:36:04 -0700, BHostler
<BHostler@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I am putting a database together for my company and everything has gone
smoothly to this point. I have now run into a slight problem. In the form
view I set up a memo box so employees of my company can type notes into the
box when they contact customers. I would like for the date and time to be
stamped on those notes as they are added. For example if I talk to a customer
today and they want the product delivered to their home rather then the
office I want to be able to go to the memo field and type in a note making
all other employees aware of that. Before the note is displayed I would like
the note to display the time and date I typed the note in. How do I
accomplish this?
Rather than storing multiple items of data - many notes, each with its own
timestamp - all in one memo field, I'd VERY strongly suggest using a one to
many relationship to a Notes table. This table should have a foreign key field
linked to the primary key of your current table; a date/time field NoteTime
with a default value of Now(); and a memo field in which to enter each note in
a separate record. You could use a continous Subform with just a textbox for
the memo field enabled to enter the notes.
John W. Vinson [MVP]
.
- Prev by Date: Re: Forms and Queries
- Next by Date: Re: Convert .DBF files to .MDB.....
- Previous by thread: RE: How do I insert date and time before typing a new note in Access 2
- Next by thread: Convert .DBF files to .MDB.....
- Index(es):
Relevant Pages
|
