Inserting a Date Stamp

[jdupaix]

In a memo field I want to insert a time stamp using a shortcut (ex. Alt D) or whatever. What is the best and easiest way to do that! I will end up with many dates before notes I am taking on different situations. Thanks in advance! Joe

 

[jdupaix]

I am using 2003 and I have never used code before in my database. Will you let me know how to do that in beginners terms?

 

[jdupaix]

Thank a lot Pat! I will give it a try! Another question I have for you is this.... On my form, the bottom 1/3 is the box I use to put my notes in. When I start typing in the box the form shifts up 3-4 inches to center the form on the monitor. I would rather it not shift and stay where it is. Any advice....

Thanks, Joe

 

[bodylojohn]

I would never recommend making notes this way. I would create a many-side table so that each new note has its own timestamp as well as author stamp.

To do what you want, you can use the BeforeUpdate event of the memo control to concatenate in a leading timestamp ---

Me.SomeDesc = Now() & "----" & Me.SomeDesc

Let us know if you are using A2007 since it has a new data type that you might want to try out.

I would like to know more about that

 

[jdupaix]

I hit the size to fit form but it still shifts when i type in a character, any other ideas?

 

[jdupaix]

Also Pat regarding the Date Stamp I followed your advice but I am not getting a date to show?

I am looking for this as my outcome

4/22/08 - blahdg;askdfasdjf;alksjdfahg

4/28/08 - aahjfhga;sdf;askdf

etc....