Code:
Private Sub Combo1309_AfterUpdate()
If Me.Combo1309.Value = "Yes" Then
Me.Text1307 = Environ("UserName")
ElseIf Me.Combo1309.Value = "No" Then
Me.Text1307 = Environ("UserName")
End If
End Sub
I am using the above code to capture the login information. Is it possible to add a second criteria to the Me.Combo1309.Value = "No" that also highlights the Textbox (Gender) Red? Ideally, the value in this textbox would be switched to the opposite, but this option might be more trouble then its worth.
How would I go about writing some code to highlight the current day if a day field in a form matches.
i.e. I have a schedule form that has a field that has the day manually entered, so Monday, Tuesday etc. And on the top of the form I have a text box set to =Now() and the date format set to dd mmmm - dddd
And what I want to do is make it so what ever the current day is, any records in the form that match the current day will be highlighted.
I have a form that I need to update whenever a chosen business name changes. This is tied to a search function that updates/changes the business name, and this works fine. What I now need it to do is when the name is clicked on the table (which updates the respective business name) I need everything else to update with it.
I have tried refreshing the business name, the form, even the records themselves with onClick and onChange functions, but it still doesn't work.
Re-reading this I realize it doesn't make much sense, but hopefully the attached database will clear things up. When you type in the info in the search box, all the stuff in the right corner changes accordingly. If you click and highlight anything in the box in the center instead of using the search function, the business name at the bottom changes but everything in the right corner remains unchanged.
I have a form that acts as a search form where the user inputs a string of text which then updates and filters a list box. For some reason when it does this it highlights the 2nd row on that list, even if there is no data there. How can I get it to automatically highlight the first row? The database is attached and the form in question is FRM_SearchMulti.
I am trying to provide a visual highlight for users of a multi tabbed form. I do a check as users go from tab and tab and i.e. on exit event and I would like to highlight all mandatory fields that have been left incomplete.
I did a test with one control and it worked as expected with the after update event of the specific control.
I then altered the code to add another control, but it does not work as expected. It only highlights one control and not the other. I just recently started using vba, I adapt the code to fit multiple controls and make it work as expected.
Private Sub Ctl2_frm_tab1_Exit(Cancel As Integer) If (Len(Form_2.cmb_arName& "") = 0 Or IsNull(Form_2.cmb_arName)) Or _ (Len(Form_2.cmb_val & "") = 0 Or IsNull(Form_2.cmb_val)) Then Cancel = True MsgBox "Please complete the highlighted control", vbCritical + vbOKOnly
I have a form which has a subdatasheet attached to it. there could be 1000 records in the main form but only 10O records in the Subdatasheet that match the records in the main form , these are linked by a "product number" .
Is it possible for the row in the main form to be "red" where there is data in the Subdatasheet that is matched by the "product number".
I have a continuous form that shows the results from a query like:
Red Red Red Green Green Green Yellow Yellow
And I wanted to know if I can some how highlight in a white/yellow alternating color like for instance starting with the three reds being white then the three greens being yellow then the two yellows being white and so on. Maybe through conditional format?
I want to add a conditional formatting to a combo box to highlight if the value is not on the list.There is a process to read in data from a 3rd party excel sheet that has truck arrival dates and times. My form displays this data and allows the internal users to change it. My form has the "Trucks" field as a limit to list combo box - so basically any data can be read into this field but internal we can only change it to trucks on the list (from the trucks table). I want to highlight where the trucks value is not in our trucks list.
Is there any way to highlight duplicates across a number of records on a continuous form (conditional formatting I presume)? My continuous form is filtered on load to show only the records relating to the specified date (specified before opening the form), and there is one field that I would like to highlight if there is a duplicate value in the same field on another record on the form. Is this possible?
I wish to highlight some fields on a form if their value differs from the previous record.
I'm OK with the code to determine this, but unsure as to where to put the code to set the fields initially?
I have two strings txtPrevPayment_Method and txtPrevProduct.
Where can I set them 'once' to be the same as the first record loaded in the form. Then in the Current event I check if they have changed and set font colour accordingly.
I have two unbound unlinked subforms residing on a 3rd unbound main form. When I enter the current record on Subform1 I would like the matching record(s) on Subform2 to be highlighted or otherwise formatted. I can get this to work for only the first record on subform2 due to the way I have my code setup on Subform1:
Code: Private Sub Accounting_Unit_Enter() 'find where AUs match. only works for first Subform2 record If Me.[Accounting Unit] = Forms!MainForm.[Subform2]!AccountingUnit Then msgbox "Match" End If End Sub
My thought was that I needed to reference the Recordset of Subform2 and search for all AccountingUnits that match the current AccountingUnit of Subform1,
Is their a way to highlight a feild. I am using the duplicate function but after the record is duplicated their are certain feilds that have to be changed, how can i highlight them somehow. ANy ideas??? The feild is Price???
I have a wild card search query (Like "*" & [Forms]![search]![Text0] & "*") that works very well. I want to be able to have the phrase that user types in highlighted when it returns the search results on a form. I found the following thread that asks the same question using Conditional formating, but the suggested answer doesn't work. Any ideas?
Ok, there is one main form and a subform which is linked directly to a table. A VBA routine checks entries and flags certain rows for errors. We want to highlight specific cells that are out of tolerance.
Been playing around with the Me.ActiveControl.BackColor = vbYellow
But if this can be done to a particular cell on a table, and if this can be done using VBA.
This is my first post. I have been trying to find a solution for the following issue. I have a Continuous form and I would like to highlight the record by clicking on any of the fields in that record, tried everything with no luck, any ideas?
I just built a tracking database (I can't post it because it contains PHI, and I do hope I don't have to) and it's been giving this issue starting today.
When I am in a field the cursor automatically goes to the end and highlights everything between the end and where I click. So if I mistype the third character I need to delete everything from the end to the third character to edit it.
It just started doing this when I loaded it up. Does anyone have any idea?
My vision-impaired staff are having trouble seeing the blinking caret when they tab over to the next field in a form. Is there a way to highlight the newly-selected field instead of just having a thin blinking caret to guide the way?
Hey guys it's been a long time since i've been here but i again need your help
my job asked me if it's possible to have keywords highlighted in search results in report am i clear? meaning, when you search for keywords in one of the fields, and then your results come out in the report, can they be selected, like in Word, or in searches on the Internet, like when doing a search on Monster, all your keywords will come out in red, that way you can easily read the results
I have synchronized a form with a subform with the following code:
Private Sub YourField_DoubleClick() 'this code is behind the subform Dim rs As Object Dim strLinkValue As String 'value in link field of the subform strLinkValue = Me![NameOfLinkFieldOnSubform].Value Set rs = Forms!YourMainForm.Recordset.Clone rs.FindFirst "[NameOfLinkFieldOnMainForm] = '" & strLinkValue & "'" Forms!YourMainForm.Bookmark = rs.Bookmark End Sub
Every thing works fine but now I would like that the row in subform remains selected in the subform when the user doubkeclicks the record in the subform.Now after doublecliking the subform highlight the first row.
