Results 1 to 5 of 5
  1. #1
    Karaline's Avatar
    Karaline is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2017
    Location
    Just North Of Antartica
    Posts
    38

    automatic save has stopped working

    usually when i enter on form and tab to last cell it will take me to new page and automatically save data.


    this has stopped working

    i had a working macro but it is now telling me error update and won't go to new page I am useless at VBA unless it is written out for me. I can't create to save my life.

    Update or CancelUpdate without AddNew or Edit

    not sure what I can do to fix this?
    Attached Files Attached Files
    Last edited by Karaline; 02-22-2017 at 06:52 PM. Reason: uploading document to attach

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    There is no vb required to save. It is automatic when you leave a record.

  3. #3
    Karaline's Avatar
    Karaline is offline Advanced Beginner
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2017
    Location
    Just North Of Antartica
    Posts
    38
    yes, but it wont go to new page has stopped working and i have attached what is now saying to me.
    i added the calculation for my previous question to beforeupdate could that be the problem?

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Quote Originally Posted by Karaline View Post

    ...i added the calculation for my previous question to beforeupdate could that be the problem...
    What, exactly, do you mean by this? The BeforeUpdate events are Access saving either a Control's data (if ControlName_BeforeUpdate) or saving the entire Record (if Form_BeforeUpdate) and, yes, there are a number of things you could be attempting here that aren't allowed, because it prevents Access from doing just that...saving the data...we really need to either see your file or at least the pertinent code to help.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    NTC is offline VIP
    Windows 10 Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    Sorry I never open attachments: Generically speaking - when one tabs through a bound form the tab process will continue to the next record (the term 'page' is not a defined element - so that is unclear - one can have tabbed form features as well....)

    No code is needed on this. In fact, code is needed to stop this from happening - in terms of tabbing to the next record.

    There may be code in the Update event - but if you don't write code then it could be just the normal process of writing the record to the table as it advances to the next record. Code doesn't just stop working. Possibly it is data dependent and it can't find the right data - in which case it will work sometimes but not others - and you can determine which critical field is the issue.

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

Similar Threads

  1. LinkMasterField stopped working
    By PeakH in forum Forms
    Replies: 1
    Last Post: 01-25-2017, 03:56 PM
  2. Query stopped working
    By AndyC121 in forum Queries
    Replies: 3
    Last Post: 09-30-2015, 12:34 PM
  3. Subforms stopped working
    By Paul H in forum Forms
    Replies: 7
    Last Post: 06-17-2014, 09:50 AM
  4. Access has stopped working
    By mrkaye in forum Access
    Replies: 0
    Last Post: 05-22-2012, 04:09 PM
  5. Access has stopped working
    By phillb in forum Forms
    Replies: 9
    Last Post: 01-10-2012, 12:22 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