Board index » VBA

All times are UTC



 need help on getting the auto-increment value of a field BEFORE updating recordset 
Author Message
oliver schmid
#1 / 2
 need help on getting the auto-increment value of a field BEFORE updating recordset

when opening a recordset i need to know the value of the auto-increment
before rec.update
does anybody have an idea?

thanks and regards
oliver



Fri, 16 Nov 2001 03:00:00 GMT  
Valer
#2 / 2
 need help on getting the auto-increment value of a field BEFORE updating recordset
Hi Oliver!!!

  After rec.AddNew, you can read value of auto-increment field

Valera

Quote:

>when opening a recordset i need to know the value of the auto-increment
>before rec.update
>does anybody have an idea?

>thanks and regards
>oliver



Sat, 17 Nov 2001 03:00:00 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Getting value of auto-increment field after update

2. Change auto increment field value

3. Access 2000 Auto-Increment a Field value

4. Adding records to Auto-Incrementing Fields

5. HELP - Resetting Auto Increment Field

6. Help wanted...Editing Auto Increment Fields

7. Getting the value of an autoincrement or identity field during an sql insert

8. Getting the value of an autoincrement or identity field during an sql insert

9. How do I gett the value of autoincrement field after an .AddNew/.Update

10. Acc97:Obtaining Auto Number field value after adding a record

11. Newbie help: Increment field and update Access database

12. get auto increment value (in MS SQL7)

  

 
Powered by phpBB® Forum Software