Link to home
Start Free TrialLog in
Avatar of kevinhh
kevinhh

asked on

How to create and reset an autonumber field in outlook form

I am new to outlook programming, I am trying to write a application that allows users to log tasks. I would like each task to to receive a unique id number, similiar to what autonumber in an access table does when a new record is created. The number will be padded to the length of 3 and appended to a 6 digit date "yymmdd", (i.e. date task was created). Giving an id of 030521001 .... 030521002 .... 030521003 and so on. Therefore I also want the unique id counter to be reset to 0 every night so the following day starts with 030522001 ..... 030522002 and so on. I figure that this is not necessarily straight forward. Any suggestions or ideas would be greatly appreciated.

Thanks in advance
K
ASKER CERTIFIED SOLUTION
Avatar of znsia
znsia

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial