Results 1 to 9 of 9
  1. #1
    User6598 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2021
    Posts
    4

    One of my user's frontend form VBA code has disappeared after new version


    Our company has an access to that is used by about 10 users. The person who built it has since left. I am helping out to solve one user's problem and I have very limited knowledge of access. The database is split in to 10 frontends and a backend. Recently some changes were made and a new version was deployed. All the frontends except one user deployed alright. This one user's front end has forms but no modules or any code in the VBA. I am not sure why this has happened and how can it be fixed. Any expert advise is appreciated. I have been looking online since days to find some question with similar issue but I have not found a fix yet.

    Edit: I am not receiving much response on this, however I am adding an update.
    If I copy front end of one user, whose FE is functioning correctly, to a different folder location. Rename it and open it, I am able to see all the code in VBA of this renamed front end. Everything is looking good. Now can I give this copy to the user whose front end is corrupted? Or would that cause some sort of reference issues?
    Last edited by User6598; 09-12-2021 at 01:27 AM.

  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,898
    Do you mean 1 frontend distributed to 10 users?

    This one user's frontend does have table links?
    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
    User6598 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2021
    Posts
    4
    Each user have their own front end.
    say for example, front end User1, front end user2, frontend User3.. And they all work on their designated front ends only. none of them are shared.
    And all users have their front ends working as expected except User 3.
    I checked User 3's code and they have no code, and no modules.
    Where as if I check other users' front ends, they show all the code and modules intact. I checked their linked table manager and it's pointing to the correct tables (same as every other user).

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    All form module code will be removed (after a warning) if somebody sets Has Module to No in the form property sheet.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    User6598 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2021
    Posts
    4
    Quote Originally Posted by isladogs View Post
    All form module code will be removed (after a warning) if somebody sets Has Module to No in the form property sheet.
    I checked the Has Module property and it is set to Yes.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Realistically, there are only 3 ways that all the module code can be deleted
    1. Corruption can cause all VBA code to be lost
    2. Someone deletes the code manually
    3. As already stated, someone sets Has Module to No. Resetting it to Yes afterwards will not restore the code as it has already been deleted

    In the case of corruption, you would normally get a warning message that the code is unreadable.
    The other two cases can only occur due to user intervention, whether deliberate or unintentional.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,898
    Yes, but there is only one frontend file built and a copy is placed on each user's computer?

    Try copying the file again to their computer.
    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.

  8. #8
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,411
    also cross posted here with responses

    https://www.access-programmers.co.uk...to-use.319439/

    @User6598 - please read this link about cross posting


    http://www.excelguru.ca/content.php?184

    it's not wrong to do it, just a common courtesy

  9. #9
    User6598 is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2021
    Posts
    4
    This worked. The user is able to resume their tool as normal. Thank you

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

Similar Threads

  1. Text has disappeared when typing in forms?
    By MattD67 in forum Forms
    Replies: 1
    Last Post: 06-09-2020, 01:21 PM
  2. FrontEnd User Forms Only
    By raychow22 in forum Forms
    Replies: 2
    Last Post: 08-10-2017, 09:20 AM
  3. Replies: 2
    Last Post: 08-10-2015, 07:14 AM
  4. Replies: 1
    Last Post: 01-17-2013, 03:12 PM
  5. Replies: 4
    Last Post: 05-30-2012, 07:00 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