Recent posts

User goes missing when restoring a database in MS SQL Server

I am setting up a disaster recovery box for the production website. For this, I took a backup of the production MS SQL database and restored it into the DR box.

When I run the application, I get an access denied message. I checked the database and I found that...



Read more
Fredrik Written on 05/16/2011 in Question

Search and Count in a Excel sheet

Hi,

I have an Excel sheet containing about 1,200 rows. Each of the rows has different customer information. I want to know how many of them have dues.

Problem is the number of rows is not fixed. They may vary. So I can’t count the number of empty cells and just...



Read more
Alisa Written on 05/16/2011 in Question

Public Function Code in Excel VB Programming

Hi,

I am learning Excel VB programming. It is quite easy. But I don't get how to use custom function in here?

Public Function gradeCal(gpa As Double)
            If (gpa >= 5) Then
                Return "A+"
            ElseIf (gpa >= 4) Then
                Return "A"
            ......
End Function

But its not...



Read more
Alex J Written on 05/16/2011 in Question

How to recover Windows Vista after formatting disk (in a Laptop)?

Hi everyone,

I have got Dell laptop and I am facing an issue while trying to recover my operating system. Actually, when I bought my laptop it had pre-installed Windows Vista.
 
I didn’t like the Vista at all because of its huge memory consumption. So, I formatted the hard drive but...



Read more
Strausss Written on 05/16/2011 in Question

How to create a custom Popup form in Excel

Hi,

I am doing some work with Excel. I am not much familiar with VB but the Excel macro seems easy and interesting. I have yet used MsgBox and buttons to do almost everything. The Excel sheet was the main window which is used as a form for hosting the...



Read more
Morse Written on 05/16/2011 in Question

Excel Programming Help Sum formula

Hi

I have been playing around with Excel a few days. It is really a nice tool. I can do a lot of calculations here with less effort. I have also heard that it is possible to do some programming with excel too. So i thought i will try.

Here is...



Read more
Schumacher Written on 05/16/2011 in Question

Common Commands use in Simple Mail Transfer Protocol (SMTP)



SMTP(Simple Mail Transfer Protocol) SMTP simply defines how command back and forth. Each device is free to choose a software  package for implementation. SMTP use command and responses message between Message transfer Agent client and MTA server. SMTP is a common protocol for...

Read more
jaypatric Written on 05/16/2011 in Blog

How to fix spyware/adware issue?

Hello Dears,

I am a user of MS XP professional edition and I am facing an issue of spyware. In fact, a few months ago I had purchased a product named, Lenovo ThinkPad T61 and I installed AVG Antivirus professional, along with Microsoft Windows defender (registered).

However, from the first...



Read more
kevino Written on 05/16/2011 in Question

Microsoft System Center Virtual Machine Manager



Microsoft System Center Virtual Machine Manager “Microsoft System Center Virtual Machine Manager” is quite a mouthful, so let’s begin by breaking it down: Microsoft – that huge software systems company; which we sometimes love, sometimes not. Systems Center– a range of management solutions to “help...

Read more
joseph.mack Written on 05/16/2011 in Blog

How to fix system restore point issue in XP SP2?

Hay Guys,

I am running XP service pack 2 and having a critical issue while using it. The issue which has occurred to me is that I cannot restore my PC to any previous restore point. Whenever, I want to restore via restore wizard it starts to restore but in...



Read more
Dilhara Written on 05/15/2011 in Question