473,799 Members | 2,764 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Highlight Identical Fields in Access Table

7 New Member
Hi,

I have an access query that finds the rows that have certain parameters common among them eg : Username
How is it possible to highlight the matches or display only the matches.

TBL:
username age school city
jon 11 a b
jon 12 c d
jane 13 e f

so the output should be the first two rows with jon highlighted.
Jul 26 '07 #1
3 2423
JKing
1,206 Recognized Expert Top Contributor
Do you want the query to show only those rows where the username is seen multiple times? i.e. find any duplicate user names?
Jul 26 '07 #2
ago
7 New Member
Do you want the query to show only those rows where the username is seen multiple times? i.e. find any duplicate user names?
No I have already done that, what i need to do is if there are certain fields that are common in the rows they should be highlighted or maybe change the font to bold.
Eg:

Name school city
Joe ABC XYZ
Joe ABC PQR
Mark MNO CCC

So I am able to get the output :
Name school city
Joe ABC XYZ
Joe ABC PQR

Which selects the rows with the identical name. Now i want to highlight the school ABC as thats the same in both rows. If thats not possible can I change the font to bold. As i was able to do this in excel using code but could not manage to do this in access.
Jul 28 '07 #3
ago
7 New Member
I used a macro like :

Sub test()

If ActiveCell.Valu e = "" Then
With Selection.Entir eRow.Borders(xl EdgeBottom)
.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = xlAutomatic
End With
End If
End Sub

to mark the identical rows in after exporting the table to excel. Can a similar one be used on the access table ?



No I have already done that, what i need to do is if there are certain fields that are common in the rows they should be highlighted or maybe change the font to bold.
Eg:

Name school city
Joe ABC XYZ
Joe ABC PQR
Mark MNO CCC

So I am able to get the output :
Name school city
Joe ABC XYZ
Joe ABC PQR

Which selects the rows with the identical name. Now i want to highlight the school ABC as thats the same in both rows. If thats not possible can I change the font to bold. As i was able to do this in excel using code but could not manage to do this in access.
Jul 30 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

13
4538
by: David Morgan | last post by:
Hello I have a little function to highlight text if it exists. Function Highlight(vFind, vSearch) Dim RegEx Set RegEx = New RegExp RegEx.Pattern = vFind RegEx.IgnoreCase = True Highlight = RegEx.Replace(vSearch, "<span class=""Highlight"">" & vFind &
3
2637
by: Andre Doreid Berro | last post by:
Greetings All I have requested help before and I really need your help in this. I am working on an Access database of contacts. I have plenty of records but plenty of them are almost duplicates. Data in some fields are misspelled and entered as completly different records. I wonder how could I clean the database in a way I have single record of contact information for each contact. Example:
3
15854
by: Prakash Wadhwani | last post by:
Is there any EASY way to highlight a full row in a continuous form so that as i navigate up & down the table/continuous form using the arrow keys, the entire line (all fields) get highlighted ? This will give the effect of a bar moving up & down. BTW, all fields are locked so this form is View-Only & not editable. Thx & Best Rgds, Prakash.
4
2148
by: Terry | last post by:
I need some help refining an MS 2000 relational databse. I have created a simple relational database using two tables, 'Student Details', 'Exam Details' and two forms, 'Input/Edit Exam Details', 'Input/Edit Student Details'. 'Student Details' has a field called 'Log Book No' (no duplicates allowed) and this is the Primary Key. 'Exam Details' also has a field called 'Log Book No' (duplicates allowed) and has no Primary Key, (as each...
1
1990
by: Not Me | last post by:
Hey, In our database, we have implemented auditing simply by holding a copy of each row of the specific table at any time that data is updated. This gives us a long list of full records, often with only one change between them. Not sure if there's a better way to do this, but we'd like to somehow highlight whichever record was changed by comparing each row with the next (in date order).
3
3016
by: almurph | last post by:
Hi, I'm a newbie to Javascript. I can;t even finf a full API for it! Anyway I have a table structure and when a user presses the down-arrow button the item in said table is meant to be highlighted. Here is the code that I have so far: document.getElementById('tableID').style.backgroundColor ="#000000"; document.getElementById('tableID').setAttribute ("border", 2);
0
6856
Merlin1857
by: Merlin1857 | last post by:
A thing I have been asked for on a number of occasions is the ability to highlight text after its been searched for in a record return page. The following does this perfectly. Use this function within your record return page : 'Highlight searched for text function Function Highlight(strText, strFind, strBefore, strAfter) Dim nPos Dim nLen
2
4772
by: steph | last post by:
I have a table with 250 fields. Of course you are wondering why 250 fields... what could I possibly be storing in so many fields? I am using this table as a general import table for files that vary based on user selections. The input files are CSVs and can number from 2 to 175 columns. Each field is usually able to fit into a Text field (< 255 characters) but every now and then a longer field creeps in. since I don't know in which column...
4
6410
by: gillianbrooks91 | last post by:
Forgive me for asking this question, I've trawled through nearly every available post on this subject that I can find for a few weeks now but nothing quite points me in the right direction. I'm quite new to trying to mess around with VB and ADO within MS Access and have realised the steep learning curve I have, but, I want to try and solve this problem quickly and was wondering if anyone would help me out?? I want to be able to...
0
9541
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10482
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10225
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10027
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9072
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7564
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5463
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5585
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3759
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.