Results 1 to 4 of 4
  1. #1
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618

    You cant go the next record?


    I googled the problem but haven't found the solution yet. When I click on Add this message comes up. We set most our pages with an event On Load Allow additions False and Allow edits False. By clicking a button it changes that. This page I recreated and no such settings yet, still it gives the error.
    Click image for larger version. 

Name:	AB2.png 
Views:	9 
Size:	223.8 KB 
ID:	35588Click image for larger version. 

Name:	AB1.png 
Views:	9 
Size:	102.8 KB 
ID:	35587

  2. #2
    Perfac's Avatar
    Perfac is offline Expert
    Windows 7 64bit Access 2016
    Join Date
    May 2016
    Location
    Centurion Pretoria
    Posts
    618
    I just solved the problem. The query was not updateable. I don't understand why. I replaced query q01Employee, with table t01Employee. Both got all the same fields, I don't understand why the query makes this query not updateable but the table does.

  3. #3
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Did you have a SELECT DISTINCT or any grouping in the underlying query ?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 5
    Last Post: 08-18-2018, 10:23 AM
  2. Replies: 4
    Last Post: 10-21-2017, 09:56 AM
  3. Replies: 4
    Last Post: 05-27-2016, 10:02 AM
  4. Replies: 4
    Last Post: 01-12-2016, 02:49 PM
  5. Replies: 2
    Last Post: 12-21-2012, 01:57 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
  •  
Other Forums: Microsoft Office Forums