I am new to Access so I love your way of teaching and this helped me out... Is there a way to add multi-select rows with the highlight besides the current row.If the customer shift and click on certain rows on the continuous form.
Is that ok if you could show us how to highlight the entire row that has duplicates. If there there are 2, 3 or more duplicates, then highlight. I know how to do just highlight partial. I want the whole row to make easier to view to troubleshoot the duplicates. I don't remove duplicates right way. I have to seem them first, review, then I delete them. I have patient name, MRN #, and many other columns related to the patient. MRN cannot repeat has to be unique, however, sometimes we want to keep the duplicate happens to see if patient is an old client, had already treatment before in the clinic. It's a database that I did not create, it should be created in a more efficient way. It should have a field where shows the old history of the patient, instead of repeating the client's MRN record.
you could add aa expression something like DCount("fieldname","Tablename","fieldname=" & [fieldname]) to the RecordSource and use it for Conditional Formatting
Your code and explanation is great! I have one small problem though. When in Form view, the texthighlight box is visible on every record., not just the selected record. The textbox is only highlighted on the selected record, but is also visible with its default color on the other records, which conceals my background color and alternate color. What can I do?
great! i'm workin' on access for many years - never needed that highlight, and couldn't think of such elegant and simple solution!
You're very welcome! Happy to help ~
Always challenging me to become better! Love your videos..... Wish there was more frequent posting! Thanks for what you do DO!!
thank you, Scott, and you're welcome. Happy you are getting better with Access ~
Awesome as always. Crystal Clear : )
thank you, Michael!
New subber 🚨 thanks to your contenta
you're welcome and thank you!
I am new to Access so I love your way of teaching and this helped me out... Is there a way to add multi-select rows with the highlight besides the current row.If the customer shift and click on certain rows on the continuous form.
thanks, Shawna. I don't know of any easy way to do that
Very Clever!
you're welcome and thank you, Vae
Is that ok if you could show us how to highlight the entire row that has duplicates. If there there are 2, 3 or more duplicates, then highlight. I know how to do just highlight partial. I want the whole row to make easier to view to troubleshoot the duplicates. I don't remove duplicates right way. I have to seem them first, review, then I delete them. I have patient name, MRN #, and many other columns related to the patient. MRN cannot repeat has to be unique, however, sometimes we want to keep the duplicate happens to see if patient is an old client, had already treatment before in the clinic. It's a database that I did not create, it should be created in a more efficient way. It should have a field where shows the old history of the patient, instead of repeating the client's MRN record.
you could add aa expression something like DCount("fieldname","Tablename","fieldname=" & [fieldname]) to the RecordSource and use it for Conditional Formatting
great job
thank you, Lê Văn Bùi Phước!
Your code and explanation is great! I have one small problem though.
When in Form view, the texthighlight box is visible on every record., not just the selected record. The textbox is only highlighted on the selected record, but is also visible with its default color on the other records, which conceals my background color and alternate color.
What can I do?
thanks, Richard. It sounds like you didn't set up the Current event code -- or maybe it doesn't compile.
thanks
You're welcome! thanks for commenting ~
great video
Thank
you're welcome and thank you