User Profile

Collapse

Profile Sidebar

Collapse
jac1
jac1
Last Activity: Mar 15 '12, 05:39 PM
Joined: Mar 14 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jac1
    replied to Insert into contains autonumber field that is primary key
    in Access
    I have figured out the problem, although I still don't understand the behavior. The field "" as Amount_Paid was actually incompatible because Amount_Paid is configured as a number. I changed it to 0 and the autonumbering is now working as expected.
    See more | Go to post

      Leave a comment:

    • jac1
      started a topic Insert into contains autonumber field that is primary key
      in Access

      Insert into contains autonumber field that is primary key

      I have seen a number of responses to other questions that indicate I should be able to do the following to insert a new record into an Access 2007 database and have my primary key autonumber field populated automatically:
      Code:
      INSERT INTO D_INVOICE (Org_Code, Prog_Code, [Year], Balance, Base_Rate, Affiliate_Rate, Cost_Per_Intern, Number_of_Interns, Date_of_Invoice, Date_Due, Date_Paid, Amount_Paid, Credit_Offset, Entered_By )
SELECT Org_Code,
      ...
      See more | Go to post
      Last edited by NeoPa; Mar 15 '12, 01:16 AM. Reason: Added mandatory [CODE] tags for you.
      No activity results to display
      Show More
      Working...