Customize Front End

[hjknipp1024]

I just split my DB into a front end and a back end. I only want the users to have access to 2 forms in the DB because the form already has buttons that link to all other forms and reports needed. How do I customize the front end view so that they only see these 2 forms?

 

[DavidAtWork]

From what you say, do you mean you only want 2 forms visible when the FE database opens and loads. How many other forms are there in the FE that users can navigate to.
If I'm assuming correctly, all you need to do is make all forms (except the 2 you refer to) invisible when the database opens and when a user clicks a button to open an invisible form, it opens and also makes it visible.
To control these other forms, you can set all the visibility properties either through a function you can call from an autoexec at startup or in the code when your main visible form loads.
David

 

[RainLover]

How do I customize the front end view so that they only see these 2 forms?

Why do you have other forms if no one is allowed to use them.

Have you considered simply deleting these forms if they are not being used.

 

[hjknipp1024]

The main form links to these other forms. They are for administrative purposes. They allow the users to add additional vendors, commodities, employees, etc. I ended up setting the main form to load from the navigation bar and then hiding the navigation bar all together to work around hiding the forms, queries, reports, etc. I just wanted a more secure way to achieve that end goal.

 

[hjknipp1024]

How do I make a form invisible? Where are the visibility properties?

 

[RainLover]

First of all create an MDE for the user. Keep the MDB with regular backups at different stages as this is your design master.

Hide all toolbars and menus. You will need to do this in code. Search this Forum for examples.

Disable the bypass key which will prevent users from getting into the workings of the database. Again do a search for the code to do this.

Open your Menu via an autoexec when opening the database.

If you do all of the above you will keep all the honest and curious people out of the workings of your database.

Do not make the Forms invisible. It serves no purpose if you do all of the above.

Other than that it would help if you put your Location and the Version of Access that you are using in your signature. Not all versions are the same and Locations can change certain things so without that knowledge I can only make some assumptions.

 

[Pat Hartman]

Sounds like you are missing the concept of an opening form. Set the database to open to a form that you designate as the menu for the application. It needs to have buttons that are used to run other forms. Once you have a menu and follow the other suggestions regarding making an .mde/.accde and hiding the database container/navigation pane you'll be all set.