Numeração sequencial

[Dorival]

Num campo com numeração sequencial, ao excluir um registro entre o primeiro e o último, fica uma lacuna, e ao navegar pelos botões anterior e próximo, dá erro.


Qual o código para fazer com que o Access pule o registro excluído, indo para o próximo?

[Welshgasman]

Non comprende. Lo siento.

[davegri]

In a field with sequential numbering, when deleting a record between the first and the last, there is a gap, and when navigating through the previous and next buttons, there is an error.
What is the code to make Access skip the deleted record, going to the next one?

This does not normally happen with autonumber sequencing. Are you creating your own sequence numbers?
Perhaps the best way to proceed would be to upload your database here so that we can more easily analyze the problem.

[Dorival]

This does not normally happen with autonumber sequencing. Are you creating your own sequence numbers?
Perhaps the best way to proceed would be to upload your database here so that we can more easily analyze the problem.

Não sei como postar parte do BD para analisar aqui no Fórum

[Dorival]

In a field with sequential numbering, when you delete a record between the first and the last one, there's a gap, and when you navigate using the previous and next buttons, it throws an error. What's the code to make Access skip the deleted record and go to the next one?

[davegri]

when navigating through the previous and next buttons, there is an error.

Have you created custom navigation buttons? If so, we can start with you showing that code and a .jpg of the form