can i hide a record when i look it in a form. For example i have a table which has 100 records. Can i make some kind of a check box and if that check box is checked to make the record disappear. I want the record to be in the table but i dont need it in the Form.
I have a form that displays its records in a Contiuous Form. The controls on the form are: txtRecID, txtStudID, cboTrimester, cboType, fld Comment, and blnReqConf.
My issue is that I need the blnReqConf (Request Conference) checkbox and label controls to only show on the reocrds when/if the cboTrimester = "Tri-2" and the cboType = "Parent" or "Teacher" are selected or displayed.
I have written: If cboTrimester = "Tri-2" And (cboType.Column(1) = "Teacher" Or cboType.Column(1) = "Parent") Then blnReqConf.Visible = True lblReqConf.Visible = True Else blnReqConf.Visible = False lblReqConf.Visible = False End If
The problem is that the controls display on all records throughout the form. How do I make it so that the controls are hidden on some records in the continous form and are shown on others based on the criteria? Is it possible?
I have a subform that populates from a query from a table. I also have a checkbox as part of the table. If the checkbox is ticked, I don't want that record to show in the subform
I want to show/hide a button on my form.The button is for entering a new record in the table of the database.Now when i Load the form, i want to check if there are already records in the table for a specific lanID. When there are no records, the butten has to be displayed. When there are already records for that lanID the button has to be hidden.
I have found some code to tackle that, but When i use the rs.MoveLast it hides the button when there are records, but when there are no records it gives an error that there are no records found. I almost forgot to say that i use Access 2010..Here is the code that i use:
Code:
Private Sub Form_Load() Dim SQL As String Dim rs As DAO.Recordset Dim landmeterID As String landmeterID = [Forms]![MainForm]![LanIDTxt] SQL = "select * from dbo_Lan_Opleiding where Id_landmeter ='" & landmeterID & "'" Set rs = CurrentDb.OpenRecordset(SQL)
I have a continuous subform recording the information of various wireless products for an employee embedded in an employee main form. Please see screen shot enclosed.
There is a check box "BYOD/Personal" on the subform. I want to hide a number fields when this check box on independent record is checked. However, if I use the following codes, the changes apply to all records under that employee.
Private Sub BYOD/Personal_AfterUpdate()
If BYOD/Personal.Value = True then Me.Provider.Enabled = False Me.XXX.Enabled = False....etc. Else Me.Provider.Enabled = True Me.XXX.Enabled = True....etc. End If End Sub
How can I just disable those fields on the subform of a specific record when the BYOD/Personal field for that record is checked?
I was wondering if there is a way to hide 1 record from a query
say I have 3 user accounts and on a form I only want to display 2 of them form the query,so the other record is still present but cant be deleted by accident or viewed
Is it possible to just hide a record? My form is based on a query so I know I could remove the record that way but I also have a box that calculates a average time, so the data that is produced by that record still needs to be taken into account. I want to hide some records pureley so the user dosent have to keep scrolling thriugh loads of records. Is it possible to do this?
I have a continuous form "components" where the data is added by a query. There is no need to manually add records to the form, I just want to edit certain fields.
Is it possible to hide/disable the blank "new record" row at the bottom of the form?
I tried setting the form's "Allow Additions" property to no, but the line still appears.
Hi Can anyone confirm (or otherwise) that you can't set the record selector property to 'no' in a datasheet view form? (well, you can set it to 'no' but it seems to have no effect)
I have a question on hiding duplication record using query.
The fields in the query are:
full name(trainee), NRIC(trainee), gender(trainee), preferred language(trainee), company(trainee), course name(course), course date(course), competent(course), class(course), L3 survey(trainee), L4 survey(trainee), num of month(course)
When the query is being run, it will show all the people that have not done the L3 and L4 survey after 3 month. The the query will be convert into a form. However the problem is that the record will show a few same name due to one person can take more than 1 course. therefore, the data in the course table will always be different.
How can i make the record only show 1 name even though they have different course name.
I had tried putting 'yes' for unique record and unique value but it did not change the result.
current SQL query:
SELECT DISTINCT trainee.[Full Name], trainee.NRIC, trainee.Gender, trainee.[Preferred Language], trainee.Company, course.[Course Name], course.[Course Date], course.Competent, course.Class, trainee.[L3 survey], trainee.[L4 survey], DateDiff('m',[Course Date],Date()) AS [Num of Month] FROM trainee INNER JOIN course ON trainee.NRIC = course.NRIC WHERE (((course.Competent)="c") AND ((trainee.[L3 survey])=False) AND ((DateDiff('m',[Course Date],Date()))>=3)) OR (((trainee.[L4 survey])=False) AND ((DateDiff('m',[Course Date],Date()))>=6));
hello, i have a form that shows up when I start my database. It has a combo that users use to select their initials.
This form is run by the autoexec macro.
The forms stores users names that then are propagates to other forms without having users each time selecting their initials.
Is there a way I can hide the first form behind others so that it keeps the data active? I have tried to minimixe it but still can see in the gray toolbar. Thanks.
I was wondering if there was a way to hide certain forms or reports from the view when you open an mdb? I would still like them to view it if the form thats not hidden opens the hidden report or form as well.
I usually use ComboBoxes to show a user-friendly name instead of an ID. For example, I would use a ComboBox of EmployeePK, FirstName + " " + LastName and set the first column as the control source but with 0" width.The issue is these are supposed to be read only. I can prevent the user from changing the field but I don't have a good solution for hiding the ability to select the drop down.
My current method is to create a transparent box over the combobox (so it can't be selected) then hide the dropdown arrow with a background colored rectangle.
Can you have a hidden field in a form? Trying to set up an order process system where I need to take a wholesale price of an item then mark it up (behind the scenes) and display only the customer price. How can I accomplish this.
My tab name is SPA and it is the third tab in my form. I want to hide it if the AddToSPA checkbox is checked. This is what I have but I'm getting error 'Compile error: Method or data member not found"
Code:
Private Sub Form_Load() If Me.AddToSPA = True Then Me.SPA.Pages(2).Visible = True Else Me.SPA.Pages(2).Visible = False End If End Sub
I am trying to make a checkbox with different graphics since the checkbox can not be resized. I thought I could stack images on top of each other and toggle between showing and hiding based on if the checkbox was checked. This actually works, but I wanted to hide my checkbox, so I hid it behind my images. This didn't work. So I brought it to the front and made it invisible. This didn't work either. What can I do? The checkbox is linked to the table, but I want the graphics to show thumbs up or down and not see the checkbox.
I have a form with a checkbox and a combo box. When I click the checkbox, I would like it to only show the specified records that are in the combo box. The current code I have is this:
Code:
Private Sub chkHideComplete_AfterUpdate() On Error Resume Next If Me.chkHideComplete = True Then Me.filter = "[ReservationStatus] = 3" Me.FilterOn = False
[Code] ....
I basically want to hide all records that have "1" in the combo box.
I have written the following code on a command button to set up a basic password for deleting current record. What I really want to do is hide the password being typed into the input box with asterix's. Here is the current code and password:
Private Sub Toggle33_Click() Dim strPasswd strPasswd = InputBox("Enter Password", "Restricted Form") If strPasswd = "" Or strPasswd = Empty Then MsgBox "No Input Provided", vbInformation, "Required Data"
I am trying to hide certain fields on a form based on the value in another field (if yes or no). I used the change event to enable/disable the fields in question. however, this doesn't work. This is the code below...
Private Sub Combo314_Change() If Me.Combo314 = "Yes" Or Me.Combo314 = "No" Then Me.Reason_Label.Visible = False Me.Combo316.Enabled = False Me.Label946.Visible = False Me.Label77.Visible = False Me.care_not_qualified_date.Enabled = False
I have a toggle control on a form which depending on selection uses a loop and instr to make 'not visible' a set of controls on a subform.(forms! Mainform !subform.form)I get error 2165 but if I test immediatley before the make not visible process it returns the toggle frame as being the active control.
I have a split form design. I want to hide a field which I have already set a default value for. But when I make it invisible, the default value is not being recorded.