AWeber is a company that does a very good job of providing mailing list services, and is always innovating and coming up with new ways that you can improve your email marketing. One of their latest innovations is how they’ve created a way that allows any Facebook user to automatically sign up with your AWeber list.

With this new Facebook feature, Facebook users do not need to enter their names or email addresses to join your email list. As long as the user is logged into Facebook, all that data is pulled from Facebook and pre-populated automatically into your AWeber form – all the user has to do is to click on the “Register” button on your AWeber form. If the user isn’t logged into Facebook, then they’d see the normal, non-Facebook version of the sign-up form.

As you can imagine, as this makes things for your users dramatically simpler, and you’ll find sign-up rates going through the roof. In fact, there are several benefits to this form:

• Facebook users don’t even need to key in their details anymore (all that they need to do is to click once!) so the barrier for entry is significantly lower
• Emails are definitely valid and active since these are the users’ active Facebook accounts
• No chance of typos and errors during the submission process

How To Enable Facebook Integration With AWeber

All you need for this Facebook integration is to enable the option for “Facebook Integration” on your AWeber form creation wizard. Do note that these forms need to be at least 300px wide. You can also edit existing forms by going into your form properties and enabling the Facebook integration option.

Give Facebook Integration A Try – Special AWeber Discount

Mailing lists are a great way to monetise your website and keep in touch with your users. AWeber is one of the best mailing list companies around, and has a tonne of features that can help you in your email marketing.

You can get a special $1 trial account (backed by AWeber’s money-back guarantee) by visiting AWeber through this link, and try out AWeber’s full set of features, i.e. unlimited email campaigns, broadcasts, automated follow-ups, etc. Anytime you’re not satisfied with their service, just discontinue your subscription, or drop them an email to process your money-back guarantee.

The G2M3 codec is a codec that GoToMeeting uses. Not all computers, including Macs, can play videos encoded with the G2M3 codec. To convert videos encoded with the G2M3 codec into the normal WMV video codec so that any computer can play it, you need to download the Window Media Encoder and convert the video file.

Here are the steps:

1. First, download and install Window Media Encoder
2. Go to Start Menu > Programs > Windows Media > Windows Media Encoder
3. Choose to “Convert a File”
4. For the Source file, browse to the WMV video file that you want to convert
5. Choose “File Download” and click on Next
6. For Video, choose DVD quality (1Mbps VBR) and for Audio, choose CD quality (VBR), and click on Next
7. Click on Next again, there will be no changes on this screen
8. Uncheck “Begin converting when I click Finish”, and click Finish
9. Click on Properties > Compression > Edit
10. Select everything in the Bit Rates box and click Edit
11. Check the box that says “Same as video input”
12. Click Ok > Apply > Start Encoding

Done!

If you’re trying to activate Windows 7, and are faced with the following error:

Error Code: 0x8007232B
Description: DNS Name does not exist

You can try this to solve the problem. Search for “cmd”, then right-click on “cmd.exe” and choose to “Run as adminstrator” (this is important!)

Then type these:

slmgr.vbs -ipk [Your Windows 7 Product Key with the dashes]

slmgr.vbs -ato

That should work and activate your copy of Windows 7.

1. Casio Men’s DW5600E-1V G-Shock Classic Digital Watch

This is a classic bulletproof G-Shock watch. If you want fancy features like a thermometer, barometric pressure graphs, multiple alarms, and world time, then you’d have to look elsewhere! If you want a watch that keeps accurate time, lasts forever, and can take a ridiculous amount of beating, then this is the G-Shock watch for you. See more details »

2. Casio Men’s MTG900DA-8V G-Shock MT-G Atomic Tough Solar Watch

This watch syncs with the atomic clock automatically every night, so it is completely accurate, even with the changes in daylight savings time. It also draws power from the sun, and doesn’t require battery changes. It’s also not only water-resistant, but completely waterproof and very tough. You can even throw it in the dishwasher when it gets dirty and it’ll come out sparkly clean, and working perfectly well. Auto-backlight also means you no longer have to hit any buttons to see the time at night – just flick your wrist! See more details »

3. Casio Men’s DW6900-1V G-Shock Classic Digital Watch

Another classic G-Shock watch that’s simple, and built like a tank. It’s solid construction is so sturdy that you can even use this G-Shock watch as a makeshift hammer, and it’d still be fine. See more details »

4. Casio Men’s AWG100-1A G-Shock Multi-Band Solar Atomic Analog Watch

