EastIndian
Technical User
Can someone please tell me how to make a form open automatically upon opening the entire database project? Thank you!
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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automatic Opening of form when Access Database is opened 1
- Thread starter EastIndian
- Start date
- Status
-
1
- #2
FuzzyBear9
Technical User
Sure. Select 'StartUp' from 'TOOLS' within Access 97. Then choose the form you want to appear on startup from the drop-down box 'Display Form'.
Hope this helps.
Hope this helps.
FuzzyBear9
Technical User
Also, you may wish for the form to be maximised once opened. To do this:
1) Go to design view on the form that you have chosen to open on startup.
2) Double-click on the small black square located on the top-left corner.
3) Select the 'event' tab.
4) Click in the 'On Load' event box. Click on '...'.
5) You will see 'Private Sub Form_Load()' and 'End Sub'. Between these lines add the code: DoCmd.Maximize
6) Save and close the VBA editor.
Now when you open your database, your chosen form will be maximised.
Hope this helps!
1) Go to design view on the form that you have chosen to open on startup.
2) Double-click on the small black square located on the top-left corner.
3) Select the 'event' tab.
4) Click in the 'On Load' event box. Click on '...'.
5) You will see 'Private Sub Form_Load()' and 'End Sub'. Between these lines add the code: DoCmd.Maximize
6) Save and close the VBA editor.
Now when you open your database, your chosen form will be maximised.
Hope this helps!
- Status
Similar threads
