[AccessD] SQL Server table autonumber

Hey, after all the LnL (Lurking 'n Learning - I just made that up ;-)) I do
on 
this list, I'm just glad I could finally contribute something.

Rusty

-----Original Message-----
From: John Colby [mailto:jwcolby at colbyconsulting.com]
Sent: Thursday, December 22, 2005 9:46 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] SQL Server table autonumber


Woa, learn something new every day.  

.BookMark = .LastModified

I love this list.

Thanks Rusty,


John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
rusty.hammond at cpiqpc.com
Sent: Thursday, December 22, 2005 10:15 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] SQL Server table autonumber

John, for a linked table in Access using DAO recordset I do the following:

.AddNew
!LWSL_IDLWSU = mlngUserID
.Update
.BookMark = .LastModified
mlngLogID = !LWSL_ID

HTH,

Rusty


**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************