By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,485 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Concurrent or Multiple Date postings

MitchR
P: 63
Hello to All; I have inherited a database and need to have the database post a date in a comments column which I can do. Problem is every time I execute the event procedure it replaces the old date with the new date. I am trying to figure out how to keep the old date and place the new date as well. Here is my code below:
Expand|Select|Wrap|Line Numbers
  1.  
  2. Dim myDate As Variant
  3. myDate = Date
  4. [Forms]![Daily_Terms]![comments] = "Date of Notification From Mitch " & myDate & "; " 
The above code places my date in the comments text boxt but replaces it upon each execution. My Question is ... how would I script the process of leaving the old date of execution and placing the date after it ?
Dec 4 '06 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,660
You say you want to update it - but you don't really explain what the 'it' is.
Can you make your question a little clearer?
It doesn't sound too complicated, except for lack of information.
Dec 4 '06 #2

MitchR
P: 63
I appologize; What I am trying to accomplish is to have the date stamp process, insert another entry into my textbox and leave the old date stamp as opposed to replacing the old date stamp. For Example: This is what I want to accomplish within the Comments textbox:

Date of Notification From Mitch 12-4-06; Date of Notification From Mitch 12-5-06; Date of Notification From Mitch 12-6-06;

As is the date stamp would overwrite the previous date stamp, and place the new date stamp in the old date stamp's place.
Dec 4 '06 #3

NeoPa
Expert Mod 15k+
P: 31,660
My bad MitchR.
I've just seen what I missed before (snow blindness obviously ;) ).
The code you need is :
Expand|Select|Wrap|Line Numbers
  1. [Forms]![Daily_Terms].[comments] = [Forms]![Daily_Terms].[comments] & _
  2.                                    "Date of Notification From Mitch " & _
  3.                                    Format(myDate,"d mmm yyyy") & "; "
If the code is running from within the form's module though, you can replace ([Forms]![Daily_Terms].) with (Me.).
This is better because it is more succinct and also because it is more efficient to process.
Dec 4 '06 #4

MitchR
P: 63
Thank You !!!!! Thank you!!!! That is Awesome !!!!
Dec 4 '06 #5

NeoPa
Expert Mod 15k+
P: 31,660
My pleasure MitchR.
Sorry for the confusion.
Dec 4 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.