-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Default value in new table record
- Thread starter Pettor
- Start date
maabadi
Well-known Member
- Joined
- Oct 22, 2012
- Messages
- 2,681
- Office Version
- 2019
- 2016
- Platform
- Windows
Yes. at the second row of Specific Column( I suppose it is column D) Write = Above Cell + 1
for example if your table first row after header is Row 2 & Specific Column is column D then
you write at D3 = D2+1 then autofill down
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,832
- Office Version
- 365
- Platform
- Windows
I don't think that maabadi realized that you posted this in the Microsoft Access Questions forum and gave you an Excel answer.
Access works very differently than Excel. The records really have no order within a table. Someone once gave a good description, saying think of records in a table like a bag of marbles, all jumbled up. So there really is no relative position of one record, as compared to another. If you were to sort them in a query, you could them loop through them in whatever sort order you determined.
To do what you want, you would use VBA that says every time a new record is added, find the maximum value in that field, and add one to it.
If you control all new record entry through a Form, you can just add the VBA code when a new record is submitted.
If you import the records, you can run some VBA scripts after import.
Note that users should NEVER enter records directly into the Table. You want to control all their data entry via Forms.
Access works very differently than Excel. The records really have no order within a table. Someone once gave a good description, saying think of records in a table like a bag of marbles, all jumbled up. So there really is no relative position of one record, as compared to another. If you were to sort them in a query, you could them loop through them in whatever sort order you determined.
To do what you want, you would use VBA that says every time a new record is added, find the maximum value in that field, and add one to it.
If you control all new record entry through a Form, you can just add the VBA code when a new record is submitted.
If you import the records, you can run some VBA scripts after import.
Note that users should NEVER enter records directly into the Table. You want to control all their data entry via Forms.
Upvote
0
Similar threads