This G-Shock watch is beautiful, and unlike the digital sports G-Shock models, this has a classy look to it. It has about everything you need: solar-powered battery, self-adjusting atomic time, waterproof, multiple alarms, hourly chime, stopwatch and timer. And because it’s a G-Shock, it’s also indestructible. See more details »

5. Casio Men’s GW6900-1 G-Shock Atomic Digital Sport Watch

Essentially a solar-powered, atomic, matte black watch with dozens of timezones pre-programmed in. You’ll have the peace of mind knowing that no matter where in the world you are, you’ll just need to look down at your watch, and get the accurate time. See more details »

6. Casio Men’s GW9000A-1 G-Shock Mudman Solar Atomic Watch

This is a solar-powered G-Shock, so you don’t have to worry about your watch battery ever dying. The multi-band time sync can not just work with signals from Colorado, but in Europe, or Japan if you’re there as well. Like all G-Shock watches, it’s built like a tank and is indestructible. See more details »

7. Casio Men’s GW5600J-1 G-Shock Atomic Tough Solar Watch

This watch is based on the old 5000 series of G-Shock watche, but improved with new technology. You get an atomic, solar-powered, 5 alarms, countdown timer, and full backlight with this G-Shock. If you like the classic G-Shock look, but desire a little more functionality, then this is the G-Shock for you. See more details »

8. Casio Men’s G9000-1V G-Shock Mudman Digital Sports Watch

This G-Shock watch is lightweight, but heavy-duty. Survives wars and military conflicts with no problems. It’s called a Mudman because this watch was designed to be impervious to mud. Great for wars, everyday wear, hunting, fishing, camping, and the gym. See more details »

9. Casio Men’s G-Shock G-Rescue Solar Atomic Classic Color Watch

This G-Shock watch is a very large watch compared to the other G-Shock’s, but it does feel very nice and comfortable. The watch is full-featured, with solar-power, atomic feature, multiple alarms, a timer, world time, etc. The one obvious feature of this G-Shock watch is that it is all black, which is a nice look. Even the digital face is inverted, so that it is black with light grey for the numbers. See more details »

10. Casio Men’s GLX5600-7 G-Shock G-Lide Surfing Watch – White

This G-Shock watch is smaller than most other G-Shock watches, which is nice if you have a small wrist. It is lightweight and it looks really good, and can be worn even if you’re not surfing (or if you’re not a surfer). Colors are much less tactical-looking than the typical G-Shocks, and has a glossier finish rather than the typical matte one that G-Shocks have. See more details »

Tyres (or tires, depending on where you’re from) are a vital part of the car, and are especially so since they are the only form of contact that your car has with the road. Regular checks on your tyres and performing regular maintenance should be the norm, but first you need to know that there are seveeral areas that you need to understand about your tyres.

Tyre Manufacture Date

Tyres have a 4-year lifespan and the manufacture date of the tyre is imprinted on the side of the tyre. Expired tyres face a much greater risk of bursting and will likely result in a serious or fatal accident.

Manufacture dates are 4-digits long, like this: 0709. This means that the tyre was manufactured in the 7th week of 2009.

Optimal Inflation Pressures for Tyres

Different tyres are rated for different pressures. You will find your maximum tyre inflation pressure imprinted on the side of the tire, like so: “(50 PSI) MAX PRESS”. You should never exceed this pressure, but it’s fine to go slightly below it. If your tyre pressure is too low, your tyre will heat up more and cause tyre damage.

The following is a table of maximum pressures and their minimum acceptable pressures:

Besides this, other critical points to take note of is the maximum load capacity of the tyre, maximum speed rating, and traction (on wet surfaces). More information about reading and understanding tyres can be found on the tire code wiki page.

This Excel VBA function allows you to take a column of values (e.g. ID numbers) in one worksheet, and use that to get corresponding values that are in a second worksheet. If you understand SQL, it’s something like:

SELECT b.country FROM idtable as a, countrytable as b WHERE a.id=b.id

I’ll explain the scenario further with screenshots, but basically we have one worksheet having client IDs, and another worksheet having client IDs with their corresponding countries.

The first worksheet looks like this. Notice the country column is column A and we’re looking to fill that up. Our IDs are all in column C:

And this is how the second worksheet looks like. Notice the headers are removed for convenience’s sake. We’re going to search column A using the IDs in worksheet 1, then grab every row’s country value.

Here’s the VBA code. Just stick it into your VBA editor, and run it to see what it does. A few things to note:

