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 Replies


ADVERTISEMENT

General :: Checkboxes - Create Text Field On A Report That Show All Yes Answers

Apr 8, 2013

I have multiple fields in a table that are set up as Yes/No and display as checkboxes on a form. Now I need to create a text field on a report that showes all the Yes answers. The text field needs to figure out if it's a Yes answer, then display the field name, if there is more than one yes answer in the fields it is looking at, it should separate each with a "," . This is a large text field, that could show as many as 10 Yes answers.

What is the best way to go about doing this? I use Access 2010

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 :: 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

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 11 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

Does MS Access Report Support Hide/Show Fields At The Report View Time?

Aug 19, 2007

Does the MS Access Report support Hide/Show specific fields according to parameters or even by click?

View 3 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

Graphics In A Form (show/hide)

Jul 26, 2007

Hey AP.uk

I've got Form with some drawings on it and I'd like it change depending on what the user has entered in certain fields on the same form.
For Example: when the user selects a certain type of item in the "Item1" field, I'd like the graphic to change (or another one appear) in the form. Basically an "If this is true, show this picture" type thing.
I've been trying a few things to make this happen, but to no avail... :(
Any incite anyone could give would be most appreciated.

Truly,

Dragonchaser

View 10 Replies View Related

Show And Hide Field With Textbox

Feb 6, 2006

Hi

How do I easy create a checkbox that displayes a field when I check it.
For example, if I check a box named I agree, it shows a field with a phonenumber to call

Mike

View 12 Replies View Related

Modules & VBA :: How To Hide / Show Button

Nov 7, 2013

I would like to hide/show button depend on is there anything in a field. My current code is not working at the moment:

Private Sub Form_Load()
If Form![fourniturenErrorsub]![Code Field] <> Null Then
errorbtn.Visible = True
Else
errorbtn.Visible = False
End If

View 13 Replies View Related

Combo Box Value Hide / Show Image

Jul 7, 2011

I'm using access 2007. I'm trying to get a combo box on a form to show or hide an image on a report based on the combo box's value. It seemed simple, but I've tried lots of codes.

View 7 Replies View Related

Auto Rearrange Fields Or Hide Fields In DataSheet Based On Criteria

May 17, 2007

I have main form and that has one sub-form , this Main form governs/determines the data in the sub form.

This Sub form ( DataSheet Mode) has approximately 130 columns and based on the Main form criteria only ~ 20 columns has to be filled.

What I want to do is based on the main forms criteria I want to show only the columns that are applicable to main form criteria.

If I use Columnar or Tabular single form for the Sub Form I am able to hide the fields that are not required BUT IT LEAVES A SPACE/GAP on form ( for the hidden fields that are not required)

Private Sub Form_Load()
If Forms!frmShowPIforActiveAndCanAddNewPI!FrmSubFrmFi lterProductInformationPerFMT!CASETIF = True Then

Me.CASETIF.Visible = True
Else
Me.CASETIF.Visible = False
End If
End Sub


And If I use DataSheet and hide ( visible = no) a particular filed it still shows up in Sub Form

Is there a way to Auto-Re Arrange all the fields in the sub form so that the hidden ( visible = no) fields no not leave gap


Or is there a way by VBA program to select fields ( Columns) from a table to be displayed on a sub form based on a criteria

Thanks
Rahul

View 1 Replies View Related

Modules & VBA :: Show And Hide Command Buttons?

Apr 9, 2014

I'm trying to alter the look of my menu Menu Image.JPG. Depending on the User's Permission setting from the Table PermissionTable.JPG.

If they do not have permission for a company then, i want it to be hidden from the menu?

View 9 Replies View Related

Queries :: Automate Show / Hide Of A Column Not In Use

Dec 18, 2014

I want to automate a query so when the user views it they see only the columns that have data. Columns that do not have data are not there.I am using MS 2007

My Access tool is setup to import data into tables and then the user views the data imported. However, if their's no data (and no column to import) I want the query report to not include the column.

View 8 Replies View Related

Modules & VBA :: Show / Hide Navigation Pane?

Jul 15, 2015

I use DoCmd.ShowToolbar "Ribbon" acToolbarNo (or acToolbarYes) depending on a value in a table which I have shown certain "trusted" users how to change.

But is it possible to do something similar with the Navigation Pane?

View 4 Replies View Related

Reports :: Hide Section On 1st But Show On Rest

Mar 22, 2013

I want to add a section to my report and control the visible value based on page (1st, 2nd, etc...)

So:

