Archive for March, 2010

Why is my Macro skipping the If statement completely?

March 31, 2010 - 1:02 pm 4 Comments

I have a VB Macro to compare data in an Excel spreadsheet and if the totals match up then it needs to delete the specified rows. It matches certain values and deletes but in some instances it skips the entire if statement. If i go through it step by step i can see it doing that. The values are majority decimal and i have converted any text from the cells into Double.

Please help me urgently!!!!!!!!!!!!!!

Unless we have the source code how we will solve it.

If you want please send the workbook to me (jn1717@gmail.com). I will try to solve.

Do you agree with this statement about Peyton Manning?

March 31, 2010 - 1:02 pm 13 Comments

Ok, so I was on Yahoo! Answers last night looking through questions to answer when I saw this. I wont name names, but someone wrote that they would prefer 10 other active QBs to win a Super Bowl for them than Peyton. They also said that they would prefer Eli over Peyton. Do you agree with that statement? If so, list the names of them.

Thank You

KILAKOMUKU!!!

Peyton will go down as the greatest QB to have ever played the game when he retires. People say that Big Ben and Tom Brady are better because they’ve proven themselves by winning superbowl and that statement is stupid. I think winning superbowls is a major part in being great, but sometimes it’s hard to win with the hand you’re dealt. Tom Brady had a good defense to go along with a good offense, and now that the defense has gotten old and isn’t good anymore how good have he Patriots been? In Big Ben’s first superbowl he had the lowest QB rating for any starting QB to win the superbowl. Even though Big Ben drove Pittsburgh back last year to win the superbowl it was James Harrison’s interception that put Pittsburgh in the drivers seat. As bad as New Orleans defense was this year they were near the top of the league in creating turnovers and that makes up for so much. When Pittsburgh’s defense struggled last year the Steelers didn’t even make the playoffs and Big Ben played pretty good still. Peyton has never had a good defense to work with, and is always ranked near the bottom in overall defense, they’re weren’t creating turnovers either. Every WR he’s had to throw too he had to start as a rookie, with the exception of Marvin Harrison, but year in and year he makes the playoffs and wins divisions. When he gets ready to retire he’ll have almost every career record, he’s already been to 3 AFC championships, 2 superbowls, and has 1 superbowl championship. He would have accomplished everything a QB could have accomplished in a career so why no put him down as the best in the league when no QB playing will have the records to go with the accomplishments like Peyton has.

What is a thesis statement and how do I write a good thesis statement for an research paper?

March 31, 2010 - 1:02 pm 1 Comment

i have to write a really good thesis statement for my teacher but i dont know how to write one. its about cavalier poets, how do i start my thesis statement?!?!?!?!

You define the term; comment on how they differed from previous poets and what you hope to show about them in your thesis.

Can voluntary statements be admissible is court after miranda rights are read?

March 31, 2010 - 1:02 pm 2 Comments

After your miranda rights are read and the officer proceeds to question and you answer, can those statements be admissible in court or must the officer stop asking questions once a lawyer is requested?
I meant *in court, not is court!

"You have the right to remain silent, if you give up this right everything you say can and will be held against you………" That means if you continue talking, you can be held for anything you say. If you have your rights read to you, you should say : " I have nothing to say until I talk to a lawyer.

If you sign a voluntary resigntion statment can you collect unemployeement?

March 29, 2010 - 11:18 am 5 Comments

i was told i would receive 2 week pay if I signed a statement

No.~

What is a thesis statement and how do I write a good thesis statement for an essay?

March 29, 2010 - 11:18 am 1 Comment

I need help writing a thesis statement for a character analysis essay on Julius Caesar from Shakespear’s play, "Julius Caesar". But I’m not sure what exactly a thesis statement is and how to write one. Can someone please give me an example of some sort? It would be very helpful and highly appritciated. Thank you.

A thesis statement is the point you are trying to prove for your essay. So say you are analyzing Brutus, You could say, Although Marcus Brutus thought recklessly throughout Shakespeare’s novel Julius Caesar, he possessed an honorable stature and did not back down from his beliefs. And then you prove it by stating information and such. Your thesis statement is stated in your introduction paragraph too

if you withdraw a statement and there is no other evidence will everything be dropped?

March 27, 2010 - 8:18 am 6 Comments


I see from your other questions that you are the victim and only witness.

Take no notice of all the answers saying you’ll have to go to court. You most certainly CAN retract your statement and the case will be written off for want of prosecution. Speak to the officer in the case and explain your feelings. He/She will probably try to get you to proceed but at the end of the day, if there have been no charges so far, you can stop the matter from progressing further.

People need to understand the charge of wasting police time (sec5 Criminal Law Act 1967) is an extremely rare charge and is only used where the costs both financially and in man power are detrimental to the forces budget. The force can only Proceed with the say so of the Director of Public Prosecutions. In your case, this is just not going to happen.

How may an SQL statement be executed with success regardless as to which database it is executed from? Give a?

March 25, 2010 - 8:09 am 1 Comment

SQL

by fire

How do I find the select statement of an old View in Oracle?

March 25, 2010 - 8:09 am 1 Comment

I’m new to Oracle and working in SQL plus. There are several old views that were created before my time. How could I read the SQL statements for those VIEWs? I tried the following….

select * from all_views where name=’permit_issued’

Try out

dba_views or user_views

you will get the statement in these views

If we all pulled together as a team we could really improve things. What do you think of this statement?

March 25, 2010 - 8:08 am 8 Comments


Aw, you make it sound like people would actually put aside their differences and get along. That’s kinda cute.