Results 1 to 10 of 10
  1. #1
    shuddle is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    43

    Unable to access form

    I'm taking a shot in the dark here but thought by chance someone might have an idea of what might be going on.

    I have a database that is shared by several users on a common server drive. I have one user that is unable to access one particular form. Everyone else can access the form. This user can access all the other features of the database just not this one particular form.

    I tried saving the database and see if she could access it on a copy of the database but that didn't work either. I've Compact & Repair the Database.

    Any thoughts?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    Is there code on the form? if so what is the code? which references are you using to run the code, and is this form the only form in your database using a particular reference? Is the problem user generating an error message when he tries to open the form? If so, what is the error number/message. if it does not generate an error does the database crash or does the form simply not open?

  3. #3
    shuddle is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    43
    There is no code on the form and no error message. It simply doesn't open. Database stays intact.

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    I'd suggest posting a sample of your database if you are still having problem. It's almost impossible to diagnose your issue with the lack of information.

  5. #5
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Do your users login? Is there code to restrict access depending on login?

  6. #6
    shuddle is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    43
    No there is no login for the users.

  7. #7
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I have one user that is unable to access one particular form.
    Does this mean via some process, or can she not open the form directly from the Nav pane either? Can she see it in the nav pane?
    You might have to post a zipped db copy as suggested. Another thing you could do is write a little sub in a standard module that iterates over all the loaded forms when you expect this one to be open but can't see it. If it shows up in the immediate window list, it's open but hidden.
    Last edited by Micron; 08-15-2017 at 02:50 PM. Reason: added info
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  8. #8
    shuddle is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    43
    I understand I am tying everyone's hand but I am unable to upload a copy of the database for security purposes.

    If the form is hidden, how would I unhide it?

  9. #9
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If the form is hidden, how would I unhide it?
    That is putting the cart before the horse (kinda). First figure out if the form is open but hidden. When you think it should be open, try this in a standard module:
    Code:
    Sub CheckForHiddenForm()
    Dim frm As Form
    
    For Each frm In Application.Forms
    If CurrentProject.AllForms(frm.Name).IsLoaded Then
      Debug.Print frm.Name & "Visible Property = " & frm.Visible
    End If
    Next
       
    End Sub
    If you find your problem form to be open but not visible, then how to fix it depends on what's causing it. The procedure above won't distinguish between forms that are hidden and are supposed to be, just those that are open (loaded) but not visible because the .Visible property is set to false. Should the form be open, but not visible because opening code sets its position way off of the screen real estate, then the code should report the problem form as being open but visible. Then you have a different problem.

    There's only so much we can do when we can't see. If you can't post a copy with minimal dummy data to illustrate the problem, and the above doesn't help, then there's not much more I can think of to help.
    Last edited by Micron; 08-17-2017 at 12:56 PM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  10. #10
    shuddle is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2016
    Posts
    43
    It all the sudden started working again. Thanks for the help anyway.

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

Similar Threads

  1. Replies: 1
    Last Post: 02-23-2015, 07:06 AM
  2. Unable to open Access Form
    By kris24 in forum Forms
    Replies: 1
    Last Post: 03-24-2014, 05:07 PM
  3. Replies: 62
    Last Post: 01-28-2014, 06:24 PM
  4. Replies: 12
    Last Post: 07-25-2013, 12:49 PM
  5. Replies: 1
    Last Post: 06-26-2012, 10:02 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