Tag: line

• How To Search For ID Values In A Different Worksheet With Excel VBA

  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 […]

  Alvin Poh

  October 4, 2011

  Miscellaneous

  cell, Cells, change, client, column c, convenience, end, excel vba, line, Offset, Rng, sake, search, Sheet, use, vba code, WHERE

• Logitech K750 Review – Best Wireless Keyboard Review

  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, […]

  Alvin Poh

  September 1, 2011

  Miscellaneous

  amount, backspace key, concern, curtain, feedback, hand, hassle, line, logitech, logitech wireless, mice, mouse, naught, receiver, receiver technology, reliabilty, s green, Technology, type, unifying technology, use, wireless keyboard, worries

• How To Solve The Problem Of Always Having To Log On To A Network Drive In Windows

  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 […]

  Alvin Poh

  April 21, 2011

  Miscellaneous

  192 168 1 1, basis, batch file, computer, credentials, daily basis, line, local computer, logs, menu, Microsoft, password, PERSISTENT, solution, start, start menu, startup folder, type, use, username, YES

• How To Check All Checkboxes In A Form With Javascript

  I had an application that had a long list of checkboxes in a form. I wanted the ability to check all the checkboxes at once, or uncheck them at once. However, after googling for a solution, it seemed that all of them required me to label all my checkboxes with the same name. The nature […]

  Alvin Poh

  April 11, 2011

  Miscellaneous

  application, body, check, checkbox, Checkboxes, chunk, code, function, Googling, javascript, javascript code, line, list, solution, uncheck

• How To Redirect or Disable BBPress Registration Page

  BBPress is a great forum software that integrates nicely with WordPress. The problem is, it’s not as full-featured as the other forum software available. One of my gripes is the inability to change certain options. For instance, if you’ve integrated BBPress with your WordPress blog, then you want to redirect or disable the default BBPress […]

  Alvin Poh

  January 6, 2011

  Miscellaneous

  com, Disable, flick, forum, forum software, great forum, gripes, htaccess, line, problem, registration, root, root directory, switch, wordpress, www, yourdomain

• How To Activate/Install GD Library In WAMP Under Windows

  Some projects require activation of the GD library, and this is especially true when you have to do image manipulation with your PHP script. If you’re using WAMP (Windows Apache MySQL PHP) in Windows, then good news: WAMP comes with GD library, just that it’s not activated by default. To activate the GD library, go […]

  Alvin Poh

  February 16, 2010

  Miscellaneous

  activation, apache mysql, code extension, dll, extension, gd library, image, image manipulation, ini, ini file, Library, line, manipulation, mysql php, PHP, php script, script, semicolon, system tray, WAMP, Windows