Results 1 to 8 of 8
  1. #1
    willkr is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2023
    Posts
    110

    all fields deleted in newly opened form

    Occasionally I open a form on my app and all the data fields display a "deleted" message. Any idea what's causing this?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Did you search this topic? Start with https://community.spiceworks.com/top...fields-in-form
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    Usually I have seen similar with connection to SQL backend server/tables (just looked at the linked article and says same). You might want to have the form open with a blank record to start, then have them use combo box or whatever to select the specific record.

  4. #4
    willkr is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2023
    Posts
    110
    June 7, In the past your replies have been very helpful. This time, however, it was no help at all.

  5. #5
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,474
    Willkr I think that article he linked is spot on, did you read it? Sounds like the issue you are having. Is your backend SQL?

  6. #6
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Quote Originally Posted by willkr View Post
    June 7, In the past your replies have been very helpful. This time, however, it was no help at all.
    Way to go.
    That will certainly encourage others to help you.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  7. #7
    willkr is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2023
    Posts
    110
    Yes, I read the articles (several times) and I apologize if my frustration rears it's ugly head once in a while. I don't typically post a question here unless I have already done my own research, although sometimes I do get lazy.

    Thanks for all your help, guys.

  8. #8
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    willkr,

    How can this statement have any truth in it?
    June 7, In the past your replies have been very helpful. This time, however, it was no help at all.

    I agree with Bulzie. I also agree with Welshgasman.

    When you post a single line to describe a problem and you get a response that has all the features you described, it has to be helpful. Even if it is not 100% your issue, you have at least been directed to an article that provides some context for any further action you wish to take.

    Members of the forum are unpaid volunteers who offer their time and experience to advise/assist others with issues/opportunities. They are not mind-readers nor are they clairvoyant. They do not know you, your experience, your business , the context of your issue nor any related history.

    It also helps if you clearly define the problem; even provide a before and after drawing/example of what you seek. And, once you find a solution/workaround post it, it may help someone else.


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

Similar Threads

  1. Access shows only #deleted fields
    By hannlapp in forum Import/Export Data
    Replies: 8
    Last Post: 10-05-2023, 08:18 AM
  2. Replies: 6
    Last Post: 06-27-2018, 01:33 PM
  3. Replies: 2
    Last Post: 02-22-2017, 05:45 AM
  4. Replies: 1
    Last Post: 02-20-2014, 04:15 PM
  5. Replies: 7
    Last Post: 04-27-2010, 10:29 AM

Tags for this Thread

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