General :: Hide / Show Ribbon Tabs / Areas

Sep 28, 2012

The user wants all the non-basic functionality of the ribbon hiden. To accomplish that by doing the usual stuff:

File >> Options >> Current Database >> Allow Full Menus (unchecked)

Everything worked as expected, but we came across an issue. The user needs to open a report in "print preview" and they need to be able to export their report to excel. The "print preview" ribbon tab is there, but it is not showing the "Data" area, where all the export options are.

How can I do this without a costume ribbon?

Maybe there is a way of manipulating which areas of the ribbon/tabs/areas/controls are enabled from VBA?

View Replies


ADVERTISEMENT

General :: Remove Or Hide File Tab On Custom Ribbon

Apr 23, 2013

In Access 2010 I made a custom ribbon.The File Tab still gives users access to features that should not be available to them such as: Compact & Repair, Encrypt etc.I spent a few hours looking for a solution but found none that works.It does not seem to be possible to hide the File Tab, but is there a way to hide the options it reveals?

View 3 Replies View Related

General :: Hide Table Pane Navigation Ribbon And Main Form Tab

Jun 2, 2015

i have built an application , all i have is one main form and every action take place inside it. Before making it as .accde file for code protection, i want to hide table pane, navigation ribbon, the Main form Tab. i.e only Main form should open like a applicaiton and not inside access as a tab.

View 1 Replies View Related

General :: Hide External Data And Database Tools Tabs From Access?

Jan 17, 2015

i want to hide external data and databasetools tabs from my access program.

how i do it ?

View 3 Replies View Related

Forms :: Restrict Ribbon Tabs To Users

Nov 29, 2014

I want to restrict the users to only be able to access certain tabs in the ribbon .example "user1" cannot access the external tab and the create tab, but can access all others.

View 9 Replies View Related

Forms :: Show Tabs And Subforms In Tabs Only If Data Exists

May 6, 2013

I'm trying to clean up a form a bit and have it only show certain subforms/graphs if the data exists. I already have columns in a combobox query to show an "X" for if certain data appears:

Now, I know I could build another query and have some system go through and identify these things, but the easiest thing would be to reference the "X" in the columns of the combobox. Is there an easy way to reference values in the other (non-primary) columns? Or can you think of an easy way to make these subforms only be visible when the data exists? Maybe have an on load event for the subform?

View 2 Replies View Related

Modules & VBA :: Ribbon Won't Hide

Mar 12, 2014

There seems to be some inconsistency in controlling the ribbons in Access 2013.I have managed to use the USysRibbons custom table and XLM to hide the ribbon in one app, but when I set the same config up in another db's the ribbon wont hide.

I've then made an empty db and tried in this and it still wont hide.What are the "current db" setting that must be set to make the ribbon hide?

View 3 Replies View Related

Hide Home Tab On Ribbon Bar

Sep 9, 2011

I'm getting ready to deploy my database and I would like to Hide the "Home" tab and replace it with a custom tab with just the bare minimum of options. I have alreadyused the access options to hide the other tabs that re normally visible, but can't find how to hide the "Home" tab.

View 1 Replies View Related

General :: Hide / Show Field Using Checkbox

Nov 10, 2014

I have a sub form with checkboxes. Each check box represents one of the columns/fields in my query. If one of the boxes is checked, I only want the column that matches with the check box to appear. I have done some research and have came upon the ColumnHidden property.How would one do this in a macro or VBA format.

View 1 Replies View Related

General :: Show / Hide Fields With Answers?

Sep 19, 2012

I have a combo box with the following

YES
NO
EXPIRED
this is named "Permit_Holder"

when you click yes i want two extra fields to appear called

"Permit_Date_Issued"
"Permit_Date_Expired"

but i cannot seem to get them to hide or show?

I have used the below codes but no success

Private Sub Permit_Holder_AfterUpdate()
If Me.Permit_Holder = 1 Then
Me.Permit_Date_Issued.Visible = False
End If
End Sub

