Re: Opening dbase in full screen with no way to "back end"
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Wed, 15 Feb 2006 17:15:20 -0500
No, not 1, but =1 Include the '=' sign.
--
Joan Wild
Microsoft Access MVP
Kathy wrote:
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" wrote:
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
.
- Follow-Ups:
- References:
- Re: Opening dbase in full screen with no way to "back end"
- From: Joan Wild
- Re: Opening dbase in full screen with no way to "back end"
- Prev by Date: Re: Make a linked table secure
- Next by Date: Re: Read only option when sharing database
- Previous by thread: Re: Opening dbase in full screen with no way to "back end"
- Next by thread: Re: Opening dbase in full screen with no way to "back end"
- Index(es):