Results 1 to 3 of 3
  1. #1
    ecalvert47462 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    17

    data entry form is blank when it opens, when before it was not.

    I am working in Access 2010 and have a split database that multiple users use on a regular basis. We have been using this database for several years now with little to no issues..but here in the past few weeks there has been a problem with a couple of the data entry forms.



    When the form is opened it is blank white in form view, when it never has been before. But when I look at the form in design view everything is still there and appears to be fine, switching back to form view it is blank as can be. This form has not been updated or changed in any way in a long time so there are no property changes that have been made. I am the designer of it and am the only one that has the ability to do those changes and I know I have not made them.

    What would be causing to happen all of a sudden when it never has before?

  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,018
    Does each user have a copy of the Front End on their machine?

    Controls don't appear in Form View when three conditions exist at the same time:

    • The Form is Bound to a Table or Query
    • There are No Records in the underlying Recordset or the Recordset cannot be accessed
    • The Form cannot have New Records added

    The reasons that a Bound Form cannot have New Records added include:

    1. AllowAdditions for the Form is set to No
    2. The underlying Query the Form is based on is Read Only
    3. User doesn't have Read and/or Write Permission for the Folder where the Data resides or there is a connection problem with the network.
    4. Folder the File resides in (in versions 2007/2010) not having been declared as 'Trusted'
    5. Form's Recordset Type is set to Snapshot

    Given your post stating that nothing has been changed, if the answer to my question above is 'yes,' my guess would be that something has changed in your network and it is likely that #3 above is your problem. Do you have a network administrator, and has something changed there?

    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
    ipisors is offline Access Developer
    Windows XP Access 2007
    Join Date
    Sep 2013
    Posts
    119
    ecalvert-

    Please describe the nature of the form in recordsource terms. How is its recordsource set, what is its recordsource, and what are the AllowEdits, AllowAdditions, and DataEntry properties of the form set to?

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

Similar Threads

  1. Replies: 3
    Last Post: 09-27-2013, 07:56 AM
  2. Replies: 1
    Last Post: 08-21-2013, 04:51 PM
  3. Very strange issue: form opens blank
    By spleewars in forum Programming
    Replies: 5
    Last Post: 06-01-2012, 12:47 PM
  4. Replies: 7
    Last Post: 01-29-2012, 07:44 AM
  5. View all data for blank parameter entry
    By royalrochelle in forum Queries
    Replies: 3
    Last Post: 09-07-2011, 08:00 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