Simple problem, when adding a new record to MS ACCESS and u want to know the autonumber of the record added.
Solution is very simple (funny how the one that works is always very simple!)
The URL: http://www.kamath.com/tutorials/tut004_autonum.asp
The Code SOlution, well after you add a new record
'this is the adding of new record line
addNewLog.Update
'then u simply call it where ("id") is the autonumber filed.
dID = addNewLog("id")
and that it! Simple and it works
Solution is very simple (funny how the one that works is always very simple!)
The URL: http://www.kamath.com/tutorials/tut004_autonum.asp
The Code SOlution, well after you add a new record
'this is the adding of new record line
addNewLog.Update
'then u simply call it where ("id") is the autonumber filed.
dID = addNewLog("id")
and that it! Simple and it works
No comments:
Post a Comment