Articles

I have a query in an Excel table.  I followed this to do it. But how can I add a parameter from a cell into my query? I am looking for a way to do this: select *from dbo.Customerswhere CustomerID = Cell.A2 The Cell.A2 does not work. But how can I add in something like […]

I am trying to run Notepad as admin so I can edit my hosts file from the command line. I have tried runas /user:(myusername)administrator “notepad c:windowssystem32driversetchosts” I then input my password and I get   RUNAS ERROR: Unable to run – notepad  c:windowssystem32driversetchosts 1327: Account restrictions are  preventing this user from signing in. For example:

Firefox can run in different profiles, that can be setup using different plugins, for different purposes such as basic web browsing, web development, trading on ebay etc… Is it possible to run more than one of these at a time, or does Firefox always run as a singleton? Solution: You can start multiple instances of

My motherboard has SATAI and I was wondering if I could buy SATAII hard drives and use it with it. I expect SATA I transfer speeds, but I wanted to make sure to see if that is okay to buy a new hard drive. Solution: Yes. SATA II interfaces are backwards compatible with SATA I

I just built a PC for the first time. My Gigabyte motherboard notifies me after the POST that I have SATA drives operating in “IDE MODE”. It asks me if I want to switch to AHCI mode to allow hot swapping. What’s the difference? Solution: AHCI, or Advanced Host Controller Interface, is a more featured

Is there a way to save all open tabs into a temporary (or non temporary) bookmark folder? Sometimes I have a bunch of tabs open on one topic in one windows and the same in another windows. I’d like to quickly save all open tabs in different bookmark directories so I can shutdown the computer,

I need to send some emails at a specific time of the day and need to do it every day. How can I do it with Outlook? Delay delivery helps to send mail at a specific of time; but how to create new mail to be sent for tomorrow? Solution: OK, here is a quick

What’s the Windows equivalent to cron, or for those of you unfamiliar with Unix, how does one schedule a program to run at regular intervals? Solution: Scheduled Tasks:   With Scheduled Tasks, you can schedule any script, program, or document to run at a time that is most convenient for you. Scheduled Tasks starts every

To push a file from a Linux terminal to a Windows system, the following two examples work just fine. scp /home/user.name/file.html user.name@local.ip.num:/C:/Users/user.name/test_folder/file.htmlscp /home/user.name/file.html user.name@local.ip.num:”/C:/Users/user.name/test_folder/file.html” I need to do this where the local folder has spaces and I cannot change the name, say /C:/Users/user.name/test folder/ All of the following fail with the message scp: ambiguous target

I remember hearing of some software that would take a screen print every 15 minutes and store it in a file. They mentioned it can be used to keep track of the amount of time you spent on a project.   I know of SnagIt. http://www.techsmith.com/screen-capture.asp What are some of the other packages out there?