Date stamp in a note field

  • Thread starter Thread starter T Hart
  • Start date Start date
T

T Hart

I am a small business owner, using a simple Access 2002
database. I enter my ongoing client disccusions in a
notes field via a form. With each discussion, I start out
by entering the date of the conversation. Is there a
simple way to accompish this automatically via an
function, etc.?

Any suggestions would be greatly appreciated.
(e-mail address removed)
 
You could add code to the onenter of the field that says something like...

[NoteField] = [NoteField] & format(Date(),"short date")



Then you could add code to stick the cursor at the end of the field...


If Len(Notes) > 0 Then ' Make sure the field is not
blank
Me!Notes.SelStart = Len(Me!Notes)
End If




Personally, I would create a new table for my notes and include a key filed
linked to your main table (customer number maybe?), date field (which would
default), a userid field (which would default to the current user) and a
notes field. I'd link this to my main table and include it in my forms as a
subform. Each time I had a new discussion, I'd add a new record. The built
in CONTACT MANAGEMENT database wizard has a good example of a "call" table.
It uses a button to open a new form, but you could easily turn it into a
subform.

Hope that helps,

Rick B



I am a small business owner, using a simple Access 2002
database. I enter my ongoing client disccusions in a
notes field via a form. With each discussion, I start out
by entering the date of the conversation. Is there a
simple way to accompish this automatically via an
function, etc.?

Any suggestions would be greatly appreciated.
(e-mail address removed)
 
in message
I am a small business owner, using a simple Access 2002
database. I enter my ongoing client disccusions in a
notes field via a form. With each discussion, I start out
by entering the date of the conversation. Is there a
simple way to accompish this automatically via an
function, etc.?

Any suggestions would be greatly appreciated.
Click to expand...

If you have the text caret positioned to where you want the date to be
entered, you can just press Ctrl+; to enter the current date. Or, if
you have a "new note" button, that button can be programmed to insert a
line break and the date in the note field, and position the text caret
at the end of the date, leaving it all ready for you to type the note.

BTW, I don't recommend posting any real e-mail address in these
newsgroups. Spammers and viruses scan the groups for e-mail address to
send their "products" to.
 
-----Original Message-----
I am a small business owner, using a simple Access 2002
database. I enter my ongoing client disccusions in a
notes field via a form. With each discussion, I start out
by entering the date of the conversation. Is there a
simple way to accompish this automatically via an
function, etc.?

Any suggestions would be greatly appreciated.
(e-mail address removed)
.
Hi,
Click to expand...
Can you please let me know if you receive any email
replies to this message? I've posted on this very same
thing for 3 days and haven't gotten a response. Thanks!
Lauri
 
Lauri:

There are two answers posted under T Hart's question. These were posted at
10:37 and 10:39. You posted your note at 12:47 asking to be informed if he
gets any answers.

Signed,
Very Confused


-----Original Message-----
I am a small business owner, using a simple Access 2002
database. I enter my ongoing client disccusions in a
notes field via a form. With each discussion, I start out
by entering the date of the conversation. Is there a
simple way to accompish this automatically via an
function, etc.?

Any suggestions would be greatly appreciated.
(e-mail address removed)
.
Hi,
Click to expand...
Can you please let me know if you receive any email
replies to this message? I've posted on this very same
thing for 3 days and haven't gotten a response. Thanks!
Lauri
 
Can you please let me know if you receive any email
replies to this message? I've posted on this very same
thing for 3 days and haven't gotten a response. Thanks!
Click to expand...

If you're waiting for an EMail response, note that the only address
available (since you're taking the default reply-to from the web page)
is "lauri" <[email protected]>. I may well have
missed it, but I don't recall seeing your posts - perhaps they didn't
make it out!
 
Back
Top