Archive

Getting a “more than one row returned” error when running a SQL.

 

I am using a EJB project to access my MySQL database.  I keep getting an error, "more than one row returned" when I run a select * from budget table.

 

Read more
Andreas N/A Written on 05/16/2011 in Question

IM Chat or Yahoo Messenger for Fedora 7

Hello,

I have some difficulties that I hope one of you can help me solve them.

I have been using Linux Fedora 7 for quite some time now and it’s working very well without a glitch. I want to use Yahoo Messenger instead of other IM software because I want to use my cam as well. I have used Pidgin before but have no clue on how to use webcam together with the chat software. Don’t get me wrong. Pidgin is wonderful and all, but I really need to use webcam along with the chat software.
Read more

kimsharpe N/A Written on 05/16/2011 in Question

Getting a “operation time out” when indexing tables in MS SQL Server

I am attempting to create an Index on one of my tables. I keep getting "operation timed out". Why is this?

Read more
Franklin N/A Written on 05/16/2011 in Question

How to access USB disk drive when using remote desktop

I am using remote desktop to login to my office computer. I have a set of files on my USB disk. How do I access the files within remote desktop ?

Read more
Katharina N/A Written on 05/16/2011 in Question

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

How do I restore it ?

Read more
Fredrik N/A 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 minus it from total rows. Do you have any suggestion?

Read more
Alisa N/A 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 working. What is the proper syntax of returning some value from a Excel function?

Read more
Alex J N/A 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 not the partition which was meant for Vista recovery earlier. Then I installed MS XP professional 2007 on my laptop. Whereas, now I am willing to get back my previous system software (Windows Vista) for some specific purposes. My bad, it is not recovering now.
 
For the solution of this issue...

Read more
Strausss N/A 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 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.

Read more
Morse N/A 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 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.

The problem is that it is...

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