How to Close Propertysheet window at startup

krunalprajapati

Registered User.
Local time
Today, 15:06
Joined
Dec 15, 2004
Messages
101
Dear all
I have created an application in Access, it has startup form set with a menu in it. when I close my MS Access window and if the Propertysheet window is opened when I close Access, than Next time when I open the Application it will open the Propertysheet window too. I want to close the window when I open my application. Is it possible?

I have MDE of that application. even when I open the MDE file it will opent he propertysheet window.

Pls help.....
 
Set the Allow Design Changes property of the form to Design View Only
should take care of it, I think.

In addition, I am in the habit of always closing the property sheet when
I am finished with it. If you close it, it stays closed until you open
it again, and vice versa.

This command toggles the property sheet but I can't see a way of programatically finding out if its open or closed:

docmd.RunCommand acCmdProperties
 
thnks

thnks

it works.
i have the habit of closing it. but when users going to use it, and if they knw Access and working on another databse of their own, and close Access with opened Propertysheet, than wht? thts why i want this.

again thnks..
 

Users who are viewing this thread

Back
Top Bottom