Re: Opening dbase in full screen with no way to "back end"

Kathy wrote:
Please excuse the novice, here.

I have a database that I want to open viewing a form (the
"switchboard") full screen, without allowing users access to editing
options. I went into Tools and StartUp and adjusted the Advanced
menu so that it does limit the menus and launches the form. What I
want to change is: (1) I still see Access menus on the top (although
limited).

You can create a custom menu and specify that in Tools, Startup - default
menu.
If you don't want any menu at all you can set the form's menubar property to
=1

I want to fill the screen with these forms, and (2) One of
the reports accessed from the "switchboard" is fed by a query that
asks for them to type in criteria. If in that pop up screen they hit
cancel, it closes everything and pops them to the basic database
screen which lets then access tables, queries, forms, etc and hit the
design button. This is scary! How can I eliminate that?

You can create an unbound form with some textboxes to gather the criteria
from the user. Then change the criteria in your query to reference this
form like
Forms!FormName!ControlName
substituting the name of your form for FormName and the name of the control
for ControlName.

Then add a button to the form that opens your report.
DoCmd.OpenReport "Report Name", acPreview

I did a search and found what seemed like a solution for launching to
full screen, but it involved coding, which I don't know. Are there
any easier solutions?

If you mean you want to get rid of the Access application window entirely,
no there is no easier way to do that.


--
Joan Wild
Microsoft Access MVP



.