Results 1 to 4 of 4
  1. 01-07-2016, 06:23 AM #1
    dbingham629
    dbingham629 is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    1

    Can't add new records

    I have created a query and, although it was working originally, I now can't add new records. Why is this?
    Click image for larger version.  Name: Slide1.JPG  Views: 9  Size: 106.7 KB  ID: 23294

    Reply With Quote Reply With Quote
  2. 01-07-2016, 06:32 AM #2
    cyanidem's Avatar
    cyanidem
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    Maybe you've changed Recordset Type to something other than Dynaset (Inconsistent Updates)?
    Reply With Quote Reply With Quote
  3. 01-07-2016, 08:52 AM #3
    newbieaccess203
    newbieaccess203 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2016
    Posts
    21
    when you try to add record, what happens ? does it give any error message ? what message ?
    Reply With Quote Reply With Quote
  4. 01-07-2016, 09:12 AM #4
    ItsMe's Avatar
    ItsMe
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    What is the SQL of the query? Did you change settings to the Tables' relationships via the Relationships Window?
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Query bringing up all Matched Records AND Newly added records...
    By CazzaGal in forum Queries
    Replies: 1
    Last Post: 10-12-2015, 09:02 AM
  2. Crosstab Query to include all records from two tables/querys to count no of records.
    By venus in forum Queries
    Replies: 4
    Last Post: 03-29-2014, 01:29 AM
  3. Multi-select records from subform to create records in new table
    By robtperk in forum Forms
    Replies: 2
    Last Post: 05-28-2013, 04:00 PM
  4. Count total number of records and specific records in a query column
    By IzzyKap in forum Queries
    Replies: 1
    Last Post: 01-24-2013, 05:50 PM
  5. Access 2007 - Creating New Records Based on Existing Records
    By GeorgeAugustinePhillips in forum Forms
    Replies: 9
    Last Post: 10-05-2011, 05:58 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums