How to make or set this as autonumber in msaccess-vb database?
from 00-00-00 up to 9999-9999-9999
how to make that code to become autonumber?
and
what code can i use in my database when the new entry is equal to existing ?(The same primary key)
How to make or set this as autonumber in msaccess-vb database?
from 00-00-00 up to 9999-9999-9999
how to make that code to become autonumber?
and
what code can i use in my database when the new entry is equal to existing ?(The same primary key)
You cannot do this as autonumber, it utilises a long integer data type. If you are adding the data using a form you can add code to the Before_Insert event to generate the number for you.
if you moved to SQL-Server for the database engine you could add a trigger to the database to achieve the same thing at the database level.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.