Charlotte Foust
cfoust at infostatsystems.com
Tue May 6 16:04:22 CDT 2003
Since at least A97, it's been available as soon as you add the new record and before you update it. You can read it from the recordset without needing any bookmarks, etc. It's only with SQL Server that it becomes tricky. Charlotte Foust -----Original Message----- From: Mike and Doris Manning [mailto:mikedorism at ntelos.net] Sent: Tuesday, May 06, 2003 12:33 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] New ID/Autonumber value The best place to grab it right after the .AddNew Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Tuesday, May 06, 2003 3:37 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] New ID/Autonumber value Sorry to disagree Drew but I think it's rs.AddNew rs!Myfield="Test" etc etc rs.Update rs.bookmark=rs.lastmodified msgbox rs!MyAutoNumber rs.close I think you have to do the .bookmark line. Without that you're not on the right record Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka > Sent: 06 May 2003 17:05 > To: 'accessd at databaseadvisors.com' > Subject: RE: [AccessD] New ID/Autonumber value > > > dim rs as recordset > rs.AddNew > rs.Field(1).value="Test" > rs.Update > msgbox rs.Field(0).value > rs.close > > > As soon as you update the new record, the Autonumber field is > populated. (in my sample code above, the ID/AN is field 0). > > Drew > > -----Original Message----- > From: Stephen Bond [mailto:stephen at bondsoftware.co.nz] > Sent: Monday, May 05, 2003 9:53 PM > To: accessd at databaseadvisors.com > Subject: [AccessD] New ID/Autonumber value > > > In this thread a couple of months ago there was a solution offered to > the problem of determining the value of an ID Autonumber of a record > just added. > > > It was stunning in its simplicity, so of course I didn't write it down > ;-( > > Can anyone help? > > TIA > > Stephen Bond > Otatara, New Zealand > ( tel 03 213 1256 fax 03 213 0123 > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/a> ccessd > Website: > http://www.databaseadvisors.com > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com