InAboveMyHead
New member
- Local time
- Today, 21:35
- Joined
- Dec 17, 2021
- Messages
- 4
Seasons greeting's to everyone.
1st post so please go gentle, I have a couple of coding queries I would love some help with if possible, I am guessing this first one is very simple...
Currently I have
The cboRecievedBy references a field which is generated from the EmployeeID in tblEmployee whereby the link is a number but the meaningful entry on the form is the EmployeeInits
Obviously, in its current format the code simply adds the numerical value onto the calculated date/time value! whereas I would like the actual EmployeeInits to be added,
is that possible?
Failing that, is there another elegant solution?
Thanks in advance!
1st post so please go gentle, I have a couple of coding queries I would love some help with if possible, I am guessing this first one is very simple...
Currently I have
Code:
Private Sub Command50_Click()
Me.DeliveryNumber = Format(Date, "yyyymmdd") + Format(Time, "hhmm") + Me.cboRecievedBy
End Sub
The cboRecievedBy references a field which is generated from the EmployeeID in tblEmployee whereby the link is a number but the meaningful entry on the form is the EmployeeInits
Obviously, in its current format the code simply adds the numerical value onto the calculated date/time value! whereas I would like the actual EmployeeInits to be added,
is that possible?
Failing that, is there another elegant solution?
Thanks in advance!