property sheet has disappeared.

[Jimcb8]

I don't know what I did, but somehow when I click on the tab nothing happens.
I checked the internet for a solution but they tell me to open any form in design mode. Go to the immediate window in VBA. How do I get to the immediate window in VBA?
I then need to enter
CommandBars("Property Sheet").Enabled
I am obviously a new user in Access 2010
I would be grateful for your help.

Jim

 

[RuralGuy]

You can load the immediate window by pressing ^G (control+G)

 

[Jimcb8]

RG,
Thanks for the reply, but I'm still doing something wrong.
1. load access 2010 project
2. click on database tools
3. click on visual basic

It loads VBA
I try control ^G and do not get the immediate window

Any help is very much appreciated.

 

[sneuberg]

If you click View on the top of the screen do you see the Immediate Window in the drop down menu as shown in the attached screen shot.

 

[RuralGuy]

I think we lost him. He's off line right now.

 

[CJ_London]

my guess he is using multiple monitors and the relevent positions have changed

 

[Jimcb8]

Thanks to all.
I see in view the immediate window, but when I click on it nothing seems to happen
I want to get to the immediate window to enter
CommandBars("Property Sheet").Enable = True hit enter key
CommandBars("Property Sheet").Top = 0 hit enter
CommandBars("Property Sheet").Left = 0 hit enter
According to this post the Property Sheet should be in the upper left corner.

Just having no luck and I can't proceed to modify my forms without this working

PLEASE HELP

Thanks for your patience
Jim

 

[sneuberg]

Try this

1. load access 2010 project
2. click on database tools
3. click on visual basic
4. click on INSERT, Module
5. Copy and paste the follow code into the module

Public Sub Test()

CommandBars("Property Sheet").Enabled = True
CommandBars("Property Sheet").Top = 0
CommandBars("Property Sheet").Left = 0

End Sub

6. click in the code so that the cursor is within the code
7. press F5 or click Run then Run user sub/form

 

[Jimcb8]

FINALLY SUCCESS

I CAN'T THANK ALL YOU FOR YOUR HELP ON THIS PROBLEM.
WHEN I GOT TO IMMEDIATE WINDOW I TYPED.

CommandBars("Property Sheet").Enabled = True
CommandBars("Property Sheet").Top = 0
CommandBars("Property Sheet").Left = 0

AND IT WORKED!! MY PROPERTY SHEET IS BACK

THANKS AGAIN

JIM

 

[RuralGuy]

Thanks for posting back with your success and solution.

 

[Libre]

Thanks to all.
I see in view the immediate window, but when I click on it nothing seems to happen
I want to get to the immediate window to enter
CommandBars("Property Sheet").Enable = True hit enter key
CommandBars("Property Sheet").Top = 0 hit enter
CommandBars("Property Sheet").Left = 0 hit enter
According to this post the Property Sheet should be in the upper left corner.

Just having no luck and I can't proceed to modify my forms without this working

PLEASE HELP

Thanks for your patience
Jim

This worked for me. Not the Enable command but the =0 commands worked. Thanks. I was going nuts trying to find that window.