Results 1 to 4 of 4
  1. #1
    New Lounger SadieAnn's Avatar
    Join Date
    Jun 2006
    Location
    Fort Worth, Texas, USA
    Posts
    16
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Blank Forms, missing input fields and everything. Access 2007

    I have a multi-form MS Access program with the frontend and backend on separate servers. My inital tester, the analyst, is not having any problems but when the users test the program it works fine until they select the add new screen. The analyst confirms that the screen is totaly blank, the lables and text boxes do not show up. I'm using the following command to start the form.

    DoCmd.OpenForm "frmNew", , , acFormAdd

    This program has been in production for years. We were moving it to a new server and a new version of Access. No changes were made to the code.

    Thanks for your help,
    SadieAnn

  2. #2
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Redditch, Worcestershire, England
    Posts
    233
    Thanks
    0
    Thanked 22 Times in 21 Posts
    Quote Originally Posted by SadieAnn View Post
    I have a multi-form MS Access program with the frontend and backend on separate servers. My inital tester, the analyst, is not having any problems but when the users test the program it works fine until they select the add new screen. The analyst confirms that the screen is totaly blank, the lables and text boxes do not show up. I'm using the following command to start the form.

    DoCmd.OpenForm "frmNew", , , acFormAdd

    This program has been in production for years. We were moving it to a new server and a new version of Access. No changes were made to the code.

    Thanks for your help,
    SadieAnn
    Have there been any changes to user permissions on the server? Is it possible that your tester has a higher set of network permissions than the ordinary users?

  3. #3
    Star Lounger tgw7078's Avatar
    Join Date
    Jul 2010
    Location
    Seattle, WA., USA
    Posts
    90
    Thanks
    1
    Thanked 12 Times in 12 Posts
    Hi Sadie,

    This problem indicates that the form's recordset is returning zero records. Check the query or table that serves as the recordset for the affected form.
    Tom Wickerath
    Microsoft Access MVP
    4/1/2006 - 3/31/2012

  4. #4
    New Lounger SadieAnn's Avatar
    Join Date
    Jun 2006
    Location
    Fort Worth, Texas, USA
    Posts
    16
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks for the reply, we had permissions problems and they were corrected.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •