Auto maximizing?

M

MikeJohnB

The Maximise bit is easy in either VB or a Macro. I haven't used Macros for
years so I cant advise on that but I remember its easy. (I think its
something like run command and select Maximise from the options.

The VB is easier.
With any of the forms you want to open full screen selected in design view.
Select the form properties. Right click the little square box where the two
horizontal and vertical rulers come to gether at the left top of the form.
Select the properties.

Search down the properties for the on open event. Click the little box with
three dots ... at the right of the row and select Code Builder.

You will see now the vb code editor windows.

You will also see that there are already two lines of code with the cursor
flashing in the centre.

Private Sub Form_Open(Cancel As Integer)
| (Cusor Here)
End Sub

Type the following code in the space

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

Thats it, every time the form opens, it will automatically maximise. Repeat
that code for the other forms.

The size issue is a little more difficult, You can take a look on Google web
site for a form resize

http://www.jamiessoftware.tk

Is one version available and one I have used, It has its drawbacks, it
doesn't shrink as well as it stretches the form so alway design in the
smaller screen.

Thats about all I can help with. Hope you have fun

Regards

Mike B
 
M

Melissa

Hi

I would like my forms to automatically open "maximized".

Also, i have noticed that the form sizing can be ok on my laptop and fit
into the screen, but when i open the
database on my desktop pc, the forms are too large, and you need to scroll
down to see the rest of the form?

how can i ensure that all the forms will open - maximized (i dont want to
see the "file, edit, view" options on the
menu bar, and also to ensure that the forms will be the same size on all
pc's?

thank you kindly
Melissa
 
M

Melissa

Wow! Thank you
its perfect :)

MikeJohnB said:
The Maximise bit is easy in either VB or a Macro. I haven't used Macros
for
years so I cant advise on that but I remember its easy. (I think its
something like run command and select Maximise from the options.

The VB is easier.
With any of the forms you want to open full screen selected in design
view.
Select the form properties. Right click the little square box where the
two
horizontal and vertical rulers come to gether at the left top of the form.
Select the properties.

Search down the properties for the on open event. Click the little box
with
three dots ... at the right of the row and select Code Builder.

You will see now the vb code editor windows.

You will also see that there are already two lines of code with the cursor
flashing in the centre.

Private Sub Form_Open(Cancel As Integer)
| (Cusor Here)
End Sub

Type the following code in the space

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

Thats it, every time the form opens, it will automatically maximise.
Repeat
that code for the other forms.

The size issue is a little more difficult, You can take a look on Google
web
site for a form resize

http://www.jamiessoftware.tk

Is one version available and one I have used, It has its drawbacks, it
doesn't shrink as well as it stretches the form so alway design in the
smaller screen.

Thats about all I can help with. Hope you have fun

Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B
 
M

Melissa

Wow! Thank you
its perfect :)

MikeJohnB said:
The Maximise bit is easy in either VB or a Macro. I haven't used Macros
for
years so I cant advise on that but I remember its easy. (I think its
something like run command and select Maximise from the options.

The VB is easier.
With any of the forms you want to open full screen selected in design
view.
Select the form properties. Right click the little square box where the
two
horizontal and vertical rulers come to gether at the left top of the form.
Select the properties.

Search down the properties for the on open event. Click the little box
with
three dots ... at the right of the row and select Code Builder.

You will see now the vb code editor windows.

You will also see that there are already two lines of code with the cursor
flashing in the centre.

Private Sub Form_Open(Cancel As Integer)
| (Cusor Here)
End Sub

Type the following code in the space

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

Thats it, every time the form opens, it will automatically maximise.
Repeat
that code for the other forms.

The size issue is a little more difficult, You can take a look on Google
web
site for a form resize

http://www.jamiessoftware.tk

Is one version available and one I have used, It has its drawbacks, it
doesn't shrink as well as it stretches the form so alway design in the
smaller screen.

Thats about all I can help with. Hope you have fun

Regards

Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top