Results 1 to 13 of 13
  1. #1
    sjacksontx is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    7

    Command Button in Form Can't View Properties


    I created a database which I have been using. All of a sudden now I cannot view the properties of the command button on a form. I go to design view and right click then click on properties and it doesn't do anything. Help please.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Possible corruption. Can you create another button to replace?

    Be sure to run Compact & Repair after design edits.
    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.

  3. #3
    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
    Can you view the Properties of other Controls on the Form?

    Linq ;0)>

  4. #4
    sjacksontx is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    7
    Looks like I can view properties on another computer with same database so does that mean my Access 2013 is corrupted?

  5. #5
    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
    Question still stands...Can you view the Properties of other Controls on the Form on the errant PC?

    If you cannot view the properties for any Control, it probably means that you've managed to position the Properties Pane right off of the viewing area. I've heard of it happening, but can't remember, right off hand, how you correct it. Let's see if that's the problem and if so, we can look for the solution!

    Linq ;0>

  6. #6
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Missinglinq probably has it right. I had the similar problem when using two monitors. It was there, I just couldn't see it until the monitor issue was rectified. If you're not using two monitors and cannot find the window, try setting the screen resolution much higher to see if that exposes it.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Can you see the properties dialog for anything?

    I've experienced the lost window phenomenon with frontend and using 2 monitors, but never in design view.
    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.

  8. #8
    sjacksontx is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    7
    I can right click and the window pops up where I can choose build event or all the way to bottom is properties. I tried clicking on form properties and properties but nothing shows.

  9. #9
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    I still maintain you should try altering the screen resolution on the problem pc to something higher to see if it shows. That you said you could see it on another pc indicates you have an issue of where Windows remembers the location of the window when last closed on the problem pc.

  10. #10
    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
    Quote Originally Posted by Micron View Post

    ...I still maintain you should try altering the screen resolution on the problem pc to something higher to see if it shows...
    Absolutely; this must be the first thing you try! Set your screen's resolution as high as it will go and if the Property Pane appears, pull it back to the center of the screen, close Access, and return your screen's resolution to the normal setting.

    Linq ;0)>

  11. #11
    sjacksontx is offline Novice
    Windows 8 Access 2013
    Join Date
    Mar 2015
    Posts
    7
    My resolution was already at the highest so I messed with it for awhile. Still can't see properties. Any other ideas?

  12. #12
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Try it on another computer to see what happens.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

  13. #13
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Seeing it on another pc as you say means that there is nothing wrong with the db unless maybe:
    you opened it in a different manner (e.g prevented code from running that manipulates command bars). See threads like http://www.access-programmers.co.uk/...d.php?t=131548.
    OR
    it was not you who opened it on pc2. Apparently it can be a user profile problem.
    See http://bytes.com/topic/access/answer...-access-2007-a .
    OR between the two pcs, you are using two different versions of Access. If it was converted to another version on another pc, apparently this could do it.
    You could try this in the immediate window: CommandBars("Property Sheet").Enabled = True and press Enter

    If those don't apply, then what's not clear is whether or not your pc ever had a dual monitor setup, either for you or another user who had it before you. Perhaps it did and you are not aware of it. Windows controls window size and placement of windows, not Access (unless you code for it), so I doubt it is an Access problem on your pc. Reinstalling Access or rebuilding your db will likely amount to nothing beyond needless work. What you describe did happen to me once and I am embarrased to say that I was very new to the 2 monitor setup and miracuously resolved the issue by turning on the second monitor! I am convinced that the properties window would remember which monitor it was on since I have noticed that when I re-open an application or one of its child windows, (including the Access property sheet), it will appear on the right monitor where I last closed it on my extended desktop. Notwithstanding the first suggestions in this post, my first inclination would be to connect a second monitor and see if you can find the window. If not, then Google something like "windows API calls" and you will find stuff, but you will have to find one that gets the window handle and another that moves it. Good luck and be sure to post when you solve it!

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

Similar Threads

  1. Replies: 8
    Last Post: 06-25-2014, 08:03 AM
  2. Replies: 6
    Last Post: 05-09-2014, 09:03 AM
  3. Replies: 4
    Last Post: 08-15-2013, 08:33 AM
  4. Replies: 1
    Last Post: 07-13-2012, 08:50 AM
  5. Replies: 1
    Last Post: 07-27-2010, 02:27 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