I'm developing using MS-Access 2000.

When I open a form in 'Form' view, how can I determine if the properties box
is open, and then how do I hide the properties box?

Thanks in advance.


Dominic

On Mon, 25 Aug 2008 09:13:27 +1000, "Dominic Vella"
<dominic.vella@optusnet.com.au> wrote:

If you deploy your application per best practices and turn it into an
MDE, you won't have this problem.

-Tom.
Microsoft Access MVP



>I'm developing using MS-Access 2000.
>
>When I open a form in 'Form' view, how can I determine if the properties box
>is open, and then how do I hide the properties box?
>
>Thanks in advance.
>
>
>Dominic

In form Design View goto Properties - Other and set Allow Design Changes to
Design View Only.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

You can use Windows apis to get the window class name of the properties
window, which is OArgDlg. You could probably use more Windows apis to close
the properties window, but it's way easier if you avoid using Windows apis.
As Linq Adams suggests, make sure you set all the forms' "allow design
changes" property to design view only.

Chris
Microsoft MVP


Dominic Vella wrote:
>I'm developing using MS-Access 2000.
>
>When I open a form in 'Form' view, how can I determine if the properties box
>is open, and then how do I hide the properties box?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200808/1

Actually, I just tried it and using the Windows apis doesn't require much
coding. Put these 3 declarations at the top of the module:

Private Declare Function _
FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, _
ByVal lpWindowName As String) As Long

Private Declare Function _
SendMsg Lib "user32" Alias "SendMessageA" _
(ByVal hwnd As Long, ByVal wMsg As Long, _
ByVal wParam As Long, ByVal lParam As Long) As Long

Private Const WM_CLOSE = &H10


Now in a procedure where you want to close the properties window if it's open,
paste this line of code:

SendMsg FindWindow("OArgDlg", vbNullString), WM_CLOSE, 0, 0


Chris
Microsoft MVP


Chris O'C wrote:
>You can use Windows apis to get the window class name of the properties
>window, which is OArgDlg. You could probably use more Windows apis to close
>the properties window, but it's way easier if you avoid using Windows apis.
>As Linq Adams suggests, make sure you set all the forms' "allow design
>changes" property to design view only.
>
>Chris
>Microsoft MVP
>
>>I'm developing using MS-Access 2000.
>>
>>When I open a form in 'Form' view, how can I determine if the properties box
>>is open, and then how do I hide the properties box?

--
Message posted via http://www.accessmonster.com

Thanks, that's excellent.

Dom

"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:892d4213fb040@uwe...
> Actually, I just tried it and using the Windows apis doesn't require much
> coding. Put these 3 declarations at the top of the module:
>
> Private Declare Function _
> FindWindow Lib "user32" Alias "FindWindowA" _
> (ByVal lpClassName As String, _
> ByVal lpWindowName As String) As Long
>
> Private Declare Function _
> SendMsg Lib "user32" Alias "SendMessageA" _
> (ByVal hwnd As Long, ByVal wMsg As Long, _
> ByVal wParam As Long, ByVal lParam As Long) As Long
>
> Private Const WM_CLOSE = &H10
>
>
> Now in a procedure where you want to close the properties window if it's
> open,
> paste this line of code:
>
> SendMsg FindWindow("OArgDlg", vbNullString), WM_CLOSE, 0, 0
>
>
> Chris
> Microsoft MVP
>
>
> Chris O'C wrote:
>>You can use Windows apis to get the window class name of the properties
>>window, which is OArgDlg. You could probably use more Windows apis to
>>close
>>the properties window, but it's way easier if you avoid using Windows
>>apis.
>>As Linq Adams suggests, make sure you set all the forms' "allow design
>>changes" property to design view only.
>>
>>Chris
>>Microsoft MVP
>>
>>>I'm developing using MS-Access 2000.
>>>
>>>When I open a form in 'Form' view, how can I determine if the properties
>>>box
>>>is open, and then how do I hide the properties box?
>
> --
> Message posted via http://www.accessmonster.com
>