Question Property Sheets in Access 2007

[pdbishopii]

Hello. This is my first posting so please put the flamethrowers on rare instead of well done if this is in the wrong spot.
I downloaded the Students template DB from the MS web site and began modifying it for my own use. The problem I have encountered is that when I attempt to access an object's property sheet, all it shows is a single tab labeled General, the object name, the type of object, a blank description field, the date and time the object was created, the date and time the object was modified, then Attributes: and one check box (unchecked) called Hidden.
I need to access the entire property sheet for all objects in my DB in order to continue modifying as I am getting errors thrown when attempting to run queries or reports.
Much obliged.

 

[pdbishopii]

thanks so much. When I open the object in design view, right click and then click Properties, nothing happens. I've tried the following

- Press CTRL G to get an immediate window
- Enter this: 'CommandBars("Property Sheet").Enabled = True' and hit Enter

When I hit Enter, the cursor moves to the next line. Also tried Ctrl-Enter, Alt-Enter, etc with the same result.

 

[pdbishopii]

Still no luck. When I click the Property Sheet icon in the ribbon nothing happens.

 

[pdbishopii]

Yes. After soliciting some assistance with a DB guru here in the office, it was determined that some Access setting needs to be enabled or disabled to allow property sheets to be accessed across the board. We created a brand new DB and were unable to access property sheets in the new DB as well.

 

[pdbishopii]

Interesting to note running the command msaccess /safe allows the property sheets to be accessed in my DB. Now I'm certain it's either a setting I have not found yet or a registry hack will need to be employed to override this feature permanently.

 

[pdbishopii]

It's working fine now. Not sure what the deal is. After running msaccess /safe it seemed to turn off the switch that was hiding the property sheets. Now I can modify them every time I open Access.