Thanks Scoot. I need to convert the result to Long Integer (10 digits). ToReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12650
avoid duplicate, I think it may be better to perform the time stamping from
Save command button and after looking into table to check for duplicate ID #.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12650
> Make the format of you Membership ID field a Date/Time format.
> Set the Default Value to: =Now()
> "Sokan33" wrote:
> > Hi Folks,
> > I would like to generate Membeship ID by using time stamp in the format:
> > yy:mm:dd:hr:sec. Anyone has an idea how this can be done?
> > Thanking you all for your suggestions and assistance!
> > With regards.