http://www.programmersheaven.com/ Contains the latest posts from the thread 'how to retrive last entry / record from access db, using asp' posted on the 'Active Server Pages' forum at Programmer's Heaven. en Copyright 2012 Programmers Heaven Wed, 23 May 2012 08:05:31 -0700 Wed, 23 May 2012 08:05:31 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/aspfaq/414626/414626/how-to-retrive-last-entry--record-from-access-db-using-asp/ hi,<br /> <br /> i have dev tape log system with different type of tape categories (dvd, cd, voice over,etc) my challenge is i want to auto generate tape ID number when ever i try to add new tape log.<br /> <br /> for example:<br /> <br /> the last Tape log ID for Voice over category is VO5533<br /> <br /> Now, how do i tell the application that i want to retrieve the last Tape log ID for the Voice over category?<br /> <br /> currently in my Add new Tape log page, i have to insert the Tape log ID manually, which is very hard as i need to search for the last record manually then enter the new record, is there anyway i can write a script to auto generate the tape ID based on the category selected and add + 1 to the tape log ID?<br /> <br /> im kind of new to ASP i would appreciate any sample codes or tuts you guys can provide me with<br /> http://www.programmersheaven.com/mb/aspfaq/414626/414626/how-to-retrive-last-entry--record-from-access-db-using-asp/ Tue, 16 Mar 2010 13:48:35 -0700 Active Server Pages