T
Taffy-Taff
I have a table with a field called "Comments" It is directly linked t
a textbox called "txtCommments" A user is allowed to type comments i
this textbox and it is automatically saved in the table. However,
want to put a date stamp on the commments. Therefore, if the fiel
contain the information "called customer" and a person want to ad
"Called again" to the data, the computer will automatically place
date between the comments ("Called customer 05/19/04 called custome
again") I did this and it works fine. This is the problem:
If the person changes the information twice in one day, then I do no
want to include the date twice. I want the computer to recognize tha
that date already exist in the string and just put the ammend th
data.
Question : Is the a way to use VBA codes to search a string of data t
determine if a particular string exist within that string? In othe
words, I am thinking of storing the data in a variable, then search th
variable to act upon whether or not the date already exist in th
string.
If what I am planning is impossible or if there an easier way to do i
(without adding an additional field) then please let me know.
Thanks much
Taff
a textbox called "txtCommments" A user is allowed to type comments i
this textbox and it is automatically saved in the table. However,
want to put a date stamp on the commments. Therefore, if the fiel
contain the information "called customer" and a person want to ad
"Called again" to the data, the computer will automatically place
date between the comments ("Called customer 05/19/04 called custome
again") I did this and it works fine. This is the problem:
If the person changes the information twice in one day, then I do no
want to include the date twice. I want the computer to recognize tha
that date already exist in the string and just put the ammend th
data.
Question : Is the a way to use VBA codes to search a string of data t
determine if a particular string exist within that string? In othe
words, I am thinking of storing the data in a variable, then search th
variable to act upon whether or not the date already exist in th
string.
If what I am planning is impossible or if there an easier way to do i
(without adding an additional field) then please let me know.
Thanks much
Taff