Access 2007 property sheet disappear

[le888]

Hi,

My property sheet has disappeared I don't know what I did. How can I make it reappears? I have try by pressing the SHFIT key but it won't work. Also, I have created a new database and open it, the property sheet isn't appeared. The icon are still there but when I press on it, it does not response.


Thanks,

Le

 

[Crash_Pie]

Hi, did you fix this? I have just started using 2007 and have the same problem - can't use/see the property sheet.

I'd be interested to know if/how you solved the problem.

Thanks

 

[jepoysaipan]

Hi guys,

Hope this is not a late response, I had the issue when I initially installed my Office 2K7 and was frustrated for the whole week to find an answer, finally called Microsoft Tech Support and instructed me to run Access 2007 in safe mode:

Go to Start -> Run -> type msaccess/safe

Then close Access 2007 and re-open it in normal mode, it works like freshly installed!If that won't fix the problem shoot me a message and will give you other options.

Good Luck

 

[Crash_Pie]

Hi thanks for the reply. I don't know if your suggestion would have worked because I have just fixed the problem using another method I found on a different forum.

Here is a copy/paste of what I followed to fix it:

First, log on as a new Windows user to the computer to see if you have the same problem. If you can open Property Sheets as the new user, export the following registy key in regedit:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Settings\CommandBar­s

Then, log on as the original user, and double click the exported REG file to import it.

I made sure I backed up the registry first!

Thanks again

Crash

 

[dcurry]

I could kiss you thank you so much for the regedit info it worked I can now work thanks you thank you thank you.

 

[datAdrenaline]

The reason this happens is due typically do to the fact that the Property Sheet became part of the CommandBars collection in A2007. So if you have code that hides all your CommandBars, something like this ...

For Each obj In CommandBars
    obj.Enabled = False
Next obj

So, EVERY time you start your app ... you will disable the property sheet.

If you do this type of thing, I would suggest NOT doing it ... and instead specifically HIDE the CommandBars you don't want to have visible. Please do note that changing the visibility is different than enabling/disabling ... I typically prefer to change the visibility.

Please note that in A97 and A2003, the "Property Sheet" was NOT stored in the CommandBars collection ... so ... this is not an issue in those versions.

To remedy your immediate issue, with what I consider a much easier fix, just open the VBA editor ... get to the immediate window and type out the following ...

CommandBars("Property Sheet").Enabled = True

Then hit the enter key to execute the command ... you *should* then be able to view your property sheet as per norm.

...

Hope this helps ...

 

[Toffer]

For me i just remove all the entries under this regedit
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Settings\CommandBar­s
"ASCB1107"
"ASCB2071"

and restart the ms access then there go it appear again.. but be better to export the
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Settings\CommandBar­s
before removing "ASCB1107" & "ASCB2071" in the entrie so if something goes wrong on your access you could back it again.

after removing the entries it will reproduce again a new entries ASCB1107

hope this may help and Goodluck.. coz it work for me.. hope you understand my English hehehehehehehe..

 

[carverj]

Thanks, Toffer! That worked great.

 

[chrisguk]

Regedit solution works perfect

 

[dgodin]

This solution works great in immediate mode but I was unable to get it to work in VBA script. I am not sure what I am doing wrong. The command structure should be the same. Any thoughts?

 

[MPater]

In reply to Post no 3, I get the error message "Windows cannot find msaccess/safe".
As far as messing around with the registry is concerned, I am not confident enough to do so.