Results 1 to 2 of 2
  1. #1
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314

    I Access messed up?

    I have a database which, among other things keeps a history of status changes of assets. Assets is the parent and Assets_Trans is the child. As I attempted to add new statuses today, they disappear from the sub-form, after the sub-form is refreshed. No new statuses added today will display in the sub-form after the sub-form has refreshed, or if I return to the same asset.

    I had added new asset transactions (Statuses) as late as 2/12/19, and when I go to those assets in the main form, all these status records and earlier status records display properly in the sub-form.

    When I checked the table directly today, I find that all the new statuses I created today, did in fact, get created and linked to their assets. But no asset statuses that I add now, will display in the sub-form, while all the statuses I added earlier, do display.

    I had not modified this main form or sub-form. I tried repairing the db with the "Compact and Repair" feature, but that had no affect. I went back to earlier backup copies of the db, testing several earlier in February and in January, and found the same behavior.

    This issue seems to be related to Access itself and not to the db. I see Office 365 ProPlus shows an Install date for today, 2/26/2019. It would appear something happened to Access with this new update.

    I just talked to Office Support explaining the issue. I tried fixing the Office products and it did not change the behavior. All he wants to do is help me find a MS Partner.

    Any Ideas?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I too have had these forms misbehave. The form works, then it doesn't.
    I rebuilt it from scratch and that seemed to help.
    But I never found a reason why the old one works 1 day, and not another.

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

Similar Threads

  1. Help| Display mode is messed up
    By Celtic in forum Access
    Replies: 9
    Last Post: 06-14-2018, 09:01 AM
  2. Posting dates messed up!
    By ArviLaanemets in forum Forum Suggestions
    Replies: 2
    Last Post: 11-21-2017, 04:40 PM
  3. Messed up and need help
    By Diasflac in forum Access
    Replies: 1
    Last Post: 07-17-2013, 02:15 PM
  4. Messed up Listbox
    By mikewj1900 in forum Access
    Replies: 7
    Last Post: 08-10-2012, 11:54 AM
  5. Access 2007 & 2010 window title bars messed up
    By manhattanite in forum Access
    Replies: 4
    Last Post: 01-03-2012, 10:51 AM

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