Make access look like application?

PoorCadaver

Registered User.
Local time
Today, 13:09
Joined
Oct 25, 2011
Messages
30
Hi,

Is it possible to create a .accde file or something that looks like an application when the user opens it, without all of the Access sidebars, ribbons, etc?

I can make form that looks kind of an app but there's still all the Access tools around that I don't need.
 
yes and you can selectively choose which part of the ribbon to show.
 
Where do I do that?
 
You can hide the Ribbon using...

Code:
DoCmd.ShowToolbar "Ribbon", acToolbarNo

Put the above On_Load of your first Form.

Go to Options to hide the Navigation Pane. Note, you can still get those items back by holding down the Shift Key so you may want to disable that as well. Just remember, do this in a COPY of your database, always best to leave the Master in a format you can make adjustments to.
 
This also implies several other things including that your users NEVER EVER see the database window or any navigation panels thereof, so you have to do some fancy error trapping on whatever is your main applications "face to the world" - be it a form or a switchboard or whatever you many choose to call it.

In line with Gina's suggestion, I use

Code:
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

When you follow Gina's tip about working on a COPY of the DB, you can also do things to disable special keys and control full menus by doing a File >> Options >> Current Database - to bring up a complex dialog box with a bunch of check-boxes to enable and disable certain features. You would set these on the COPY that you make public, always keeping the "real" working copy unblocked and fully "wide-open" in your private PC.
 

Users who are viewing this thread

Back
Top Bottom