Create a ID number from the date and time entered

[speltrain]

Is there a way I can create an ID number on a form based on the date and time the record was entered. I am trying to migrate away from the field that is being used.

If the whole date time thing isn't doable, then is there a way to write a vb procedure to mimic it? What would the code consist of?

Can anyone help?

 

[SBendBuckeye]

Look at the format function. Something like the following should work (I can't verify the syntax so it may be off a little bit).

Dim lngID As Long
lngID = Val(Format(Date(), "yyyymmdd&quot & _
Format(Time(), "mmhhss&quot)

Good Luck!

 

[SBendBuckeye]

Try MsgBox Val(Format(Date, "yyyymmdd&quot & _
Format(Time, "hhmmss&quot)