Quote:

Private Sub Form_Current()
Me.Permit_Date_Issued.Visible = False
End Sub

View 6 Replies View Related

Open Form Only Hide Ribbon Bar

May 22, 2013

I have a small access project completed for my office, I have almost everything turned off so only the user can see the main form, but I can't figure out how to hide the ribbon bar on the top, can you do this. This is access 2010 by the way.

View 3 Replies View Related

General :: Hide / Show Columns Based On Combobox

Jan 28, 2014

I would like to know if the following is possible: I have a table, I have a form based on that table (datasheet view) and I would like for certain columns to visible or not based on the input on a Combobox (list of countries) that is based on another form.

I have searched on the web and I found that the following:

On a button based on the main menu form:

Code:
Private Sub Go_Click()
Dim stDocName As String
Dim stOpen As String
stOpen = Me!cboDest
stDocName = "Datasheet"
DoCmd.OpenForm stDocName, , , , , , stOpen

and then on the event "on open" of the form Datasheet I have inserted the following:

Code:
Private Sub Form_Open(Cancel As Integer)
Select Case OpenArgs
Case "USA"
Forms![Overflow]![Tasks].Visible = True
Forms![Overflow]![Constant Number (Min)].Visible = True

[Code] ....

I have done it as a test, but it appears that it does not work. It opens the forms, but it does not hide or show the columns based on the option, it brings all the columns.

View 14 Replies View Related

Forms :: Hide Close Buttons On Ribbon?

Mar 28, 2013

I am trying to find a way to hide the close button on the ribbon. My 2007 and 2010 users keep closing the database by the "x" and it's driving me nuts. I have an exit on the switchboard. I tried to disable navigation and ribbons under options and it hides everything except the x. I tried the code:

Code:
Docmd.Showtoolbar "Ribbon", acToolbarNo

In the startup form. Still doesn't give me what I want.

View 1 Replies View Related

General :: Hyperlink Location - Hide Entire Path In Backend And Show Only Name Of File

Sep 26, 2013

I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column.The location filed looks like

M:New1234.pdf
M:New1111.pdf
M:New2222pdf
M:New4444pdf

If the user clicks on this link then the respective file should be open..I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:New1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.

View 3 Replies View Related

General :: Main Form With Two Lists Boxes - Show / Hide Datasheet Columns In A Subform

Aug 24, 2012

I've got a main form with two lists boxes. I want to show the visible columns in my subform (which is a datasheet) in one listbox and show the hidden columns in the other. Also I want to allow the user to hide / show columns using right or left arrow buttons between the list boxes. My subform is bound to a stored procedure using ADO.

View 5 Replies View Related

Modules & VBA :: Hide Navigation Pane And Documents Tabs

May 27, 2014

I'm wondering if it is possible to create a module to hide the navigation pane and document tabs? I know this is possible via the Access Current Database options however I'd prefer this to be done via an Auto Exec that runs the sub. (i already have it for the ribbon)...

View 5 Replies View Related

Hide External Data And Database Tools Tabs From Access

Jan 17, 2015

I want to hide external data and databasetools tabs only from my access program. How i do it ?

View 3 Replies View Related

Modules & VBA :: Access 2007 - Retrieve Current User And Show Ribbon

Oct 7, 2013

I want to show one ribbon for any user level.

Into attach file I use a UserTable to test different user/level.

I retrieve this error: Error 438"Object Doesn't Support This Property or Method" ...

View 2 Replies View Related

Modules & VBA :: Show Hidden Tabs Based On List Box Column Value

Mar 30, 2015

I am designing a contact database for a diocese and the contacts record form is divided into several tabs, some of which are hidden by default. One of the controls on the form is a listbox (lboRoles), where a user can add one or more roles to contacts. The listbox has a hidden column that defines the TabIndex for the assigned role, and my goal is to make the associated tab on the form that was previously hidden, to now be visible.

