INSERT with autonumber

Results 1 to 4 of 4

Thread: INSERT with autonumber

  1. #1
    Steve Griff Guest

    Default INSERT with autonumber

    Hi peeps (again)<BR><BR>If you were going to do an insert into sql statement and one of the fields was an access autonumber, what do you use?<BR><BR>NULL doesn&#039;t work here<BR><BR>"You tried to assign the Null value to a variable that is not a Variant data type. "<BR><BR>0? <BR><BR>Steve Griff

  2. #2
    Join Date
    Dec 1969

    Default RE: INSERT with autonumber

    Don&#039;t specify the field with the Autonumber in your SQL query.

  3. #3
    Eddie Campbell Guest

    Default RE: INSERT with autonumber

    You cannot assign a value to an autonumber field. It will just populate itself when you insert the rest of the data. Just leave it out of the Insert query altogether.

  4. #4
    Steve Griff Guest

    Default RE: INSERT with autonumber

    Works like a charm.<BR><BR>Cheers :)<BR><BR>Steve Griff

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts