Hi
I've searched the forum for my problem and the closest i got was this and it doesn't help that much
If this is the code you can put on click for a checkbox to hide a textbox.
If me.YourBoosterCheckBoxName = -1 then 'need the shot so hide the other textboxes
me.TextBox1.visible = false
me.TextBox2.visible = false
'etc....
else
end if
How do you make a code for a checkbox to SHOW a textbox?
I have a text box on a form, currently it performs a dlookup for me. I want to change it so that it only performs the Dlookup if a checkbox is checked, but otherwise will display the text that's in an unbound text box.
Not 100% this is even possible, but hoping so. So far I have in the textbook:
=IIf([CHECKBOX]=0,DLookUp("TABLE","FIELD","ID = " & [Text57] & ""),[TEXTBOX])
The dlookup works fine by itself, it's just making it conditional that's causing me problems. I know it could just be a small problem with the way I've written it, or it could be a bigger thing with me not understanding the way IIF works.
I am having a problem with making a textbox visible on a form if a checkbox is checked on the same form. I have done research on this site and have written the code below, but I am getting a Syntax error, see yellow highlight.
- My checkbox is named: Case is a Readmission from WRCA IP to WRCA IP
- My textbox is named: Date of Current IP Admission (I have defaulted this textbox to not visible).
Here's the code I have written:
Private Sub Case_is_a_Readmission_from_WRCA_IP_to_WRCA_IP_Clic k()
If Case is a Readmission from WRCA IP to WRCA IP =true then
Date of Current IP Admission.visible=true
Else
Date of Current IP Admission.visible=false
[Code] .....
I've been scratching my head all night, can someone tell me why the attached query doesn't work?
Thanks,
Sup
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
is there any way to open a certain website after checkbox is checked?
View 1 Replies View RelatedI am trying to write an IF statement as a macro on the OnClick property of a checkbox and can't get it to work. Basically, if the checkbox is checked (for Yes) I want it to open another form. (The checkbox is a field on a subform on a form).
I haven't even gotten this far yet, but I would also like the IF statement to include an AND somehow....in other words I want the IF statement to basically say if the box is checked for yes AND the offer status field ="Accepted", then open another form. If either is False, then I don't want it to do anything except display a message box saying they can't initiate a contract is both conditions aren't true.
I am trying to create a medical records inventory. We have physical charts which each have a barcode and I have a scanner. The idea is to have employees who want to check the chart out scan their barcode (on their badge), scan the chart's barcode and leave.
I have a table called tblCharts with the fields: ID (primarykey which is also the chart number), a checkbox, Employee ID, Date, and Time checked out.
I have Employee ID linked to my tblEmployees that simply has a listing of the employee ID's and first and last names.
I don't care about keeping a record of who has had the chart in the past.
I just can't figure out how to tell the checkbox to be checked (to indicate the chart is out) when a number is added to the ID field (via scanner).
So here's how it would go:
Scan the chart's barcode which would populate into the ID field. Search to see if the record with the same number is already existing, if not create a record. IF it does exist, check to see if the checkbox is checked. If it is checked then the chart is being checked back in (so uncheck the box). If it is not checked to begin with (still in), then check it out and associate the employee's scanned barcode with it.
Dear All:
I have a form with a checkox. Is there any way to keep a running total on the form to display how many times a checkbox has been checked?
I am clueless on this one, any help is most welcome.
Regards,
Dion
I have a checkbox that when checked returns all of the yes values for the column but I want it so that when it isn't checked, it doesnt search for this criteria at all, is there a way of doing this? I tried option buttons too but I wasn't sure of how to go about it.
View 13 Replies View RelatedI'm guessing that this will take coding and I don't know coding very well. I have 4 categories...I'll call them A B C D.
For each category, there is 3 text boxes, EX: A Cost, A Refund, A Rec Date
I will have a checkbox for when each is rec. but not all accounts will have every category(A, B, C, D). I'm trying to get the checkboxes for each category to be disabled if and only if the Category(A, B, C, D) Cost is NULL or 0.
Thanks in advance for the help.
Dear All:
I have a checkbox called "display_field" and a textbox called "Amount".
Any ideas on how I can make the textbox invisible when I place a check in the checkbox?
thanking in advance,
Dion
I have 44 checkboxes, each has a textbox next to it. What I want is when the user selects a checkbox, the textbox next to it will be enabled. Also, when the user unselect a checkbox, the textbox next to it will be disabled and any value entered is cleared.
Another way is whenever the user enters a value in a textbox, the checkbox associate with it is selected and vice versa.
Dear All:
I have a form with three items:a checkbox called "Check231", a textbox called "text921" and another textbox called "text762".
What I wish to do is: Enter text in textbox921, which stays the same as I scroll through each record. Then If checkbox check231 is checked, it displays text from textbox921 to textbox762. Textbox762 is bounded to the form.
Any ideas on how to get started?
Many thanks,
Dion
I would like to have a checkbox be visible only if a textbox (Text246) has text in it.
Code:
Private Sub Text246_AfterUpdate()
Me.Check275.Visible = Text246
End Sub
My bound master form has bound subform in it and both of them has linked fields. In the master form i've placed a checkbox which if unchacked will lock and disable a textbox in the SUBFORM, and if checked will enable and unlock the textbox and fill it with a calculation result, which will then be passed on to the underlying table.
Now, suppose in the master form (named X), i have A (checkbox) and B (textbox with numeric value) and in the subform (named Y), i have C & D (both textboxes with numeric values). Hence if A is checked, I'd like D to return the result of - "B*C". Or else D will remain locked and disabled.
I have a Mainform [FrmReconcileMain] and it contains a Subform [FrmReconcilesub]
What I'm trying to is, on the Main form type in a statement date in textbox [TxtStatementDate].
I have a checkbox on my subform [ReconciledYN], along with a textbox [TxtReconcileDateSub]. when I click the checkbox, it simply pulls the date from the mainform and populates the date in the subform.
I've even tried experimenting on a simple form (with no subform) to see whats going on, but still I can't get it to work, even on a simple event such as this...
If [yourcheckboxname] = -1 Then [controlnametoupdate] = date() Else [controlnametoupdate] = ""
Hello I'm at a loss on how to get this to work.
I have a check box and I want it to show a picture if it is checked and hide the
picture if it not checked.
I dont know where to put it either, do I put it in the form load procedure or in
the checkbox procedure?
Basically I want the user to check the box if it is needed and when they open
it later they will see the checked box and the picture.
Here is what I am messing with.
If checkBox.?????? = ? Then
imgPicture.visible = True
Else
imgPicture = False
End if
I cant figure out how to do this.
I'm using Access 2002
Thanks for the help.
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 RelatedHi,
I was wondering how to delete records that have been checked (through a checkbox) in a form...
Also, I want to add a record after the record that has been checked. I only want this ability to add records available if only one record is checked. Otherwise, if more than one record is checked, the "Add Record" button would be disabled.
Any help would be much appreciated.
TIA.
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 RelatedI 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?
I have a form that will only show the data of a table.
All the fields are string.
With a combobox I select the record to show.
What I want is that when I select a record, one of the fields, that in fact is a number but storred as string, is shown formatted like 12.123.123,00.
This textbox is not to be edited and is blocked. It will only show the data.
How can I do this?
Thanks.
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
I am looking for a way to display a windows login name when the user double clicks on a text box. This is for a digital signature on a form that I don't want people having access to just type in some elses name.
View 3 Replies View RelatedI'm sure this should be simple but I can't figure it out. What I want is for a text box on a form to display the number of records within a table.
Basically I've got a make table query which creates a table ox X records depending on how many records in the original table match the criteria. So for example:
Table A has 100 records
Query identifies 30 that mee the criteria
Makes a new table called criteria_met with these 30 records
What I want is for a textbox on a form to display "30" and update whenever the make table query runs (probably via a macro??)