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 the user mapping is gone!

How do I restore it ?

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 minus it from total rows. Do you have any suggestion?

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

Hi everyone,

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 other stuffs.

For example if i need 3 data to input I use something like

x = InputBox("enter the value", "Its the title")

3 times.

Now I think it would be cool to have my custom popup messages/forms for doing all these. But how do I do this? Please help.

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 what I want to do first.

My present sheet has 7 columns each are having a value (cash amount) in each of them. The 8th column holds the following equation:

=SUM(A1:C1)/3+SUM(D1:E1)/2+F1+G1              

So it gives the summation of the left 7 columns. The equation changes from A1 to A25 , depending on the row number.

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 day, I have been facing a problem. The advert pages appear in my browser continuously. The window which appears is usually for a reasonably credible advert like eBay, Walmart etc. Also the title at the top of the advert pages screens always use to begin with a specific symbol.

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 the end computer gives a message that no change has been made. I have tried this particular trick at several restore points but none of them was restored successfully.

Hi dear,

I am a user of MS windows XP SP2 and I am having an issue related to my mouse cursor. The issue I have is that my cursor is not in my control anymore. Actually, Last night, I think that the surge protector has given up the ghost. In result the computer and a lamp went out rashly.

After that incident I got my computer restarted again but now I am observing that there is a high-pitched sound as like a keyboard, which should have been locked. And even anytime I use to put the cursor in a typing-window or address bar, my mouse cursor just races away to the other end of it. For some reason over the last two weeks I have gotten a specific message that windows of mine may be counterfeit and I should have had it for literal time period.

Hi All,

I have started to have an issue with my wireless connection. Actually, I have the Wireless on my laptop and it is not been able to find the wireless connections around me. Whereas, I am still able to use them properly on other devices such as my cell phone etc.

When I use to make a wireless connection via my laptop, it sometimes connect but probably not more than 15 minutes or even less than this. And even whenever I try to connect again, it no longer detects any connection or modem not at all. Moreover, as a result those connections which were available in the beginning got lost.