I need to create a table with a query or vba code that has autonumber. This will be connected to a button on the navigation form for end user convenience.
I need to create a table with a query or vba code that has autonumber. This will be connected to a button on the navigation form for end user convenience.
You use a create table query - here are some links
http://www.sqlcourse.com/create.html
http://www.w3schools.com/sql/sql_constraints.asp
Access says this is a syntax error.
ID int NOT NULL AUTO_INCREMENT
you are probably using the wrong keywords - here is another link
https://msdn.microsoft.com/en-us/lib...ffice.12).aspx
also look through the two tutorials for more information or google 'access sql create table' for more links