For example, if a contact is assigned the role "Committee Member" and the tabindex value for that role is 3, the form should make the hidden tab (where the page index is also 3) now visible.

View 13 Replies View Related

Reports :: Show Detail - Using Section Header As Hyperlink To Show / Hide Detail

Aug 13, 2013

I'm trying to create a report where I can use a section header as a hyperlink to show/hide detail, but only for that section. For example, my customer names are:

Code:
ABC Co.
ZYX Co.
123 Co.

If I click on ZYX Co., I want it to show the contracts for ONLY that customer:

Code:
ABC Co.
ZYX Co.
Contract 1
Contract 2
123 Co.

Right now, my code looks like this for On_Click:

Code:
If Me.Detail.Visible = False Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If

But it shows and hides detail for ALL customers when I do this. Is there a way to only show/hide for the customer on which I click?

View 1 Replies View Related

General :: Search Box In Ribbon?

Sep 10, 2013

Any way to move the navigation bar up to the ribbon?

I have been able to add the - First, Last, Next, Previous record buttons but I am stuck at the search box...

View 2 Replies View Related

General :: Print Preview Default Ribbon

Feb 16, 2013

When I have the Home and Create default ribbons showing... then when I choose to Preview a report the Print Preview Ribbon is displayed and the Home and Create Ribbons are hidden or not visible.I have created a CustomRibbon and this CustomRibbon is not hidden when I choose to preview a report. The Print Preview ribbon is shown but the CustomRibbon keeps the focus and is not hidden.I would like for the CustomRibbon to not be visible.

View 2 Replies View Related

General :: Create Addin That Adds A Tab To Ribbon?

Sep 24, 2012

I want to create an addin that adds a tab to the ribbon. I already have an add in installed that works exactly the way I want mine to, but I can't find the .mda file anywhere. I want to stick with the .mda so I have access to my forms. Here are some images of that add in I mention.

View 2 Replies View Related

General :: Access 2007 Ribbon XML Syntax

Mar 25, 2014

I am upgrading an Access 2000 system to 2007 and replacing user toolbars with Ribbons.I have a strange parsing error that I think is not my error.

I have placed the following control into a group:

<control idMso="GroupPrintPreviewClosePreview" label="Close Preview" enabled="true"/> and "the system" rejects it with Error Code 0x80004005 Element <group> is not expected in <group>I

t turns out that it is finding the word Group within the double quotes and interpretting is at part of the XML syntax.

Change to another idMSO and the problem goes away. Same happened with another control that had the word Group in the id.

View 3 Replies View Related

General :: Ribbon Load Custom Image

Oct 21, 2014

I have the following xml script in my table and I want to make the 3rd button be a image that is saved in my c drive.

Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="onRibbonLoad1">
<ribbon startFromScratch="true" >
<tabs>

[code]....

I found the following getimage script but am not sure how to apply it to my button, I have seem various examples on sites but just can't get it to work.
Can I somehow set the icon path like C:Image1.png

Code:
Public Sub getImages(control As IRibbonControl, _
ByRef image)
Set Image = LoadPicture(getAppPath & control.Tag)

' Maybe something like
' Set Image = LoadPicture(c:image1.png)
End Sub

View 3 Replies View Related

General :: Custom Ribbon Always Jumps Back To First Tab

Jul 23, 2012

I've created a custom ribbon for my end users (Access 2010) and everything looks and works great except for one issue that is becoming a deal breaker for me and my end users:

I've got a number of tabs on my custom ribbon and on each tab there are a number of buttons that open various forms and reports. Anytime one of those forms or reports is opened and then closed, the ribbon jumps back to the first tab in my custom ribbon. So if you were on tab 3, opened a form and then closed it, you would be jumped back to tab 1.

Any workaround for what seems to be "by design" behavior for custom ribbons? The built-in ribbon does not do this.....

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved