This article was written by MysticGeek, a tech blogger at the How-To Geek Blogs.
Running into duplicate data in an Access Database can be quite annoying during the hectic workday, so I decided to write up a technique to help identify the duplicate records so you can manually handle them.
There are many causes for duplicate data: for instance if you have multiple users entering data simultaneously via linked tables, or you might inherit a table with duplicate data already entered.
First open the MDB (Microsoft Database) containing the table you want to check for duplicates. Click on the Queries tab and New.
This will open the New Query dialog box. Highlight Find Duplicates Query Wizard then click OK.
Now highlight the table you want to check for duplicate data. You can also choose Queries or both Tables and Queries. I have never seen a use for searching Queries … but perhaps it would come in handy for another’s situation. Once you’ve highlighted the appropriate table click Next.
Here we will choose the field or fields within the table we want to check for duplicate data. Try to avoid generalized fields.
Name the Query and hit Finish. The Query will run right away and pop up the results. Also the Query is saved in the Queries section of Access.
Depending upon the selected tables and fields your results will look something similar to the shots below which show I have nothing duplicated in the first shot and the results of duplicates in the other.
I have decided that J River’s Media Jukebox is now my music player of choice. I did an initial review in a previous post. Now let’s cover the various features included in this application. Today I will cover how to rip you CD’s into your favorite format.
I was browsing our forum earlier today when I noticed a question from a reader asking how to select a date range when searching for files in advanced search. This is something that was extremely easy in XP, but seems to be much less intuitive in Vista.
In the Customize View window click on Fields.
In my IT experience I have noticed that sometimes Remote Desktop can run painfully slow. Here are a couple tricks to speed up the process. We will change the display settings first. Sure it won’t look as fancy, but when working on computers remotely, you just need the functionality.
This article was written by our very own whs, one of the most helpful forum members.
One of our favorite readers wrote in today asking how to tell if his Word 2007 installation was running Service Pack 1, since he couldn’t find the About dialog, which got me thinking… I bet most people don’t know where it is!
If you’ve used Windows Vista for any length of time, you probably already know that using the Win + Space key combination will bring the Sidebar and all the gadgets to the front… but how do you send it back behind your open windows?
I experienced an issue the other day at work in regards to Trend Micro’s PC-Cillin. A colleague brought in their laptop complaining about a slowness issue. While checking out Task Manager I noticed a CPU spike of 50%. Turns out the culprit was a process called PcScnSrv.exe which allows PC-Cillin
I guess I will continue this week’s theme of media players by introducing you to J River Media Jukebox. I have to say I am quite impressed so far with this player.
After installing Windows Live Messenger, I noticed a really annoying addition to My Computer… a new icon called “My Sharing Folders”. So how exactly do I remove this icon I’ll never use?