Results 1 to 7 of 7
  1. #1
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283

    Form works in 1 db but is completely blank in another

    I have an old mdb that I am trying to migrate some of it to a new ms access 2013 accdb. I have moved the form, any underlying vba, have the right table linked in the new db but when I go to form view it shows completely blank.....just a white screen and if I look at the record count it shows _ of _

    It works fine in the other db. I have checked all of the usual suspects, visible, display when, read only, access to tables, queries returning no records etc.



    The form's record source is a linked table (that I can open and see data) and if I compare All properties side by side after exporting from the original to the new db, they are all identical

    I can't figure this out...driving me nuts.

    Any advice?

  2. #2
    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
    Has the folder holding the Table been declared as 'Trusted' in the new installation of Access? This has been a requirement since v2007.

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

    All posts/responses based on Access 2003/2007

  3. #3
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    Quote Originally Posted by Missinglinq View Post
    Has the folder holding the Table been declared as 'Trusted' in the new installation of Access? This has been a requirement since v2007.

    Linq ;0)>
    They are both on My desktop.

  4. #4
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    Quote Originally Posted by Missinglinq View Post
    Has the folder holding the Table been declared as 'Trusted' in the new installation of Access? This has been a requirement since v2007.

    Linq ;0)>
    Here is some more info after playing with it for the last little bit. If I set the Data Entry Property to No it displays everything fine just shows all the records. If I set it to Yes (Which it needs to be) the form is all white with no controls or anything visible, just a white screen.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Sometimes weirdness is corruption that can't be fixed.

    Rebuild the form and see if the issue persists. Copy/paste controls and code to a new form object. If that doesn't fix then try building entire form and its controls from scratch.
    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.

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Possibly you are not working with exactly the same tables in both db's and you have met both condition a) and b) here:
    http://allenbrowne.com/casu-20.html
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  7. #7
    mindbender is offline Competent Performer
    Windows XP Access 2007
    Join Date
    May 2013
    Posts
    283
    I rebuilt the form and after a few tweaks it seems to be fine now.....you were right sometimes weirdness is corruption

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

Similar Threads

  1. Replies: 1
    Last Post: 01-31-2018, 04:06 PM
  2. Replies: 7
    Last Post: 03-03-2017, 05:12 AM
  3. Replies: 4
    Last Post: 01-20-2016, 02:24 PM
  4. Replies: 6
    Last Post: 01-24-2014, 07:57 AM
  5. Replies: 6
    Last Post: 09-02-2012, 04:30 PM

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