Custom field question

[Guest]

I have created a custom form and on the form I have an employees hire
(EmpHire) date as well as their termination date (EmpTerm). We have a lot of
people who are rehired once they leave and we would like to track this on
custom form then create a view that would show us all people that have been
rehired this year. So far I have created a field called EmpHistory, I would
like to set up the following equation: EmpHistory=EmpStart+" ~"+EmpTerm. How
would I do this in VBA? Everything I have tried so far has not worked.

 

[Sue Mosher [MVP-Outlook]]

What exactly do you want EmpHistory to show? An example might be helpful. The function you'll probably want to use is DateDiff() by the way.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

Thank you for your reply! I would like it to show something that looks like
following:

8/4/2003 ~ 9/2/2005
10/6/2006 ~ 11/2/2006
2/2/2004 ~ present

In my head, I'm picturing a field with 2 columns, one being startdate one
being enddate. One of the requirements is that with this information I have
to generate a report, the report has to list who was rehired that year. I
was thinking I could generate these reports by creating custom views in
Outlook. So when I person hit the "Rehire Report" view they would see a list
of those people rehired in that year.


Thanks again for your reply!

-Cory

 

[Sue Mosher [MVP-Outlook]]

So, if you already have those two columns, why do you need a third column to summarize the information? Seems to me that you'd get just as much utility out of the start and end date columns and keep the application simpler.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

I'll need a 3rd column showing the history because we have a lot of people
that leave the company then come back. We're a staffing firm and it is very
common for an employee to work for a year or so, their contract ends and they
work somewhere else for a little while, then they come back. Our HR manager
said she needs to see this information on the form, it is required so she can
determine 401k vesting.

 

[Guest]

I just did some more research and found something pretty interesting. Would
it be possible to have values in fields I've created on my custom form
populate an Excel spreadsheet object on another page within the same form?
If so this will solve our problem. If it could be setup to write to the
spreadsheet whenever the TermDate or HireDate fields change this would give
our manager what she needs. She will be able to see all of the dates the
person was employed with us by simply looking at the Excel object.

 

[Sue Mosher [MVP-Outlook]]

You might be able to do that with the spreadsheet control (see http://www.outlookcode.com/d/spreadsheetcontrol.htm) but not with an embedded spreadsheet.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers