Opening Access file with the form maximised

[Samuel]

I have some questions that are sort of connected. I use Access 2003.

Is it possible to set some properties that can make the Access window
open at a particular size?

Is it possible to make a form open inside the Access window so that it
fills the window completely without borders?

I have seen some databases that open and there is no outside borders and
the forms all work neatly inside. It looks like the database form is
maximised when opened and that the form fills the Access window that
opens at the correct size.

If there is anywhere that I can see some tutorials on this?

My thanks to all

Samuel Tully

[henry.onovwaka]

On Nov 9, 9:40*am, Samuel <[e-mail]:

I have some questions that are sort of connected. *I use Access 2003.

Is it possible to set some properties that can make the Access window
open at a particular size?

Is it possible to make a form open inside the Access window so that it
fills the window completely without borders?

I have seen some databases that open and there is no outside borders and
the forms all work neatly inside. *It looks like the database form is
maximised when opened and that the form fills the Access window that
opens at the correct size.

If there is anywhere that I can see some tutorials on this?

My thanks to all

Samuel Tully

Hi,

I cant particularly guess correctly what u want. But you can set the
property of a form to maximise when it opens. To do this, simply
place this code on the open event of the form:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub

This opens the form maximised.

Dont know whether this helps.

Thanks.

[Jon Lewis]

As far as the Access window is concerned you can use one of several Windows
API functions to manipulate it. e.g MoveWindow

It is declared as follows:

Public Declare Function MoveWindow Lib "user32" (ByVal hwnd As Long, _
ByVal X As Long, ByVal Y As Long, ByVal nWidth As Long, _
ByVal nHeight As Long, ByVal bRepaint As Long) As Long

The hwnd parameter is the 'handle' of your Access window for which a built
in property exits: Application.hWndAccessApp. You also need to supply the
X, Y, Width & Height you require. To make this work well (e.g. if you want
to centre the Access window) you may need to use other API functions to get
your screen resolution so you can calculate the values for these parameters.

Create a function in a standard module that uses this API.
You can then call this function on opening your database through an autoexec
macro.

HTH


"Samuel" <no*****@hotmail.comNwrote in message
news:bm******************@news-server.bigpond.net.au...

>I have some questions that are sort of connected. I use Access 2003.

Is it possible to set some properties that can make the Access window
open at a particular size?

Is it possible to make a form open inside the Access window so that it
fills the window completely without borders?

I have seen some databases that open and there is no outside borders and
the forms all work neatly inside. It looks like the database form is
maximised when opened and that the form fills the Access window that
opens at the correct size.

If there is anywhere that I can see some tutorials on this?

My thanks to all

Samuel Tully