Results 1 to 8 of 8
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095

    Form with functionality to re-link backend

    I have Form with functionality allowing the user to re-link between different backends. All appears normal in that the form's RecordSource is as linked, but ALL the text box controls on the form now behave as though they were "Locked". I.e., text boxes get the control in a normal fashion but one cannot type into them, likewise with already populated text boxes one cannot edit the existing text. (The re-link code IS NOT new, been in use for years)

    What might cause all the text boxes to behave as though locked?



    BTW, the form has a mix of bound and unbound TB's.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Any updates?
    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

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    Yes, the user is now given two command buttons to switch from one backend to another. The ensuing re-links to the alternative backend works fine and the alternate backend context RecordSource reflects the switch as the forms RecordSource is Required. From an appearance standpoint, everything looks normal with data displayed as expected.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    No,
    I meant had you had any updates to software to perhaps cause this issue?
    However if you are still on 2013, I expect that is unlikely?
    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

  5. #5
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    I commented out the path(s) that lead to the new backend switching function, but the issue persists. Might I have a corrupted form? The other forms in the app behave properly.

    In testing the general functionality of the form, one action caused the entire Footer section to loose visibility. That smells like a corruption to me. BTW, this IS NOT a new app, but rather one many many years old.

  6. #6
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    No updates. A back level of the app functions normally. Does my post #5 suggest anything?

  7. #7
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    I'm now working on the theory that the entire App's DB is corrupted. I will get last night's backup of the app and re-apply the changes.

  8. #8
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,095
    I backed off to the previous level of code, applied the changes pertaining to the new functionality but was unable to recreate the issue in the OP. I can only conclude that I somehow managed to have corrupted the form described.

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

Similar Threads

  1. Replies: 10
    Last Post: 08-06-2021, 01:15 PM
  2. Need a temporary table link to different backend
    By GraeagleBill in forum Programming
    Replies: 25
    Last Post: 07-01-2019, 09:15 AM
  3. Link split database backend to another?
    By Cratebug in forum Access
    Replies: 5
    Last Post: 02-11-2016, 04:02 PM
  4. Replies: 21
    Last Post: 07-06-2015, 01:51 PM
  5. break the link to a backend table
    By markjkubicki in forum Programming
    Replies: 1
    Last Post: 06-28-2013, 10:49 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