Access 2007 - Property Sheet

[LadyDi]

I just got Access 2007 on my computer and for some reason, it will not allow me to view the properties for a field, much less a form or report. I have right clicked on it and selected Properties. I have gone to the Design tab and clicked on Property Sheet. Either way I do it, nothing happens. How can I get to the properties for my form?

 

[NigelShaw]

Have you clicked the large properties button on the database tools tab? It looks like a notebook page with a big finger pointing.


Nidge

 

[boblarson]

Are you in design view for the form?

 

[LadyDi]

I am in the Design View.

It still does nothing, when I click on the Property Sheet on the Database Tools tab.

 

[boblarson]

Do you also have the EXISTING FIELDS button down? If so, try unselecting it.

 

[shadow9449]

Welcome to another Access 2007 "feature". I spent about 45 minutes on this when I first got Access 2007.

Here's what you do:


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



The properties sheet will be enabled.

Good luck

SHADOW

 

[LadyDi]

I'm afraid I don't know what you mean. Where is the Existing Fields button? If you are referring to the Add Existing Fields button right next to the Property Sheet button, I tried clicking that several times. Nothing happened.

 

[shadow9449]

Have you tried my solution...?

SHADOW

 

[LadyDi]

Adding that code did the trick. I can now see my property sheet. Thank you very much.

I'm afraid, I have run into another problem. It has just decided not to find one of my queries. The query is there. I can open the query and go to design view and everything. However, when I click on the subform based on this query and look at the properties, I get this message: "Could not fine file 'C:\Program Files\Microsoft Office\OFICE11\utility.mda'." What does that mean?

 

[shadow9449]

Adding that code did the trick. I can now see my property sheet. Thank you very much.

You're welcome.

Does this help?

http://answers.yahoo.com/question/index?qid=20070507154350AACgTiu

SHADOW

 

[LadyDi]

That does help. It works perfectly. Thank you again. I really appreciate your help.

 

[shadow9449]

That does help. It works perfectly. Thank you again. I really appreciate your help.

Most welcome

 

[LadyDi]

I have a quick question. I entered this line of code (
CommandBars("Property Sheet").Enabled = True) on a button in my database, so that I did not have to enter it every time I wanted to access the property sheet. When I click on the my button, I get an error message stating "Invalid procedure call or argument". When I tell it to Debug, it highlights this line of code. However, if I click end, it still allows me to view the property sheet. Is there any way to stop this error message from coming up?

 

[shadow9449]

I have a quick question. I entered this line of code (
CommandBars("Property Sheet").Enabled = True) on a button in my database, so that I did not have to enter it every time I wanted to access the property sheet. When I click on the my button, I get an error message stating "Invalid procedure call or argument". When I tell it to Debug, it highlights this line of code. However, if I click end, it still allows me to view the property sheet. Is there any way to stop this error message from coming up?

If you're getting it, I would guess that it's because the property sheet is already enabled. Maybe you can test first:

If CommandBars("Property Sheet").Enabled = False then
  CommandBars("Property Sheet").Enabled = True
End if

SHADOW

 

[LadyDi]

That did it! I don't get that error message anymore. Thank you so much for your help.

 

[shadow9449]

Most welcome. Glad I could help.

SHADOW

 

[pdbishopii]

Welcome to another Access 2007 "feature". I spent about 45 minutes on this when I first got Access 2007.

Here's what you do:


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



The properties sheet will be enabled.

Good luck

SHADOW

When I hit Enter it just moves to the next line. Property Sheets are still not enabled. I also tried Ctrl-Enter, Alt-Enter, Shift-Enter... you get the idea. I'm working in 2007.

 

[shadow9449]

When I hit Enter it just moves to the next line. Property Sheets are still not enabled. I also tried Ctrl-Enter, Alt-Enter, Shift-Enter... you get the idea. I'm working in 2007.

Are you in the Immediate Window? I don't think it gives any message that the property sheet is enabled or anything, so check again?

SHADOW