Hi,
Does anyone know how to get vb to look at an array of numbers, and then generate the next number that is not shown in an access database
For instance,
1
2
3
5
6
7
Vb will look at this in an access database and will generate the number 4. If then it does it again, it will find no gaps and so create a new number 8.
I really need help with this. PLEASE HELP ME.
I will be very greatfull
