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.
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.
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.
Can you view the Properties of other Controls on the Form?
Linq ;0)>
Looks like I can view properties on another computer with same database so does that mean my Access 2013 is corrupted?
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>
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.
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.
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.
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.
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)>
My resolution was already at the highest so I messed with it for awhile. Still can't see properties. Any other ideas?
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.
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.ORit was not you who opened it on pc2. Apparently it can be a user profile problem.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.
See http://bytes.com/topic/access/answer...-access-2007-a .
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!