Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating Serial numbers after the fact
- Thread starter Ilene
- Start date
Can be done by a looping macro. Create a variable field, called vNum say to store the serial numbers.
MACRO1
Find all records
Set vNum = 1 'or the start number
Records first
Set Tablename.SerialField = vNum
vNum = vNum + 1
Run MACRO2
MACRO2
Records next
Set Table.SNoField = vNum
vNum = vNum + 1
Run MACRO2
Paul Bent
Northwind IT Systems
MACRO1
Find all records
Set vNum = 1 'or the start number
Records first
Set Tablename.SerialField = vNum
vNum = vNum + 1
Run MACRO2
MACRO2
Records next
Set Table.SNoField = vNum
vNum = vNum + 1
Run MACRO2
Paul Bent
Northwind IT Systems
- Status
Similar threads
- Locked
- Question