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

[Guest]

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). 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?

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?

Thank you!

 

[Joan Wild]

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.

 

[Guest]

Thanks, when I put a 1 in the "Menu bar" line in the form's properties and
then switch to view I get an error that says it can't find "macro 1". SHould
I be putting it somewhere else? Also, would I have to do this in all the
forms the users navigate through?

As for the solution using text boxes for criteria. I think I understand it.
I just haven't tackled that one yet.

 

[Joan Wild]

No, not 1, but =1 Include the '=' sign.

 

[Guest]

Worked like a charm!

Now to get to work on the other solution you gave me.

Thanks!

 

[Guest]

You can get a form to take up the whole computer screen - no windows taskbar,
no access titlebar, no menubar, no scrollbars.

Set the properties for the form to
Border Style: None
PopUp: Yes
And then resize it to be the size of a whole screen (a bit of trial and
error required 'cos access measures in cm and your screen will be in pixles)

Try setting the form property Modal to Yes, this will stop your user
switching forms unless you make a button to do so.