1st page show 'Page Header' which has lots of detail, but dont show 'AccNum.Header' section.

2nd, 3rd, etc.. don't how 'Page Header' as I don't need lots of detail, but show the 'AccNum.Header' as this has customer name and Invoice numer, which is enough header information of all the rest of the pages.

Tried using 'On Page' and logoc aroung [Page] but no progress.

View 2 Replies View Related

Criteria To Show / Hide Box On Continuous Form?

Oct 27, 2015

I want to show or hide a box on a continuous form. If there is a date in the ShopOut field i want the label to show up , if not then it will not appear.

I am trying

If IsNull(Me!ShopOut) Then
Me.StillinShop.Visible = True
Else
Me.StillinShop.Visible = False
End If

however, it shows the box whether there is a date in ShopOut on not. Is it possible to do this in a continous form or do i need somekind of me.record#.ShopOut or something.

View 2 Replies View Related

Forms :: How To Hide Database Objects And Show Once Closed

Jan 5, 2014

I have a database with a main menu which opens up on start-up it works fine and all but I want to go the extra step, I wish to disable / hide the ribbons (Top and Bottom) - Or Hide the whole Microsoft Access Window and display my form with the desktop behind it.

The next thing is once I click the X or the button to close the form I want Microsoft Access to appear again as in everything to show itself again.

View 1 Replies View Related

Tables :: Hide Data - Show First Three Letters Of Last Name In Table

Sep 17, 2013

I am creating a database for an ambulance organization to track call history. One of the fields that needs to be populated is patient's last name. I need to show the last name when printing the form for billing purpose. However, I only want to shoe the first three letters of the last name in the table. For example, if the patients last name is Smith. When printing the form I would see the name Smith, but in the table I would only see Smi**.

View 1 Replies View Related

Forms :: Hide And Show Controls Based On Value In Combobox

Apr 22, 2014

I am using Access 2010. I wish to show or hide controls based on the value in the combobox. The combobox is bound with the data type Yes/No. If Yes, controls should be visible and if no, they are to be invisible. The database is a linked one. This selection should update all the users' forms.

View 2 Replies View Related

Queries :: How To Show / Hide Columns In A Query Using A Form Checkbox

Jul 16, 2015

Currently I have a query where the criteria is dependent on the combo boxes on my form. I would like to add checkboxes to my form which determines which fields are shown or hidden. For example if I had a checkbox for address, selecting it on my form will show the address column in my query results.

View 4 Replies View Related

Forms :: Textbox To Momentarily Show Input Character And Then Hide It With A Dot

Nov 26, 2014

Is it possible to have a text box momentarily show the character that is input, and then hide it with a dot (or similar)?

This is for password input so that users can see momentarily, but others won't be able to.

View 4 Replies View Related

Forms :: Hide / Show Text Boxes Based On Search

Aug 2, 2014

I have a form (employee info) that requires the user to do a search to find the employee before then editing anything that needs to be edited.

I have a search box that will find the relevant record without any problem, however what I am looking to do is hide text boxes on the form and have them appear only once the search has found the matching record.

If no matching record is found, I would then like a message box that states 'No matching employee, would you like to add an employee' and when the user clicks OK, it then reveals the same hidden text boxes and sets focus to the first one of the bunch.

Now, I have used the 'me.textboxname.visible = True (or False) elsewhere, however, I am not sure how to trigger that after a search.

I assume I am looking at an If statement, but I am not sure how to construct it, hence turning to the experts.

Code:
Private Sub txtEmployeeSearch_AfterUpdate()
If txtEmployee = DLookup("EmployeeNumber", "tblEmployeeInfo") Then
Me.txtboxname.Visible = True
Me.txtboxname2.Visible = True
DoCmd.GoToControl "txtboxname"
Else
MsgBox "Employee Not Found", vbYesNo
<<<<<<<<<<<<<<<<<<<<<<
End If
End Sub

I know that there is a massive gap where I have put <<<<<<<<<<<<<<<< - but I am stumped as to what to put in there?

View 3 Replies View Related

Forms :: Checkbox To Hide / Show Series In Embedded Chart

Dec 13, 2013

I have chart (grpMaster) that is embedded in a form (frmMain), the chart is a line graph based on a query (qryDataFilter) with 4 data series.

What I want to do is have various checkboxes (chk1 to chk4) that if selected show the series and if no don't - It seems straight forward!

I've tried SeriesCollection() but this comes up with errors. (Object doesn't support this property or Method).

The easiest way i can think of is just to hide / show the series line on the chart, but can't figure this out?

View 4 Replies View Related







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