How to set up security printscreen attached

[phatus]

hi guru's i have a question is it possible that when i open the login form only the log in form appear the tabs or ribbon will not appear here is the screenshot of what i made i disable them in current database option to hide them but its very easy to unhide again because when you click FILE menu theres a privacy option where in you can unhide them again...

what i want is to hide the one cover by yellow color.. can it be done? how?

 

[Dairy Farmer]

You can either disable the standard ribbon and have custom ribbons where you need them (lots of links available on this topic) by editing the USysRibbon table.

Example

MyHide

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="true">
   <officeMenu>
        <button idMso="FileOpenDatabase" visible="false" />
         <button idMso="FileNewDatabase" visible="false" />
         <splitButton idMso="FileSaveAsMenuAccess" visible="false" />
     </officeMenu>

</ribbon>
</customUI>

Or have the ap open in Runtime. Runtime does not allow the standard ribbon to open, only custom ribbons.

By default, the Ribbon is not available in runtime mode. This helps prevent users from creating or modifying database objects, and from performing other potentially harmful actions, such as connecting to new data sources or exporting data in ways that you do not intend. You can create a custom Ribbon, and then associate that Ribbon with a form or report. You cannot expose the default Ribbon tabs in runtime mode.

 

[phatus]

@Dairy Farmer
sir how im going to open in runtime? and the code ur pertaining where ill put it? in button in form?

 

[Dairy Farmer]

The code I gave goes into the USysRibbon table. See How to: Hide the Ribbon When Access Starts or just Google it. There are lots of simple to follow tutorias on the subject.

Runtime see Access Package and Deploy - Make your db a 'Standalone' app

 

[phatus]

i installed a runtime access 2010.. but i cant find it anywhere in my pc... how can i make my database run in runtime? any tutorial on this sir?

 

[coyote]

http://www.ribboncreator.de/en/index.php?Download
use the ribbon creator to customize your ribbon.
put only the useful buttons and it makes the application professional and easy to use.

 

[phatus]

ok sir ill try sir ill post he result if it work

 

[coyote]

download the ribbon creator and the help, install the creator and follow the help file and i assure you, your application will be totally different.

 

[phatus]

ive done it i just rename .accdb to accdr