Jim DeMarco
Jdemarco at hshhp.org
Tue May 6 12:56:10 CDT 2003
You can return the new autonumber value from a record added by the ADO .AddNew command. Might apply to DAO too but I'm not sure about that. HTH, Jim DeMarco Director of Product Development HealthSource/Hudson Health Plan -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Tuesday, May 06, 2003 12:31 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] New ID/Autonumber value I don't think that works in MDBs, which I assume Stephen meant, else he would have posted on the SQL list. Arthur -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Haslett, Andrew Sent: May 6, 2003 12:09 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] New ID/Autonumber value SELECT @@IDENTITY -----Original Message----- From: Stephen Bond [mailto:stephen at bondsoftware.co.nz] Sent: Tuesday, 6 May 2003 12:23 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/accessd Website: http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not. _______________________________________________ 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 *********************************************************************************** "This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message. Thank You". ***********************************************************************************