Thanks for the info,
For once I actually discovered the answer myself.
Now, if I could only answer my own
VB questions the 3,537 times I have
problems life would be good! . . . : )
Thanks,
WillRn
"K Dales" wrote:
Use the Format function to format the date to a number, e.g.:
FollowUpInitial.EventID.Value = CMTAudit.AcctNumberTxt.Value & _
Format(DateValue(CMTAudit.AuditDateTxt.Value),"### ##")
"WillRn" wrote:
I am trying to create a unique id number for each line in a spreadsheet by
combining an existing account number and an audit date.
I have been using the following code:
FollowUpInitial.EventID.Value = CMTAudit.AcctNumberTxt.Value & _
DateValue(CMTAudit.AuditDateTxt.Value)
Unfortunately I keep getting the account number and the standard date format
combined. For Example from and account number of 123456 and 3/24/05 I get:
"1234563/24/05"
What I would like is:
"12345638435"
I know that I am overlooking something pretty simple but it eludes me.
WillRn