Topics Search

Hiding fields in a subform

Hiding fields in a subform
Views: 30
I have a form with a category field on it. The value for the category is selected from a list. Depending upon which value is selected for the category I want to hide or make visible various fields on a subform. So for example: only if the category is "Service" do I want the "Qty" field to be visible on the subform. How
Sponsored Links:

More topics

 

Hiding Record in Report based on checkbox value - Access 2003

Preview
I'm new enough at Access 2003 but I have been tasked at work with making a licensing database. I have a main form, and on that form is a subform called "Remarks". I have a report to print off a licence for that particular person. What I want to be able to do is check a checkbox in my "remarks" subform that will hide that record on the report. I've tried hiding the individual fields off the record on the report using the visible tag but it's not ideal as it still leaves an empty white space where everything is hidden
 

Subform not displaying

Preview
I have a form (CourseTaken) that has a subform (UnitTotal). Everything is working except that the subform "detail fields" will not display until three fields have an entry though they do save the information.

The other problem is that the unittotal "footer field" will not display the total until all three fields contain a value.

all three fields are based on different queries (which is why the subform) with the control source as an overriding query UnitTotalAll which contains the three subqueries.

I tried putting the fields on the main form and using DLookup but could never get it to work.

[CODE]

How can I get the subform to display all the time? and the total to display when any one of the three has a value?
 

Subforms 101

Preview
I have just started using my first subform and I cannot seem to apply everything I have learnt up to this time when using the subform and main form

I figure it is the same problem however I am stuck on a number of things such as passing values to other forms, getting combo boxes to work, assigning values and code to the subform, hiding and showing the subform, etc

Previously I have been using code such as

Me.Field1.Visible=True

Forms!frmSubForm1.Field1.Visible=True (to other forms or using value from other forms)

however these don't work when using a subform as it cannot find the form any quick advice as I think this may solve many of my subform problems.

I tried making the code public (removing private) but this didn't work
 

hiding a part of the listbox

Preview
here's what I want to do, I have a list box with data in it, what I want to do is, when I click on new, another set of fields would appear and like hide the other half of the list box till the new data is entered and show the other half again.

I think this is doable through subform but can this be done with grouping too?
 

Subform Issue

Preview
To put it very simply, I have created a form with a subform. The only reason I am using a subform is because I have too many fields and I need a "scroll box" within a set of tabs. I have found no other way to do it.

This method works great except for one scenario: adding records.

I have about 15 fields that I need to display, so the 15 fields are on a subform. The form and subform both reference the same table. The form is linked to the subform on its AutoNumber.

the subform doesn't seem to be linking to the newly created record and I am getting errors when adding values.

The form I am concerned with is called "SAMPLE RECORD." You will see that if you open it, it works like I want it to, but if you click the + to add a newrecord, if you start typing data in the subform I quickly get errors when exiting.
 

Prevent data field movement in subform

Preview
I would like to prevent movement of the category, axis, data and filter fields of a Pivot Chart in a subform. I do not want the user to tinker and begin moving data fields (e.g. SumofTotal).

The idea is for the user to view the displayed bar charts in this subform.

While the subform is based on a query, I do not see any property in design view that would stop a user from manipulating these fields.

What subform properties should I be using?
 

Editing Subform Data

Preview
I am trying to edit the fields in a subform, but it is not working. I checked all the property settings, and found out that the fields I want to edit were locked. I unlocked them, and verified the other properties.

I still can't edit the subform values. I can edit the values in the table, and the query.no problems there. I just can't do it in the subform! If I edit thevalues in the source query, I can view the changes in the subform, but can't actually make the changes from the subform.
 

Many-to-many relationships & webforms

Preview
Two of the tables will need to have a many-to-many relationship, and so will need a junction table that will contain just 3 fields (ID and the Primary key of each of the other tables).

I have no idea how to structure data entry forms for these tables, as I need to have Table 1 as the main table, with the other table included as a subform on which data can be added in many fields.

I've read that a subform within this type of relationship should be based on the junction table, but how do I then include the fields of the table it links with (the 3rd table) within the subform? There's little use for a subform that just contains ID fields.

The subform needs to accommodate a combo box, as well as yes/no & text fields, and the user will also need to be able to edit, add & remove data in the subform over time and it must retain links to the main form.
 

Hide Controls using VBA!

Preview
So I have several main forms which contain the same subform. This one subform contains ~4 Controls / Labels that are only necessary for one of the main forms. I'd like to hide them in all instances except when the main form is named "x".

I think hiding them is most efficient.

I've explored several variations of the below code with no effect what so ever. I've tried calling on the subform more specifically. (I.e. [Forms]![Main Form]![Subform]![Control Name].Visible = False)

Also, Should it work in this general format or do I need to specifically "call" on the Sub? For example, OnOpen, etc.
 

Editing Subform Data

Preview
I am trying to edit the fields in a subform, but it is not working. I checked all the property settings, and found out that the fields I want to edit were locked. I unlocked them, and verified the other properties. I still can't edit the subform values. I can edit the values in the table, and the query.no problems there. I just can't do it in the subform! If I edit the values in the source query, I can view the changes in the subform, but can't actually make the changes from the subform