Topics Search

Multiple fields set to visible or invisible based on field content

Multiple fields set to visible or invisible based on field content
Views: 101
I got lots and lots of fields need to be set to visible or invisible based on field content. Manually coding of this is possible it just takes forever. This is what I am wondering (ifthis is possible or exists or not):

If I had say 10 fields all all those 10 fields were to be set to invisible or visible depending on a single check mark box, could I say 'draw' something maybe a special 'frame' around those10 fields so that I can refer to the 'frame' and everything in that area could be invisible or visible based upon the check mark box versus having to code 10 fields individually?
Sponsored Links:

Similar posts...

 

How to change the height of the 'detail' part of a form?

How to change the height of the 'detail' part of a form? Icon
I know how to set this Property, but what I'm really asking is how I can set it to something smaller than it wants to be.

On a continuous subform, I have a set of fields (all at the bottom of the Detail section) that normally I want to be invisible. On the click of a button, I want to set all their Visible properties to True.

So when the fields are invisible, I'd like to set the height of the Detail section to exclude the "real estate" reserved for the invisible fields, and then, on the click of the button,reset the height at the same time that I set the visibility properties.
 

Invisible LookUp Data List

Invisible LookUp Data List Icon
I have created a simple table, two fields, an Autonumber Primary Key, Field Name - lngBureauID and a Text Field, strBureauName. In a few other tables I have called this table data using the LookUp Data Type. No big deal! However, when I drop down the list of Bureaus the Bureau Name is invisible. If you select something from the list the data is then visible in the table however you don't ever know wht you are selecting because you can't see it. When I make the Primary Key visible, it is visible but the text string field is not. What would cause a fields data to be invisible? I hope you can help me because I can't ask users to select data from a list when they can't see the data. I have looked everywhere for a format or system property that may be causing this issue, I am stumped. I have even created the table again, and ended up with the same problem. I have even created a new database and table and ended up with the same problem
 

Invisible field on a report

Invisible field on a report Icon
In a report on a certain condition I want the field to be invisible
and the code is :
If Me.Field1 = 1 then
Me.Field2.Visible = False
End if
But the problem is that when I type Me.Field2.
the word Visible doesn't appear on the list
 

Invisible field in a report

Invisible field in a report Icon
In a report on a certain condition I want the field to be invisible
and the code is :
If Me.Field1 = 1 then
Me.Field2.Visible = False
End if
But the problem is that when I type Me.Field2.
the word Visible doesn't appear on the list
 

Hide textboxes only on new record.

Hide textboxes only on new record. Icon
I'm trying to hide textboxes but only on the New Record that the form loads up on. i.e. when I go back to a previous record using the navigation buttons on the form footer the boxes should be set to visible. Below is what Ive tried but is not working, it keeps the boxes invisible all the time.

Set boxes invisible on load

Private Sub Form_Load()
'Open the form at a new Record.
DoCmd.GoToRecord , , acNewRec
'Set Later steps to invisible on load
If Me.NewRecord = True Then
Text20.Visible = False
Text67.Visible = False
Text71.Visible = False
Command1.Visible = False
Command105.Visible = False
End If End Sub

Navigate to another set to visible

Private Sub Form_GotFocus()
If Me.NewRecord = False Then
Text20.Visible = True
Text67.Visible = True
Text71.Visible = True
Command1.Visible = True
Command105.Visible = True
End If End Sub

I'm sure this can't be as difficult as Im making
 

Exporting invisible fields on a form to Excel

Exporting invisible fields on a form to Excel Icon
I'm using Access 2010 and I have a form that will be used to select or filter records which will then be exported to Excel. However, I only want to show the critical fields that will be used to make the decision on which records to export on the form but export a far larger set of fields.

The data set of the form is actually a query that contains all the fields required for the export.

If I place all the fields on the (continuous) form but make the ones the user doesn't need to see invisible they are not exported using the standard external data->export/Excel. I can think of a couple of ways round this like making all the fields visible but transparent/white font etc or placing a button on the form and generating the export by dynamically creatinga query based on any filtering the user may have chosen.

However, I was wondering if there is a tidier way to achieve the export of the required fields?
 

Making a Command Buttong Visible/Invisible

Making a Command Buttong Visible/Invisible Icon
I am working on a database in which I am trying to write some code which displays a command button dependant on another action.

In my example, I have two check boxes which I have set up to allow only one choice. So when you check one, the other becomes unchecked!

Behind both these check boxes I have managed to write the code which does make the command button visible/invisible depending on which check box is checked. See bellow

[CODE]

However, the crucial bit I am missing is that it does the same response for ever record. So if I want it invisible in one record that's fine,but then if you go to the next record where you want it to be visible, and have checked the correct box for this to happen, it is still invisible. What I need is some additional coding which ties it to the current record?
 

About records and making field visible

About records and making field visible Icon
I actually have 3 questions that I am hoping someone can help me with.

1. On a form I want fields to be invisible until one field meets its requirements and then the rest become visible. I have the following code in but its not working.

Private Sub Act1Cal_AfterUpdate()
Me.CalisthenicsDone.Visible = False
If Me.Act1Cal = "Calisthenics" Then
Me.CalisthenicsDone.Visible = True

End If
End Sub

2. I want to know if it is possible to have a table to only allow 10 records? If it is possible how to I do that.

3. I have been playing with the database I am creating and as I work with it I am creating records that have an autonumber. Is there away to reset the autonumber back to
 

Hide Part of Report Based on Field Value

Hide Part of Report Based on Field Value Icon
Visible status of an object in a Report based on the value of one of the fields in the record?

I have a report called rptDrillDown which gives the details of a record after being called by an On Click event from the summary report. So far, It's calling up just fine. However, each record has a check box indicating whether the study has to be implemented.

When the box is checked, a whole bunch of fields show up with dates to track the implementation. When the boxis unchecked, the fields are invisible.

This works great on my data entry form, but not so much for my report. not so much.
 

How to set page header to invisible using vba

How to set page header to invisible using vba Icon
What I need is to set invisible the page header in the first page.
I'm using the following code, I succeed what I want in screen but when I print I get the page header in all pages.

If Me.Page > 0 Then Me.PageHeaderSection.Visible = True Else Me.PageHeaderSection.Visible = False End If