• Find this line For Each Cell In Range(“C2:C8″), and change C2:C8 to the range of cells that contain the IDs that you want to search for.
• Find this line With Sheets(“Sheet2″).Range(“A:A”), and change A:A to whichever column that you’re trying to search in.

Sub findCountry()
    Dim FindString As String
    Dim Rng As Range

    For Each Cell In Range("C2:C8")
        FindString = Cell.Value

        If Trim(FindString) <> "" Then
			'The 2nd worksheet is assumed to be Sheet2. Change this if it is not the case
            With Sheets("Sheet2").Range("A:A")
                Set Rng = .Find(What:=FindString, _
                                After:=.Cells(.Cells.Count), _
                                LookIn:=xlValues, _
                                LookAt:=xlWhole, _
                                SearchOrder:=xlByRows, _
                                SearchDirection:=xlNext, _
                                MatchCase:=False)
                If Not Rng Is Nothing Then
                    Application.Goto Rng, True
					'In Sheet 2: This line shifts 5 cells to the right and gets the country value
                    TheCountry = ActiveCell.Offset(0, 5).Value
					'In Sheet 1: The country value is pasted into the cell 2 cells to the left of the cell containing the ID
                    Cell.Offset(0, -2).Value = TheCountry
                Else
                    MsgBox "Nothing found"
                End If
            End With
        End If

    Next
End Sub

I was using the Logitech K340 keyboard for around a year. Back then, the Logitech Wireless Solar Keyboard K750 was not released yet.

While the K340 keyboard was great at the start, after some time the keys would get stuck. E.g. I would be pressing down on the backspace key, and it would remain stuck, deleting not just a couple of characters, but the entire line of text. Needless to say, this was infuriating. So I went around, looking for another keyboard.

I found my answer in the Logitech K750. It seemed like the right one to get, but my biggest concern before buying this keyboard was that it doesn’t use batteries at all. On one hand, that’s great because it’s green, good for the environment, and saves me the hassle of changing batteries every few months.

On the other hand, I was afraid that it might just die too often because something that doesn’t use batteries just doesn’t seem to have the same sense of reliabilty to me.

It turns out though, that my worries were for naught. My room has a single window that’s usually covered by the curtain and my keyboard can last through several hours of use daily and I have never turned the keyboard off. Using the Logitech Solar App shows that the power level of the keyboard never dropped below 100%.

The keys on the Logitech K750 are perfect to me. They are comfortable to type on, and spaced out nicely. Pressing down on the keys give you a small amount of feedback, akin to typing on a laptop, but with much sturdier keys.

The reason why I chose this particular keyboard was because of Logitech’s unifying receiver technology. I use both a unifying mouse (read my review on the the Logitech MX Anywhere mouse) and keyboard, so I only have to use one Logitech USB receiver. That’s the thing that really sold me on to Logitech mice and keyboards using the unifying technology.

Even after a couple of weeks of usage, I’m amazed at how well the Logitech Wireless Solar Keyboard K750 types and performs. I’m very impressed with it, and have no qualms recommending it highly.

In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned.

The following are the values that different integer types (signed/unsigned) can hold:

I have a Logitech keyboard that was acting up on me and squeaking when I type on it. It got so bad that I couldn’t take it anymore and went to find a way. Turns out that there’s a pretty cheap way to fix squeaky keyboards.

The solution? Silicone spray (Get it from Amazon). Silicone spray is pretty fantastic and is super slippery and non-reactive. So besides your keyboard, it can lubricate almost anything. It works especially well on porous items, such as plastic, but is also a good lubricant on hinges, locks, and so on.

I knew which keys were giving me the problems, so I used an old badge to pry them out, sprayed some silicone spray, and put the keys back. After which, everything was all good again!

If you try to map a network drive in Windows, and use different user credentials, you’ll realise that you’ll need to always type in the username and password every single session. If you shut down your computer everyday, that means you’ll need to do this on a daily basis.

This is horrible too, if you have programs that automatically try to connect to your network drive, as it’ll most likely just fail.

The official solution from Microsoft is to make sure your user credentials on your local computer matches with that of the network drive that you’re trying to connect to. However, that’s hardly practical and probable in real-life.

The following solution is a simple line of code that you can save as a batch file that when run, creates a drive (Z: in this case) and automatically logs in for you. Set it to run whenever you log in by placing this batch file in your Start Menu/Startup folder.

net use Z: “\\192.168.1.1\yourfolder” PASSWORD /USER:”yourusername” /PERSISTENT:YES

Note: You’ll have to disconnect your existing drives and make sure that the drive letter isn’t being in use for this batch file to work properly.