473,386 Members | 1,860 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

The Property Sheet for MS Access 2007 didn't appear

Dear All,

Please help me how to enable the Ms. Access Property Sheet, it was not appear even I used this command in immediate window. "Commandbas("Property Sheet").enabled=True".

Thanks first for all supporting.
Oct 22 '13 #1
1 4706
zmbd
5,501 Expert Mod 4TB
ngvibol
You're not being clear here.
What properties are you tring to get at?
What is the operating system of your computer?
What version of Access/Office are you using? (I'm guessing it's Acc2007/2010 based on the VBA command you attempted).

Also, just in case this isn't a typo in the post, Commandbas("Property Sheet").enabled=True
Should be CommandbaRs("Property Sheet").enabled=True

[Edit]
Open the form in design mode
[/Edit]

Try re-typing the correct syntax in the immediates window (shortcut <ctrl><g> , in Access 2007/2010 you can do this from the main GUI and it will open the VBE and the IW.)

Once you've entered this command correctly
Next:
Open form in design mode, [F4]

Next:
Acc2007/2010
Open form in design mode
Ribbon>[Form Design Tools>Design>Property Sheet]
Note that the Form Design Tools is a context ribbon. The from must be open in design view and selected or a control in the form selected for this ribbon to appear.

If none of this works... go back and find your code that you used to disable the commandbars. I would suspect it looks like this:
Expand|Select|Wrap|Line Numbers
  1. For Each obj In CommandBars
  2. obj.Enabled = False
  3. Next objSo
Change line 2 from "false" to "true" and have that code re-execute. Now try your property sheet. If this works then you need to find a different method of doing what you are doing.

Finally see if this helps:
Close your Access and any office programs
On the desktop
Go to Start -> Run -> type msaccess/safe
Oct 24 '13 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Eugene | last post by:
Hello All, I need a report in Access 2007 to show a dynamic image on every page. I have a table, and I store image's path in a cell in each of the rows. In 2003, I was able to do that using...
1
by: imagirlgeek | last post by:
I sure hope someone else has seen this, because I'm about to go crazy! I am unable to open Property Sheets anywhere in any of my databases...even a brand new one. Right-click Properties brings...
2
by: bobdydd | last post by:
Hi All I am just getting to grips with Access 2007 and one of the quirks I have found is that when I design using Windows in XP Windows-Classic colors and set the text boxes on forms' special...
4
by: Neil | last post by:
Just found out that the Microsoft Rich Textbox does not support full text justification, since it's based on Version 1.0 of the RichEdit Window Class, and full text justification is only available...
16
by: Neil | last post by:
I posted a few days ago that it seems to me that the Access 2007 rich text feature does not support: a) full text justification; b) programmatic manipulation. I was hoping that someone might...
10
by: Arno R | last post by:
Hi all, So I bought a new laptop 10 days ago to test my apps with Vista. (home premium) Apparently Office 2007 is pre-installed. (a time limited but complete test version, no SP1) So I take the...
2
by: Wayne | last post by:
Has anyone found the "Alternate Background Color" property in Access 2007 forms to be buggy? As I scroll a continuous form that is using an alternate background color for every second record, the...
19
by: sphinney | last post by:
My company is in the process of upgrading everyone to Access 2007. Since my machine was upgraded I've been highly frustrated with an apparent random behaviour byAccess that I can't understand. It...
1
by: beemomo | last post by:
I am having problem to display the property sheet of MS Access 2007. I have tried to press and hold the Shift key while opening the database as well as pressing the F4 key after opening the...
0
by: efarley | last post by:
Hello can anyone provide me with a way I can access the members of the PivotTable Property in Access 2007? I am writing an Office 2007 Training application and one of the objectives in Access is...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.