below is the prob plz help.
Dim temp As String
Dim pos As Long
Dim seed As Double
temp = CStr(CDbl(Now))
pos = InStr(1, temp, ".")
seed = CLng(Mid(temp, (pos + 1)))'//i get an error of
'//over flow here..can u pls help
'//help me i think there is somehting
'//wrong with seed variable
'//should it be long o string
'//can u try the ques on vb6 and
'//and correct the error?
'why am i doin this?i need to generate a random number for my access database so that i have a autonumber generated wheneven a record is generated..i need a huge auto number..can u pls help me?