Results 1 to 5 of 5

Creating Table with sql or vba

  1. #1
    BatmanMR287 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Jan 2014
    Posts
    69

    Creating Table with sql or vba


    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.

  2. #2
    Ajax is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,628

  3. #3
    BatmanMR287 is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Jan 2014
    Posts
    69
    Access says this is a syntax error.
    ID int NOT NULL AUTO_INCREMENT

  4. #4
    Ajax is online now VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    7,628
    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

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,453

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 01-27-2014, 12:41 PM
  2. Help creating Table
    By roderick in forum Database Design
    Replies: 5
    Last Post: 08-13-2013, 09:24 AM
  3. Creating Multiple Name Table?
    By zileega in forum Queries
    Replies: 1
    Last Post: 02-03-2012, 12:14 PM
  4. Creating an If Then in a table
    By Mommo in forum Access
    Replies: 2
    Last Post: 08-07-2011, 10:51 AM
  5. Creating a Form without a Table
    By ronocoo in forum Forms
    Replies: 11
    Last Post: 05-21-2011, 04:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums