AutoNumber in Access

  • Thread starter Thread starter Mathew
  • Start date Start date
M

Mathew

I basically have my VB.Net Program written. I was
wondering if I have to do anything on VB.Net end with the
AutoNumber field that I have in Access so it will
automatically update to the next number?
 
Make sure theDataColumn that maps to the autoincrement field has its
AutoIncrement Property set to true. Then, set the AutoIncrementStep to -1
(which will ensure that you never submit values which already exist to the
db). When you submit the update, Access will change the negative values to
conforming ones.

HTH,

Bill
 
Now my AutoIncrement field is set as a display only field
right now. Will that matter?
 
Matthew: If you have a field that you don't want updated, you probably want
to keep it invisible from the UI.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Next Autonumber Value 2
How can I avoid Autonumber skipping in MS Access ? :vb.net 2008 9
Getting the value of the next Autonumber 4
Retrieve the last entered record 3
VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView 7
MS Access - Get new Autonumber value after DataAdapter.Update 9
Access Autonumber Feature 3
autonumber queestion 3

Back
Top