Software

Ask something
Discussion Locked

Full Screen Access 97 DB

0 helpful
6 replies

by parier 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a way to either hide access when a form, or report is open so users only see the reports or forms at any time.
-OR-
Is there a way to have menus/reports/forms absolutely full screen and not to ave access visible at all.

6 replies

by dklippert

Go to Tools>Startup and choose which form or report to display. You can also choose not to display the Database window. (Use F11 to show it later on).

by parier

This wasn't reall yth equestion, the question is how to HIDE Access and only show the FORM or REPOT. I know about hiding the database window, but I have seen databases that are totally full screen and cannot be minimized, but could not seem to find out how.

by acosgrove

Your best bet is to create macros to open and close forms. Basically, you can create a menu which is simply a form with command buttons to open and close your other forms. Access has a feature called Switchboard manager which will do this for you. Assign each button on the menu to run a macr and program the macro to close the existing form before opening the new form and then have a button on the form you're opening which will close that form and open up the menu form again. This may make the database run slightly slower, however, because it has to reload each form before it displays. On a computer with more then 32MB of RAM this delay should be minimal. Mostly the older systems had problems with this.

Reports are more difficult because they don't look right if you put command buttons on them and if you simply close the report window then it won't re-open the menu window so you may want to just open the reports preview maximized and eliminate the Min Max Buttons by setting it in the form properties to None.

As far as making it so the users cannot minimize or resixze the windows, go the the form properties for each form and set each of the following as stated:

Border Style -> Thin
Min Max Buttons -> None

Thiswill open the form so that the Minimize and Maximize buttons are not there and the border cannot be resized.

Good Luck

by acosgrove

PS...
As far as adding the MS Access menus and buttons, the only thing you can really do is create custom toolbars. You can make it so the only menu item there is File -> Exit but you can't eliminate it completely unles you create a Visual Basic front end for the database and this gets very complicated and unless you plan on selling the database it's probably not worth it. I would just set up the toolbars you want through access and make the changes I mentioned above. This should be what you're looking for.

by parier

I saw the requested task perfomred very easily before and I canot seem to get ahold of the person who did it, thank you anyway for your support. If you do come to an answer, email me at eparisek@mtga.com adn I will reopen the question and awardthe points to you.

This discussion is closed to new replies.