tag:blogger.com,1999:blog-28816274733202315432024-03-05T03:39:19.463-08:00Blue Screen SolutionsKSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.comBlogger40125tag:blogger.com,1999:blog-2881627473320231543.post-30139072723627711982012-06-08T04:35:00.002-07:002012-06-08T04:35:34.108-07:00Copy Music From Your iPhone/iPod/iPad to Your Computer<div dir="ltr" style="text-align: left;" trbidi="on">
For various reasons you may find that a song on your iPhone, iPod, or iPad does not exist on the computer you are using (at work? Bad music transfer?). It used to be quite a process to get files transfered, but now there's an easy piece of software for Windows that does everything for you: Sharepod.<br />
<br />
1. Download <a href="http://www.getsharepod.com/" target="_blank">Sharepod</a>.<br />
<br />
2. Connect your iDevice.<br />
<br />
3. Open Sharepod. (You will be asked to close iTunes if it is open).<br />
<br />
4. Select the music you want to save to your computer.<br />
<br />
5. Click "Copy to Computer" and select the folder you want to save the songs to.<br />
<br />
There you go!<br />
</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-76633090806366784292012-05-30T05:40:00.001-07:002012-05-30T05:40:30.212-07:00Access 2007: File Size Stays The Same After Deleting Records<div dir="ltr" style="text-align: left;" trbidi="on">
Problem: An Access database file has gotten large, so you decide to delete many records to reduce the file size. After doing so, however, the file size stays the same.<br />
<br />
Solution: Compact and repair the database.<br />
<br />
1) Go to the Office button in the upper-left.<br />
2) Go to Manage and select "Compact and Repair Database".<br />
<br />
Your database will now be a smaller size, sometimes even if you didn't delete any records. <br />
<br />
To make this automatic:<br />
<br />
1) Go to the Office button in the upper-left and click the "Access Options" button.<br />
2) Select "Current Database" from the left-hand menu.<br />
3) Check the box "Compact On Close" and click OK.<br />
<br />
</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com0tag:blogger.com,1999:blog-2881627473320231543.post-79661050695546875102012-05-16T04:48:00.000-07:002012-05-16T04:48:10.919-07:00Access: Auto-Populate Fields in a Form Based on ComboBox Selection<div dir="ltr" style="text-align: left;" trbidi="on">
This post outlines how to automatically fill other fields in a form based on a selection made from a ComboBox.<br />
<br />
1) While in Design View, select the ComboBox from which you will use to fill in the rest of the fields. All this data must exist in the same table for this method to work.<br />
<br />
2) On the Property Sheet, select the Data tab and click the "..." button next to Row Source. The "Show Table" dialog should appear asking you which table to select from. Choose the apporiate table.<br />
<br />
3) Drag and drop the column headers that will be used for filling in the data and save the query.<br />
<br />
4) Go to the Format tab in the Property Sheet. Change the Column Count to the number of columns you selected in step 3. Change the Column Widths to be 1 for the column you want to be selectable from the drop down and 0 for each column you want hidden. For example, I want my first row to be the list used in the Combobox, but I listed two additional columns, so my Column Widths will look like this: 1";0";0".<br />
<br />
The 0 values are just making the data available to use when we auto-fill later on.<br />
<br />
5) Go to the Event tab and click on the "..." button for "After Update" and select Code Builder. This will bring up the Microsoft Visual Basic interface.<br />
<br />
6) You shold see a section beginning with "Private Sub COMBOBOX1_AfterUpdate()". Below that and before "End Sub", type the following:<br />
<br />
<br />
Me.[TEXT BOX] = Me.[COMBOBOX1].Column(1) <br />
<br />
"TEXT BOX" is the label for the box you wish to fill automatically fill. <br />
"COMBOX1" is the name of the combobox where the selection was made to fill the rest of the boxes. <br />
"Column(1)" indicates which column from the hidden areas of COMBOBOX to fill this box with. Note that the column counts begins at 0, so above the 1 indicates the second column. <br />
<br />
To continue, you could add another text box that automatically gets filled by typing the following: <br />
<br />
Me.[TEXT BOX2] = Me.[COMBOBOX1].Column(2) <br />
<br />
7) Go back to Form View and try it out. I may add some screen shots at a later time, but in the meantime, please post comment with questions for clarity. <br />
<br />
An advantage of using this method is that it frees up the Control Source field in the Property Sheet so that any data entered and automatically filled can still be stored to a table for other reports. <br />
<br />
</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com5tag:blogger.com,1999:blog-2881627473320231543.post-62346023404584595942012-05-15T09:16:00.000-07:002012-05-15T09:45:31.814-07:00Windows XP/7: How to Prevent Flash Drive Viruses Forever!<div dir="ltr" style="text-align: left;" trbidi="on">
One of the most common ways for offices to get a virus outbreak is through flash drives. For some reason many of the big anti-virus companies haven't tarket flash drive viruses and instead focus on web browsing and emails. Fair enough, but the flash drive solution is rather simple:<br />
<br />
How do viruses spread through flash drives? Through a "feature" in Windows that allows software to automatically and easily run from a flash drive, CD or DVD simply by inserting it in the computer. On a more technical note, Windows looks for a file called <em>autorun.inf</em> that maps the execution out for the user.<br />
<br />
The problem is that viruses can replace or create <em>autorun.inf</em> to run malicious programs from the flash drive. I say the tradeoff of convenience over security is not worth it, so let's disable Window's use of <em>autorun.inf</em> and forever be rid of the problem with flash drive viruses!<br />
<br />
There used to be a registry script that would make this possible, but it seems the Microsoft has embraced the move to disable <em>autorun.inf</em>, so the solution is rather straight forward.<br />
<br />
For very technical background info, <a href="http://support.microsoft.com/kb/967715" target="_blank">read this page from Microsoft.</a><br />
<br />
Down the middle of the page you'll see a button saying "Fix It" under the heading "Disable Autoplay". This is the one you want. Or simply <a href="http://go.microsoft.com/?linkid=9741395" target="_blank">click here</a> to directly install it.<br />
<br />
That's it! No more viruses!<br />
<br />
To clean existing flash drives, I have found Microsoft Security Essentials to do the best job. I don't know why, but McAfee and other big anti-virus brands just don't seem to care what's on your flash drive.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com0tag:blogger.com,1999:blog-2881627473320231543.post-83523328967634899832012-05-15T05:59:00.001-07:002012-05-15T05:59:07.219-07:00iPhone: Broken Mute Switch / Bypass Silent Toggle<div dir="ltr" style="text-align: left;" trbidi="on">
I inherited a much-appreciated iPhone 3GS recently with the warning that it came with some minor problems, including a silent switch that didn't work. <br />
<br />
The symptom: while it works in the "on" position, the "off" position was unreliable or irritating as it would go crazy vibrating as it contanstly switched on and off from silent.<br />
<br />
The solution:<br />
<br />
1) Download and install "SBSettings" from Cydia. (Oh yeah, <a href="http://bluescreensolutions.blogspot.com/2012/05/unlock-iphone-3g-ios-421-baseband.html" target="_blank">jailbreak your iPhone</a> first).<br />
<br />
2) Download and install "Ringer/Silent SBSettings" from Cydia.<br />
<br />
Now when you swipe the top of your iPhone screen, you will see a picture of a bell. This will toggle between muting and ringing.<br />
<br />
Since the switch always worked in the "on" state, I just always leave the switch on and use the toggle to make it turn on or off. How you use this software will depend on what exactly is happening with your switch, but you'll figure out what's best for you.<br />
<br />
The good thing about this fix is that it works for all versions of iPhones. There's rumor of an "AutoSilent" app that does wonders, but it wouldn't work on my iPhone.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com5tag:blogger.com,1999:blog-2881627473320231543.post-19715260443484687042012-05-14T14:42:00.002-07:002012-05-14T14:42:52.387-07:00Unlock iPhone 3G iOS 4.2.1 Baseband 05.15.04<div dir="ltr" style="text-align: left;" trbidi="on">
I went to unlock an iPhone 3G I found on a volcano (true story) and it seemed to go without a hitch...except when I tried to actually use the phone on a network. Even though it acted like it was jailbroken and ultrasn0w unlocked it, the phone never would actually work on the network. After some research, I discovered there's a bug with baseband 05.15.04. <br />
<br />
The fix seemed simple: while jailbreaking with Redsn0w, install the iPad baseband. The problem with this fix? The latest version of Resn0w kept crashing when trying to jailbreak with the iPad baseband. I also saw a fair share of running pineapples that didn't seem to be running anywhere and continuously rebooting Apple logos.<br />
<br />
So after a lot of research and trial and error, it took the right combination of iOS and version of Redsn0w to work. I give you my solution:<br />
<br />
1) Download iOS 4.2.1 IPSW <a href="http://appldnld.apple.com/iPhone4/061-9853.20101122.Vfgt5/iPhone1,2_4.2.1_8C148_Restore.ipsw" target="_blank">here</a>.<br />
<br />
2) Download Redsn0w 9.6b5 <a href="http://iphone.dashhacks.com/system/files/redsn0w_win_0.9.6b5.zip" target="_blank">here</a>.<br />
<br />
3) Run Resn0w 9.6b5 and select the IPSW downloaded in Step 1.<br />
<br />
4) When asked to select your options, check "Install Cydia" and "Install iPad Baseband".<br />
<br />
5) Continue to follow the rest of the instructions to jailbreak your iPhone.<br />
<br />
6) Open Cydia and install ultrasn0w.<br />
<br />
You'll be unlocked!</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com19tag:blogger.com,1999:blog-2881627473320231543.post-13765923499996836702012-05-06T03:02:00.000-07:002012-05-10T03:21:25.653-07:00Download Anki Decks from Web/Browser<div dir="ltr" style="text-align: left;" trbidi="on">
If you have ever encountered a annoying and nondescript message from Anki when trying to download a deck, give this a try. I came about it when I realized one of the offices I work in had blocked access to Anki's download repository. There are other solutions involving firewalls and anti-virus blocks, but this just gets straight to the point:<br />
<br />
1) In your browser, go to <a href="http://anki.ichi2.net/file/search" target="_blank">http://anki.ichi2.net/file/search</a> .<br />
<br />
2) It's all a big running text file, but you can search for certain phrases. For example, I searched for "French" and scanned through the matches until I found a couple decks I wanted to try out. Here is my example:<br />
<br />
<blockquote class="tr_bq">
[579, null, "HTAL French ", "A compilation of other decks as well as a few facts I've added myself. Deck is incomplete as of October 2009.", "French", 0, 3834, 475343, 976, 1256700637.820281, "6f3d2421c99cf1c28f7ea48685e92bcd.zip"]</blockquote>
<br />
See that "579" at the beginning? That's the important number you want to keep track of -- just use the number associated with the deck that you found.<br />
<br />
3) Open up the web page <a href="http://anki.ichi2.net/file/get?id=579">http://anki.ichi2.net/file/get?id=579</a> but replace "579" in the address with the number associated with the deck you want to download. You should be prompted to download a "Get.zip" file. (NOTE: This doesn't work very well in Google Chrome, but Internet Explorer won't give you any trouble.)<br />
<br />
4) Open the zip file. "Shared.anki" is the only file you need to concern yourself with, so download it somewhere on your computer.<br />
<br />
5) Open Anki and click the "Import" button to select the "Shared.anki" file we just downloaded. You're set!<br />
<br />
<br />
NOTE: Here is the error message I was receiving. It's very likely that something is just blocking the access or DNS settings need to be tweaked. I'm positive that my office has security settings in place that make it unreliable.<br />
<br />
<br />
<blockquote class="tr_bq">
File "ankiqt\ui\getshared.pyc", line 64, in fetchData<br />
<br />
File "urllib2.pyc", line 124, in urlopen<br />
File "urllib2.pyc", line 383, in open<br />
File "urllib2.pyc", line 401, in _open<br />
File "urllib2.pyc", line 361, in _call_chain<br />
File "urllib2.pyc", line 1130, in http_open<br />
File "urllib2.pyc", line 1105, in do_open<br />
URLError: <urlopen error [Errno 10061] No connection could be made because the target machine actively refused it><br />
<br />
<br />
<br />
<br /></blockquote>
<br />
<br /></div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-37536343148367583792012-04-27T05:25:00.002-07:002012-04-27T05:31:14.544-07:00Access 2007: The Database Has Been Placed in a State by User on Machine That Prevents It From Being Opened or Locked<div dir="ltr" style="text-align: left;" trbidi="on">
Problem: You get the message "The database has been placed in a state by user <name>on machine <name>that prevents it from being opened or locked" when you try to open a shared database over a network. The database can only be opened by one person while the others receive the above message.<br />
<br />
Solution: The database should automatically open in shared mode, but network security settings may interfere with this. Try one the following:<br />
<br />
1) Does the first person opening the database see a notification at the top that warns "Security Warning: Certain content in the database has been disabled". If so, then click on the "Options..." button, select "Enable this content" and click OK. The notifications should disappear and others should now be able to open the database, but should also Enable the content in the same manner.<br />
<br />
To fix this in a more-permanent manner, from the "Options..." button given in the warning, click on the "Open the Trust Center" link at the bottom of the window the appears. From within the Trust Center window, go to Macro Settings (on the left) and select "Enable all macros". From now on the security warning should not appear.<br />
<br />
2) If you do not see a security warning as describe above, the security settings could still be a problem and Access just isn't notifying you. In Access, click the Office button in the upper-left corner, select "Access Options", select "Trust Center" from the left menu, and then click the "Trust Center Settings..." button. From the Trust Center, select "Macro Settings" from the left menu and choose "Enable all macros" from the options.<br />
3) Create a shortcut to the database by right-clicking the Access file, selecting "Send to >" and choose your Desktop. From now on, open the database from the shortcut on your desktop. Solutions #1 and #2 may still apply to this setup.<br />
<br /></div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com14tag:blogger.com,1999:blog-2881627473320231543.post-5121617573755622492012-04-18T04:27:00.000-07:002012-04-18T04:27:49.009-07:00Excel 2007: How To Remove Extra Spaces from Text in a Cell<div dir="ltr" style="text-align: left;" trbidi="on">
Some data imports in a spreadsheet can cause some extra spaces to appear before or after text in a cell. To clean it up, check out the Trim function built in to Excel. Trim removes any extra spaces besides the spaces between each word.<br />
<br />
1) Create a new column next to the data you wish to trim. (Unfortunately you can't apply to Trim directly over the top of the current text).<br />
<br />
2) Click the Function (Fx) button next the text box where you input data.<br />
<br />
3) In the "Or select a category:" drop-down, select "Text".<br />
<br />
4) Find Trim from the bottom list and click OK.<br />
<br />
5) Click on the cell that you wish to clean up.<br />
<br />
6) Apply to any other cells or columns you wish to clean up.<br />
<br />
7) Copy the data and paste the values over the original cells. Voila!</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com0tag:blogger.com,1999:blog-2881627473320231543.post-35672456010128201972012-04-01T07:41:00.003-07:002012-04-18T04:29:27.249-07:00How to Read Skype Chat History<div dir="ltr" style="text-align: left;" trbidi="on">
Two points first:<br />
<br />
1) You can read the history from within Skype by opening up a chat window for a contact and clicking on the links near the top of the chat window that indicate how far back to display conversations.<br />
<br />
2) The Skype log files are located here: c:\users\username<username><user name="" screen="">\AppData\Roaming</user></username><br />
<br />
Okay, now to read Skype history without having Skype open (and you must have Skype closed to unlock the files), try using this free software:<br />
<br />
<a href="http://www.nirsoft.net/utils/skype_log_view.html" target="_blank">SkypeLogView</a><br />
<br />
Very simple.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-55510195154105927242012-02-09T02:23:00.000-08:002012-04-26T02:35:23.463-07:00iPhone Screen Will Not Rotate On Its Side (Landscape Orientation)<div dir="ltr" style="text-align: left;" trbidi="on">
Before trying these steps, make sure that you have restarted your iPhone. Also note that some apps do not allow for the screen to sideways and therefore will never change to landscape orientation. But if nothing (pictures, web pages, etc.) will never rotate, then try these steps:<br />
<div>
<br /></div>
<div>
1) Double-tap the home button (black button at the bottom center of your iPhone) until a menu of apps appears as a bottom row on your screen.</div>
<div>
<br /></div>
<div>
2) Swipe the row to the left. You will see iPod controls plus at the left-most side an icon with a clockwise-pointing arrow.</div>
<div>
<br /></div>
<div>
3) If this arrow circle has a lock in the center of it, then it means your landscape mode is locked. Tap it to unlock it.</div>
</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com0tag:blogger.com,1999:blog-2881627473320231543.post-36572996089082228662012-01-19T06:26:00.000-08:002012-02-04T03:44:05.109-08:00Disable Subscribers on Facebook<div dir="ltr" style="text-align: left;" trbidi="on">
When Facebook rolled out the subscription services, I immediately approved it while not knowing exactly what would change. I learned it allowed non-friends to subscribe to my updates, even when I didn't accept their friend requests. Having no need for this, I wanted to disable it, but nowhere in the account or privacy settings could I find the section on subscriptions. Here's how to prevent people from subscribing to your content:<br />
<br />
1) Go to your profile (not the newsfeed, your actual profile page that someone sees to learn about you).<br />
<br />
2) Click on "Subscribers" on the left-hand menu.<br />
<br />
3) On the page that opens up, you should see a button "Edit Settings" in the upper-right. Click it.<br />
<br />
4) In the first section "Subscribers" change the drop-down option from "On" to "Off". <br />
<br />
There you go!<br />
<br />
UPDATE: For the new time line, you'll find "Subscribers" under the down-arrow menu to the right of your name at the top of your profile (and just below your cover photo).</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-45474950645820146492011-11-10T09:56:00.000-08:002011-11-10T09:56:57.874-08:00iPhone Stopped Vibrating<div dir="ltr" style="text-align: left;" trbidi="on">
One day my iPhone 3G made a funny noise when it started to vibrate. It sounded like the motor died mid-vibration. I thought this was the end of my old phone and I was going to be forced to purchase the latest and greatest model, which unfortunately is a problem since I need an unlocked phone for where I live.<br />
<br />
But I was able to revive it! I read online about placing the phone face-down and tapping the back -- not hard, but enough to shake it up a little. It didn't work, so I tried focusing on different parts of the phone. It seems the best location to tap is on the spot two icons from the bottom right of the screen (but on the backside of the phone). Basically, put the phone face-down and aim for that spot in the lower-left of the backside.<br />
<br />
It worked for me! It started vibrating, then stopped again. I had to tap it a couple more times before it would continue working without me having to tap it any longer. I imagine there's a piece of plastic or a seal floating around in there now, but I'm happy with extending the function for a bit longer.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com2tag:blogger.com,1999:blog-2881627473320231543.post-17132405948876127592011-11-04T04:20:00.000-07:002011-11-04T04:20:29.053-07:00iPhone - Nobody Can Hear Me!<div dir="ltr" style="text-align: left;" trbidi="on">
One day my very old iPhone 3G seemed to give its last breath when one day people were unable to hear me on a call, though I could hear them just fine. I figured the phone was just too old and the time had some to upgrade. Just to be safe, I scoured the internet and found a bug related to the iPod app, so I gave it a try and it worked!<br />
<br />
Many forums online say it happens when the headphones are suddenly unplugged during the middle of a song, but I couldn't recall such an incident since I don't listen to a lot of music on my iPhone.<br />
<br />
The fix:<br />
<br />
1) Start the iPod app.<br />
2) Play a song.<br />
3) Stop the song.<br />
4) Close the iPod app.<br />
5) Restart the iPhone.<br />
<br />
That worked for me and I haven't had any problems since! If this doesn't work, then try updating everything through iTunes. A workaround is to just use the hands-free cable until you can get a new phone. Some shops are able to fix hardware issues, but you need to weigh the costs vs. getting a new phone.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com47tag:blogger.com,1999:blog-2881627473320231543.post-87678834047030838972011-03-05T02:30:00.000-08:002011-03-05T02:30:47.684-08:00Skype: Remove Skype Links from Web Browser<div dir="ltr" style="text-align: left;" trbidi="on">When you browse the web, Skype will locate phone numbers and offer to let you call the phones through Skype. You have two options to disable this:<div><br />
</div><div>1) Uninstall "Skype Toolbar" from Add/Remove Programs.</div><div><br />
</div><div>2) In Skype, go to Tools > Options > Advanced and uncheck the boxes "Use Skype to call callto: links on the web" and "Automatically start Extras".</div><div><br />
</div><div>I recommend just getting rid of the toolbar, which often are culprits when web browsers crash.</div></div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-88386499955465059982011-03-05T02:23:00.000-08:002011-03-05T02:23:59.889-08:00Skype Slowness Issues<div dir="ltr" style="text-align: left;" trbidi="on">Problem: whenever Skype opens, the computer slows down significantly.<br />
<br />
Solution (possibly): I have seen some version of Skype slowdown when trying to pull contacts from Outlook. Though this feature might be nice for some reason, it wasn't for me and definitely wasn't worth bring my computer to a halt. Turn off this integration by doing the following:<br />
<br />
1. Open Skype. <br />
2. Go to Contacts and make sure "Show Outlook Contacts" is NOT checked.<br />
<br />
Older versions of Skype may have the "Show Outlook Contacts" option listed elsewhere, but you should <a href="http://bluescreensolutions.blogspot.com/2011/03/skype-we-are-having-problems-connecting.html">upgrade to the latest version of Skype</a> anyway. It may fix your problem without disconnecting the Skype/Outlook connection.<br />
<br />
Other things to try: uninstall Skype Toolbar or see if your antivirus might be the culprit. </div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com0tag:blogger.com,1999:blog-2881627473320231543.post-24769563171961971892011-03-05T01:45:00.000-08:002011-03-05T01:45:05.202-08:00Skype: "We are having problems connecting to the download server"<div dir="ltr" style="text-align: left;" trbidi="on">When you go to Skype's main page to download the latest version, you're not really downloading Skype, you're installing a downloader that manages the install of Skype. Confused yet? Anyway, sometimes the downloader has problems managing the connection and you'll get errors such as "We are having problems connecting to the download server." <br />
<br />
Solution: <a href="http://download.skype.com/partner/trackable243/SkypeSetupFull.exe">Download the standalone install for Skype</a>.<br />
<br />
This is especially useful if you have your own download manager that can resume should the source of the problem be a slow or unreliable internet connection. Or just use it to install it on several computers that may not have an internet connection at the time.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com5tag:blogger.com,1999:blog-2881627473320231543.post-25133049020144852642011-03-04T01:52:00.000-08:002011-03-04T01:52:50.802-08:00Windows cannot find 'search:query=cmd"<div dir="ltr" style="text-align: left;" trbidi="on">Problem: you go to Start and in the search field you enter the name of some system tool (cmd, run, regedit, etc.) and you get the error "Windows cannot find 'search:query=(whatever you wish to run)". Other searches seem to run okay, as long as its not a system file.<br />
<br />
The indexing service is running and restarting the computer doesn't seem to fix it. After much trial and error, I was able to fix the root of several problems by running this Microsoft Fixit solution: <a href="http://support.microsoft.com/kb/886549/en-us">KB886549</a>.<br />
<br />
I only list this on my blog because the article doesn't directly claim to fix the search:query= error, so I am happy to bring it to everyone's attention.<br />
<br />
<br />
</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com3tag:blogger.com,1999:blog-2881627473320231543.post-38180669167262380532011-02-27T11:04:00.000-08:002012-02-15T13:42:38.354-08:00Skype's Disappearing Cat and Other Hidden Icons<div dir="ltr" style="text-align: left;" trbidi="on">
Skype has some hidden emoticons not listed in the standard sub-menu of their chat window. The complete list can be seen <a href="http://www.skype-emoticons.com/" target="_blank">here</a>.<br />
<br />
However, there are a couple more that have caused people to think they may have a virus or wonder why exactly they are seeing:<br />
<br />
1) The disappearing cat.<br />
<br />
How to recreate it: hold down the keys C-A-T at the same time.<br />
What happens: a gray cat holds out its paw and eventually disappears. <br />
Why: this indicates that the typer's cat may be stepping on the keyboard.<br />
<br />
2) The disappearing hands.<br />
<br />
How to recreate it: hold down any three keys at the same time.<br />
What happens: two hands appear to wrap over the top of a line on the screen and eventually disappears.<br />
Why: this indicates the typer is probably leaning on the keyboard.<br />
<br />
It's somewhat a mystery that Skype wouldn't let its users know what these are supposed to mean to the user.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com58tag:blogger.com,1999:blog-2881627473320231543.post-9841602755667165962011-02-27T04:30:00.000-08:002011-02-27T10:56:31.397-08:00Can't install Microsoft Security Essentials (Error Code 0x80070643)<div dir="ltr" style="text-align: left;" trbidi="on">Problem: You can't install Microsoft Security Essentials and get an error coder 0x80070643.<br />
<br />
First, be sure to go through <a href="http://answers.microsoft.com/en-us/protect/forum/protect_start/installation-error-0x80070643/908fad3e-f9fc-4d8a-be83-ae7d3bc48db5">these steps.</a><br />
<br />
But when I found that this didn't help, I kept digging and realized I have was having other problems including not being able to open the Management Console or searching from the start menu. Error 1606 also appeared in the event log.<br />
<br />
That's when I came across <a href="http://support.microsoft.com/kb/886549/en-us">KB886549</a>, which addresses some registry settings pointing to user profile locations. Just run the "Fix it" button and you're set and should be able to install Microsoft Security Essentials.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-48164176108086189772011-01-22T23:17:00.000-08:002011-01-22T23:17:37.106-08:00Unhide Folders Hidden By a Virus<div dir="ltr" style="text-align: left;" trbidi="on">Problem: a virus reached your flash drive (maybe even your entire computer) and hid all you folders. You may even see that your folders have been replaced by a shortcut icon (one with a black arrow in the lower corner). After removing the virus, the folders can't be unhidden and the property check boxes do not respond.<br />
<br />
Solution: Use a command prompt to change the attributes.<br />
<br />
1) Open the command prompt by going to Start > Run and typing "cmd". A black screen will open.<br />
<br />
2) Type attrib -s -h /S /D x:\<br />
<br />
NOTE: x:\ should be the drive indicating your flash drive that has the hidden folders.<br />
<br />
Open the flash drive again and your folders should now be visible again.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-56184338789882312692010-08-23T01:02:00.000-07:002010-08-23T01:02:46.886-07:00Outlook 2003: MAPI32.DLL errorProblem: You open Outlook and you get the following error message:<br />
<br />
<div style="text-align: justify;"><em>Cannot start Microsoft Office Outlook. MAPI32.DLL is corrupt or the wrong version. This could have been caused by installing other messaging software. Please reinstall Outlook.</em> </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">Solution: For some reason, a repair installation doesn't seem to have any effect on this problem, but the solution is quite simple. </div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;">1. Browse to C:\Program Files\Common Files\System\MSMAPI\1033</div><div style="text-align: left;"><span style="font-size: x-small;"><em>NOTE: For 64-bit OS, the path might be C:\Program Files(x86)\Common Files\System\MSMAPI\1033</em></span></div><div style="text-align: left;"><br />
</div><div style="text-align: left;">2. Find the file MSMAPI.DLL and rename it to MSMAPI.OLD.</div><div style="text-align: left;"><br />
</div><div style="text-align: left;">3. Open Outlook 2003 and all should be well. A new MSMAPI.DLL file should be visiable.</div><div style="text-align: justify;"><br />
</div><div style="text-align: justify;"><br />
</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com0tag:blogger.com,1999:blog-2881627473320231543.post-62762040595445279902010-08-09T07:27:00.000-07:002012-05-16T04:48:42.111-07:00How to Remove Password Protection in Excel<div dir="ltr" style="text-align: left;" trbidi="on">
I've used this in Excel 2003, but it claims to work in other version:<br />
<br />
Download <a href="http://www.straxx.com/excel/password.html">Excel Password Remover 2010</a><br />
<br />
When you open the file, you may get a security warning, so open Excel and go to Tools > Macro... > Security and change the level to "Low." <br />
<br />
Open Excel Password Remover 2010 again and it will install.<br />
<br />
To unlock, go to Tools > Unlock Workbook (or Unlock Sheet) to be able to edit the document.</div>KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-69036019991862327022010-03-25T10:02:00.000-07:002010-03-25T10:02:40.736-07:00Jailbroken iPhone 3.1.3 Apps CrashI jailbroke my iPhone 3G with firmware 3.1.3 and after doing so, any new apps I installed would crash when trying to open. It was frustrating to see everything close and be back on the home screen. I finally fixed it:<br />
<br />
In iTunes, select the iPhone under the list of devices. <br />
<br />
Go to the Applications tab and click "Sync Applications."<br />
<br />
Click Apply.<br />
<br />
Click Sync.<br />
<br />
Once the Sync is complete, the apps should open. Very odd bug, indeed.KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com1tag:blogger.com,1999:blog-2881627473320231543.post-91808944252390331672010-03-03T15:59:00.000-08:002010-03-03T15:59:10.464-08:00Excel 2007 - How to Freeze Multiple Columns and/or Rows To freeze multiple columns in an Excel spreadsheet, click on the column to the right of the column you wish to freeze and click through the following:<br />
<br />
View > Freeze Panes > Freeze Panes<br />
<br />
You can do this for rows, too. <br />
<br />
If you want both rows and columns to freeze, then click the single cell you wish to start scrolling with, and go through the same menus above. KSLhttp://www.blogger.com/profile/06282399819697495772noreply@blogger.com3