 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2005Cond Formatting Duplicates
Hi, I have a sub-form (continuous forms) which displays data from an archive table. I want to be able to highlight the duplicate entries in a different colour. Ive tried the duplicate query wizard and conditional formatting. Im guessing some kind of syntax needs to be entered in the conditional formatting box but im not sure what I need. Any help greatly appreciated. Thanks, Ash. The duplicate query will display all the records that have duplicates, enter that query and remove the criteria >1. Now you'll have a list of the fields with the CountField (1 or 2 or 3 ..) In the record source of the form, join the above query with the table, so you have a select statement Select QueryName.CountField, TableName.* From QueryName Inner join TableName On QueryName.FieldName = TableName.FieldName In the conditional formating, define a format for the count field, >1, and color. You can color only one field and not the entire record  SignatureI hope that helped Good luck > Hi, > [quoted text clipped - 7 lines] > Any help greatly appreciated. > Thanks, Ash. Thanks. One question, you mention the "CountField" are you assuming this would be an AutoNumber/Unique identifier field? > The duplicate query will display all the records that have duplicates, enter > that query and remove the criteria >1. [quoted text clipped - 21 lines] > > Any help greatly appreciated. > > Thanks, Ash. If you created a duplicate query using the wizard, when you open the query in design view youll see that you have a criteria >1 on the cont field, this field is the count field. Remove the criteria, then all the records will be displayed, so you can join it to the table, and that answer the second question. SignatureI hope that helped Good luck > Thanks. > One question, you mention the "CountField" are you assuming this would be an [quoted text clipped - 25 lines] > > > Any help greatly appreciated. > > > Thanks, Ash. Also, The record source only displays the duplicates, Is it possible to show both the duplicates AND the records which do not duplicate? Then only colour the duplicate ones? Thanks again. > Hi, > [quoted text clipped - 7 lines] > Any help greatly appreciated. > Thanks, Ash. Magic........thanks very much :-) > Also, The record source only displays the duplicates, Is it possible to show > both the duplicates AND the records which do not duplicate? Then only colour [quoted text clipped - 11 lines] > > Any help greatly appreciated. > > Thanks, Ash. Sorry to be a pain.......(again) In the conditional formatting. Should I be using "Expression Is" or "Field Value Is" and whats the syntax I should be using to highlight those duplicating? Thanks again :-) > Also, The record source only displays the duplicates, Is it possible to show > both the duplicates AND the records which do not duplicate? Then only colour [quoted text clipped - 11 lines] > > Any help greatly appreciated. > > Thanks, Ash. In the formatting First text box you should use "Field Value Is" Second text box choose "grater then" Third rext box write 1 On the buttom select the color SignatureI hope that helped Good luck If I helped you, please mark this post as an answer in the buttom of the screen > Sorry to be a pain.......(again) > In the conditional formatting. Should I be using "Expression Is" or "Field [quoted text clipped - 17 lines] > > > Any help greatly appreciated. > > > Thanks, Ash. This simply isn't working because the field value is always greater than 1 (so it is colouring ALL records). The field I am formatting is a "Account Number" field, hence checking for more than one of the same account number. I was assuming this would be my "Count Field", correct me if I am wrong... Thanks in advance. > In the formatting > First text box you should use "Field Value Is" [quoted text clipped - 24 lines] > > > > Any help greatly appreciated. > > > > Thanks, Ash. Can you post the SQL of the duplicate query, and the SQL of the form, so I can have a look SignatureI hope that helped Good luck > This simply isn't working because the field value is always greater than 1 > (so it is colouring ALL records). The field I am formatting is a "Account [quoted text clipped - 31 lines] > > > > > Any help greatly appreciated. > > > > > Thanks, Ash. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.