My VBA experience to this point is rather limited. Hopefully that will be changing soon. What I wish to do is create a primary key for a table based on the date and the number of records created on that date.
My hopes is to have the data shown as an integer in the following format.
yymmddrec#.
I wish the record # to restart as 0 at the start of each new day and increment by 1 with each additional record.
The first record of today would generate the number 00121900 with the next being 00121901 and so on.
Any help or direction in this would be greatly appreciated
My hopes is to have the data shown as an integer in the following format.
yymmddrec#.
I wish the record # to restart as 0 at the start of each new day and increment by 1 with each additional record.
The first record of today would generate the number 00121900 with the next being 00121901 and so on.
Any help or direction in this would be greatly appreciated
