Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximize form and input new record 4

Status
Not open for further replies.

TracySHC

MIS
May 5, 2005
66
US
I am a newbie to working with Microsoft Access 2003 forms, and need some advice to automate form functions. Is it possible to have a form open and be automatically maximized and ready for a new record? Where is the functionality for these features?
Thank you in advance for any and all help and advice,
TracySHC
 

Hi TracySHC,

Normally a form will open the same it was last time you saved it in design mode. so if you make sure it's maximized, it will open that way.
(if you want to make sure that the user won't minimize it, you can set the 'Navigation Buttons' property to No)

You should set the 'Data Entry' property to yes.

[to do this: there is a pop-up window called "properties" (if you don't see it, just hit ALT+ENTER). there you'll see several tabs. to change the first property above, you will have to look into the 'Format' tab, to change the second property, look into the 'Data' tab]

Helped?
Ja
 

In the form's Open event...
Code:
Private Sub Form_Open(Cancel As Integer)
    DoCmd.Maximize
End Sub


Randy
 
Also in the forms Close event

Code:
/Private Sub Form_Close(Cancel As Integer)
    DoCmd.Maximize
End Sub

or all subsequent forms will be maximized.
 
Actually, the form is already Maximized! I suspect jkl0 meant

Code:
Private Sub Form_Close(Cancel As Integer)
  DoCmd.Minimize
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top