Over 1 million tech questions and answers.

double case or if statement branch

Q: double case or if statement branch

Trying to create a sheet whereby I can direct traffic or run macros from 2 different cells (not at the same time) see file.

So if 1 is entered into cell C5 then it runs macro a, if it is 2 it runs macro b etc etc
&

So if "fred" is entered into cell e5 then it runs macro barks, if it is "son" it runs macro "zoo" etc etc

Would like to be able to do this on more that 2 cells if possible.

RELEVANCY SCORE 200
Preferred Solution: double case or if statement branch

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: double case or if statement branch

Read other 9 answers
RELEVANCY SCORE 62.4

Is there a limitation of how many case statements can I use????

Thanks
 

A:case statement limitation

Read other 7 answers
RELEVANCY SCORE 62.4

Hi,I am trying to get a total count of rows for each case when statement. However my results spit out the count for each unique field value which gives me countless results. Please let me know what I need to change in my logic. Thanks.

select count(*), FIELD1,
count(case
when FIELD1 > 0.00 and FIELD1 <= 0.05 then '00-05'
when FIELD1 > 0.05 and FIELD1 <= 0.10 then '05-10'
else 'ERROR'
End)
from TABLE1
where FIELD1 <> 0.00
group by FIELD1

 

A:Count by Each Case When Statement

Have you tried "Distinct Row"?
 

Read other 1 answers
RELEVANCY SCORE 62.4

Hi,

I have created a query with a case statement. It reads as follows:
Code:
select a.ip_sett_acc_id "Fund Name",
b.BUY_SELL_IND,
d.sedol "SEDOL",
d.sec_short_name "Security Name",
b.trade_date_time "Trade Date",
b.sett_date_time "Settlement Date",
b.ORDER_QTY "Share Amount",
b.original_face "Original Face Value",
b.deal_price "Unit Price",
b.TOTAL_NET_CASH_AMT "Net Consideration",
b.TOTAL_SETT_CCYCODE "Settlement Currency",
(case c.financial_instrument_type
when 'COMM' then 'Equity'
else 'CORP'
end)

I would like to display the financial_instrument_type field as 'Transaction Type' in my report. How do I do this? I have tried:
Code:
select a.ip_sett_acc_id "Fund Name",
b.BUY_SELL_IND,
d.sedol "SEDOL",
d.sec_short_name "Security Name",
b.trade_date_time "Trade Date",
b.sett_date_time "Settlement Date",
b.ORDER_QTY "Share Amount",
b.original_face "Original Face Value",
b.deal_price "Unit Price",
b.TOTAL_NET_CASH_AMT "Net Consideration",
b.TOTAL_SETT_CCYCODE "Settlement Currency",
-- c.financial_instrument_type as "Transaction Type",
(case c.financial_instrument_type
when 'COMM' then 'Equity'
else 'CORP'... Read more

A:Name a column in a case statement

You will need to use the "as" keyword.

select a.ip_sett_acc_id AS "Fund Name",
b.BUY_SELL_IND,
d.sedol AS "SEDOL",
d.sec_short_name "SecurityName",
b.trade_date_time "Trade Date",
b.sett_date_time "Settlement Date",
b.ORDER_QTY "Share Amount",
b.original_face "Original Face Value",
b.deal_price "Unit Price",
b.TOTAL_NET_CASH_AMT "Net Consideration",
b.TOTAL_SETT_CCYCODE "Settlement Currency",
-- c.financial_instrument_type as "Transaction Type",
(case c.financial_instrument_type
when 'COMM' then 'Equity'
else 'CORP'
end)
 

Read other 1 answers
RELEVANCY SCORE 62.4

Hi,

Please let me know what I need to do to sum each case when statement. I am trying to get the results to look like this:
[FONT=Courier New][COLOR=#0000ff][FONT=Courier New][COLOR=#0000ff][FONT=Courier New][FONT=Courier New][SIZE=1][/SIZE][/FONT][/FONT][/COLOR][/FONT][/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff][FONT=Courier New][COLOR=#0000ff][FONT=Courier New][FONT=Courier New] [/FONT][/FONT][/COLOR][/FONT][/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff][FONT=Courier New][COLOR=#0000ff][FONT=Courier New][FONT=Courier New]PRICE(All products) COUNT SUM(For Each row)[/FONT][/FONT][/COLOR][/FONT][/COLOR][/FONT]
[FONT=Courier New][COLOR=#0000ff][FONT=Courier New][COLOR=#0000ff][FONT=Courier New][FONT=Courier New]00-05 30 63
[/FONT][/FONT][/COLOR][/FONT][/COLOR][/FONT][FONT=Courier New][COLOR=#0000ff][FONT=Courier New][COLOR=#0000ff][FONT=Courier New][FONT=Courier New]05-10 20 181
[/FONT][/FONT][/COLOR][/FONT][/COLOR][/FONT]ERROR 5

select PriceGroup as Price, count(*) as Count
from (select case
when Price > 0.00 and Price <= 0.05 then '00-05'
when Price > 0.05 and Price <= 0.10 then '05-10'
else 'Error'
end as PriceGroup
from Store
group by PriceGroup
order by PriceGroup
I appreciate any help on this.




- Jeff

 

A:Summing Each Case When Statement

is this for an ACCESS query? if it is then working with the query in design mode is easiest?

If you can post the database it will be easier for me to work with your structure than trying to replicate all the fields and tables.

it looks like you need a combination of VBA executing SQL. I cheat by usign the Query design so I get the results as close as possible then with VBA I add the conditions to alter what is passed with SQL
 

Read other 1 answers
RELEVANCY SCORE 61.6

I'm building a small program for school to generate random numbers then do various tasks based on the number
this sounds perfect for a case statement...the only issue is there are a ton of issues...i don't even know how to fix them all
this is the

Code:
#include <stdio.h>
#include <stdlib.h>
#include <time.h>
int trackerH, trackerO, trackerN, trackerC, charge, Atom, Years;
float weight, AcidWeight;
int main ()
{
srand(time(NULL));
for (Years = 0; Years <=3800000000; Years++);
Atom = rand() %3 + 1;
switch (Atom)
{
case 1:
trackerH += 1;
weight = weight +1.0079;
charge = charge +1;
break;

case 2:
trackerO +=1;
weight = weight +15.9994;
if (charge > 0);
{charge = charge-2;}
break;

case 3:
trackerN +=1;
weight = weight +14.0067;
if (charge > 0);
{charge = charge -3;}
else
{charge = charge -1;}
break;

case 4:
trackerC +=1;
weight = weight +12.0107;
if (trackerC /3 = 0){
if (charge > 0){
charge = charge -2;}
else if (charge > 0){
charge = charge -4;}
else{
charge = charge -2;}
}
}
}



and these are the issues i'm getting
amino.c: In function 'main':
amino.c:9:1: warning: this decimal constant is unsigned only in ISO C90 [enabled b y default]
amino.c:31:1: error: 'else' without a previous 'if'
amino.c:38:17: error: lvalue required as left operand of assignment
i managed to fix a few wh... Read more

A:Solved: Issue with a case statement

You need to work on your indentation You should indent after every opening bracket. I can barely tell what the last three brackets do. And you really shouldn't end brackets on the same line as the code. It should be on the next line. Same goes for opening brackets - they should precede code, not just be a space before the line of code. It's just advice from experience, and it makes debugging your code a thousand times easier.

Here's proof:
Code:

if (trackerC /3 = 0){
if (charge > 0){
charge = charge -2;}
else if (charge > 0){
charge = charge -4;}
else{
charge = charge -2;}
}

Fixed:
Code:

if (trackerC /3 = 0) {
if (charge > 0) {
charge = charge -2;
} else if (charge > 0) {
charge = charge -4;
}
else {
charge = charge -2;
}

Now it's much easier to realize you're missing a bracket There should be one right before the last 'else' statement, to close the 'if' statement that precedes it. That's what your error message is saying.
 

Read other 3 answers
RELEVANCY SCORE 59.6

i want to get user input like this

please tell which option to chose
1. mango 2. tango 3. rango

if user chooses mango

then it should execute a set of statements and again ask like this

what do you want to do
1.add 2.subtract 3.exit

when i choose exit it should goto my previous menu asking again (please tell which option to chose
1. mango 2. tango 3. rango )

i have did coding to an extent like this

#!/usr/bin/ksh

echo -e -n "\n Specify the script to be run \n specify the names as listed in the below format \n 1. mango 2. tango 3. rango 4.exit"
read answer
echo "$answer"

# Processing the user input which was given
while true
do
case $answer in
mango) echo "###################################################################################"

DT=$(date)
echo "******************* $DT ***********************"
echo -e "\n Specify what you want to do from the below options \n 1.add \n 2.subtract \n 3.exit"
read input

if [ "add" = "$input" ]
then

elif [ "exit" = "$input" ]
then
elif [ "subtract" = "$input" ]

else

echo "!! must specify add or subtract"

fi
tango) echo "tango"
break;;
rango) echo "rango"
break;;
exit) exit 0;
break;;
*) echo "please enter correct value" read ;;
break;;

As you can see first it will ask me to choose from 6 options
1. mango 2. tango 3. rango 4.exit

. If for example if i chose 1. mango
th... Read more

A:VERY URGENT Trouble in getting user input while using under CASE statement in UNIX

You need to create functions.
 

Read other 3 answers
RELEVANCY SCORE 53.6

I would like to double click on any cell from b4 to b100 and it will turn it to upper case as well as double click on any cell from c4 to c100 and make it proper case. Can someone help me out with this)
 

A:Solved: double click for upper case

Read other 6 answers
RELEVANCY SCORE 46

Weird problem bugging me for a while. Every email I sent became double in the receivers' inbox. When I upload photos, every file became double. The above happened since a month ago, I believe and I didn't think much about it till this morning. I bought something on ebay, and that listing has multiple quantity available. I bought 1 item, but in the end it became 2 separate transactions. Both end times are the same, even the seconds are the same. So why is this happening? Can someone help me please? Thanks.

A:Double emails, double uploads, double transactions

Hi Luther,

What email client or clients are you using and is it setup to connect to Exchange or POP or maybe both?

By the way we only see one post...

Read other 1 answers
RELEVANCY SCORE 44

ZDNet blog article here.

Paul Murphy (pseudonym) continues his discussion about development languages, and asks a potentially embarrassing question: has the whole object orientation business been both a functional and a conceptual failure?

After reading his article, what do you think? {Agree, Disagree, Other Point-Of-View}

-- Tom
 

A:Is OOP a branch to nowhere?

I dissagree in some part.

To say OOP as a whole is a failure i tihnk would be over generalising things. In some respects there has been no visible use for it. But in terms of some software devlopment it has been a vast improvement.

For example since switching all of my PHP web applications to a OOP scheme has enabled me to create moremodular designs capable of greater flexibility and scalability. Also i have noticed significant speed and efficiency increases over traditional code schemes.
 

Read other 2 answers
RELEVANCY SCORE 44

ive heard that there is going to be a new company working on a OS thats supposed to be a lot better than windows and because windows linux and mac os are really the only three majot os i wonder how its going to impact the os industry.
 

A:A new Branch of OS

it has a wierd code name, like all other os in development but i cant remember where i saw it, but then again i saw it on the web so for all i know its a big joke, but that would be intresting if its not.
 

Read other 13 answers
RELEVANCY SCORE 43.6

looking for replacement screen for my (HP Pavilion x360 Convertible) laptop?

Read other answers
RELEVANCY SCORE 43.2

Hi all,

I have a Lenovo Yoga 2 Pro, which uses HD Graphics 4400. I'm running Windows 10 64-bit. I noticed the drivers in the Windows Update channel are dated newer than what is on Intel's site and the version on my system is 20.19.15.4352. The version on Intel's site for the 4th Gen is 15.40.10.64.4300 and some older versions on my system are 10.18.10.4xxx.

What's the deal with these version numbers? More importantly, which ones do I use?

I'm also trying to troubleshoot some glitchy picture out of my system at 3840x2160/30Hz (4K UHD). Doesn't seem to be bad HDMI cables. Anyone else have issues?

A:Intel Drivers - Which branch?

I have the same 20.19.15.4352
I'm leaving it as is. most updates don't really add anything other than newer graphic cards and its running great

Read other 0 answers
RELEVANCY SCORE 43.2

Hi guys

I have dragon branch installed on my computer. i dont know how it got installed in the first place. i uninstalled it but now it keeps on popping up. Does anyone know what to do about it. ??

Thanks

A:How to remove dragon branch

Suggest you download and run Malwarebytes Free, not the trial version
Malwarebytes | Antivirus, Anti-Spyware, & Anti-Malware Software

Also see this for further assistance:
Remove Dragon Branch Ads (Adware Removal Help) | Tips to Remove Malware

Read other 2 answers
RELEVANCY SCORE 43.2

Hi...

I want to get some help from this forum. In my company we are using Fortigate Firewall Device that supports SSL VPN capacity. We have an Oracle Application installed on an Application Server. There is an inbuilt DHCP Server in the fortigate firewall device that supports upto 25 Users worldwide. hence when the overseas users connect to the VPN, they are automatically in a single network and are able to use the Oracle Application.

Now we are grown to more than 7 Locations overseas and average of upto 10 users in each location.
We are now confused to choose options in changing the Infrastructure of our company.

Please tell us what is the standard that is followed in Enterprises that have overseas branches.

The one it comes in my mind is IPSec VPN Connectivity. please help me in this problem.

Thank You

Regards

Syed Mohammed Sirajuddin
 

Read other answers
RELEVANCY SCORE 43.2

Hi

I want to connect my main office with 5 branch offices, all branches have windows 2000 or 2003 server, wich would be the best way (and economic) to do this...

-Via Sofware (ISA Server or Windows) or
-Via Hardware ($$$)

What would be the mains problems of doing it via software???
 

A:Connect Branch Office Via VPN

The way I do it for a chain of doctors offices is through linksys VPN routers. Yes there are better ways, but we run a practice management software on a unix server using an emulation software so we don't send and recieve a lot of data. But the linksys VPN routers also use netbios so the machine son the other end are in your network neighborhood. It just depends on what you need to do over that VPN connection. Oh, and you need a static WAN IP address from your ISP at the main location.
 

Read other 1 answers
RELEVANCY SCORE 42.8

I have one office with a 2K3 small business server, 9 nodes and getting broadband
via router with built in firewall.

Another branch office is opening soon, that will have a 8 more nodes (computer) and
again this office will have its own ADSL connection via a router.
I want to have it so, users in the new office van VPN on to the 2K3 small business server and operate as if they were sitting in the main office.

What is the best setup/good piece of kit to use for this purpose?

I take it I will need a VPN router and some VPN client software on the PCs?

Can anyone recommend me some products?
Thanks for any help and assistance.

PS:- I am quite new to VPN, but know about OWA and OWW
EN4
 

A:VPN Link between Main and Branch Office > HELP

Read other 8 answers
RELEVANCY SCORE 42.8

First thing, I know next to nothing about computers.
We have a problem with our monitor switching off after start-up. The only way we can turn on the computer is by disabling the video card (Radeon x1300 pro).

Last thing that we did before the computer stopped working was to load suggested Windows Updates.
"Windows Malicious Software Removal Tool - August 2009 (KB890830)
Update for Windows Mail Junk E-mail Filter [August 2009] (KB905866)
Security Update for Windows Vista (KB973540)
Update for Microsoft Office Outlook 2007 Junk Email Filter (KB972691)
Security Update for Windows Vista (KB973507, KB971657, KB971557, KB956744)"

We have tried updating the Radeon Video card which is now updated.
We tried re-installing the Viewsonic monitor wizard cd and it said that we had to manually install a component (display optimization files)for Vista but then it wouldn't complete the installation. The viewsonic file in program files is there but empty.

Now I've found that the Monitor device in Device Manager is gone so I can't try to enable or change anything to do with monitors.
Help!!

A:No monitor branch in device manager

I have no access to another monitor to see if the problem is with the monitor itself.

Just wondering if I should spend the $200 on a new monitor or getting the computer fixed by tech guys?

Read other 1 answers
RELEVANCY SCORE 42.8

Hey I am helping a family member setup a network and need help.

the setup is as follows

Store "A"
Store "B"
"Main office"

He wants to let Store A & B use the main sale software which is located in the Main Office. How can we do this, should I just setup a VPN for both stores so that they can login to the main office or would I need a back-end server. Thanks
 

A:Setting up branch office need professional ITs

And they are in the same building or contiguous?

I would to with the VPN... unless there are a lot of computers, meaning more than 8
 

Read other 28 answers
RELEVANCY SCORE 42.8

Hi all

I have a branch office that uses a low grade home router vpn link to connect to our main office this causes very slow response time when users are connecting to mapped drives.

Im thinking of going the rodc route further down the road when we go to server 2008 to improve log on times, but a rodc to my understanding does not have anything to do with the mapped drives as its not a full copy of the main office DC.

For now id like to speed up the access times to the mapped drives for the branch office users, Im musing over having them stored locally on a pc hooked onto their network and then somehow have the changes mirrored to the main office.

Anyone got an idea?

Thanks for reading
 

A:Branch office slow link

What are the specifics of your branch office's internet connection? What is slow for the users with mapped drives? Is it mounting the network share and/or the actual file transfers? What router are we talking about?

I hope you're aware that many low grade VPN routers suffer drastic performance issues when they have to do any type of encrypted traffic. You can have a VPN router perform at say around 20 to 30 Mbps of routed throughput but only do about 1 to 2 Mbps when moving data across a VPN tunnel. Also, you may have to manually adjust your MTU settings on both ends of the VPN tunnel to account for fragmentation and overhead of the VPN tunnel.

Depending on the speed of your remote branch Internet connection, it may be worth the expense to upgrade the router to see if this helps. It'll be cheaper than the other alternative which is to implement a WAN acceleration product.
 

Read other 1 answers
RELEVANCY SCORE 42.8

Hey guys

Our company has a few branches located in the Midwest. One of the branches has a bad connection through the local ISP and they seem to lose it a lot.

They were considering getting a cable back up connection because right now they use a telephone based DSL.

I was wondering what kind of equipment do I need to make a VPN tunnel, that way I dont need to VPN each individual computer. If someone is a PRO in VPN please do let me know what is all required ie router, switch etc to have like a VPN box to avoid VPNing individual computers and the VPN will run over the cable internet backup.
 

A:Solved: VPN Equipment for Branch Loaction

Read other 8 answers
RELEVANCY SCORE 42.8

I have been trying to confirm whether Win10 support BOPD printing in the same way as Win8.1 did and described here;

https://technet.microsoft.com/en-us/.../jj134156.aspx

All the references I can find talk about win8 and 8.1 and none mention Win10.

If Win10 doesn't support this does anyone know of a utility that can replicate this feature? I have lots of small offices on thin WANs that will need to print and I would like to get rid of local print servers when we move to Office 365.

TIA

Read other answers
RELEVANCY SCORE 42.8

Firefox 3.5 was updated to preview status yesterday (version 3.5b99) ahead of the planned release of the release candidate.

release notes (Mozilla Firefox 3.5 Preview) are rather bare atm but likely to be updated.

Download: ftp.osuosl.org :: Oregon State University Open Source Lab

A:Firefox 3.5 branch updated June 8th.

I'm running 3.5 Beta 4 and it's been solid.

Read other 4 answers
RELEVANCY SCORE 42.8

Hello all, and thanks in advance for any help you can provide.

Seems like a simple enough question, but not one I'm easily finding an answer to - either here or in Google. If I'm the 4,376,124th user to ask this question, then please be done with me and point me at the right link. I'd appreciate it.

I'm doing a clean install of Windows 7 and, at some point, plan to branch off from Administrator and create a Standard User account which I will use thereafter. Many people seem to believe this is the safest way to run - though in the past I've always just done the simple thing and run as Admin all the time. If you think this is a bad idea, point me to a link or tell me why. I'd really appreciate it.

Otherwise, my question is this: When do I create and make the switch over to the new Standard (non-Admin) account? Right after I've install W7 and all the drivers and all the updates, OR later after I've installed Office, Photoshop, and all my various utilities? Not having done this before, it's unclear to me whether everything I install with just the Admin account will be visible with the Standard User account. It'd be nice to make the switch AFTER I've installed essentially everything I plan to use so that all the software would be accessible to both Admin and Standard user. Does that make sense?

You'd think Microsoft would have a simple discussion about this on their website since they really push not running all the time as admin. Perhaps I'm just not finding it, though I thin... Read more

A:On a new install, When do I branch off to Standard User?

The standard user account will constantly be badgering you for the admin password to install apps and do various things.

I would at least suggest creating a second user account with admin privileges, this way if there is a problem, you can always return to the clean main admin account to troubleshoot and attempt resolution.

If you are the only person using the machine and plan on installing an antivirus application I really don't see the harm in using a user account with admin privs, I would not use the primary admin account though.

Read other 1 answers
RELEVANCY SCORE 42.8

I have run AVG, Kaspersky, Bitdefender, Adaware, Malwarebytes, Hitman Pro, Ccleaner and Cloud System Booster. A few of these found files in C:\Users\Derrick\AppData\Local\Google\Chrome\User Data\Default\Local Storage called https_dragonbranch-a.akamaihd.net_0.localstorage-journal and https_dragonbranch-a.akamaihd.net_0.localstorage. Both files have been deleted but they just came back. It came with a 'free' facebook video downloader a few days ago.
 
Scan result of Farbar Recovery Scan Tool (FRST) (x64) Version: 27-05-2015 01
Ran by Derrick (administrator) on DERRICK-HP on 28-05-2015 13:13:53
Running from C:\Users\Derrick\Downloads
Loaded Profiles: Derrick (Available Profiles: Derrick)
Platform: Windows 7 Home Premium Service Pack 1 (X64) OS Language: English (United States)
Internet Explorer Version 11 (Default browser: Chrome)
Boot Mode: Normal
Tutorial for Farbar Recovery Scan Tool: http://www.geekstogo.com/forum/topic/335081-frst-tutorial-how-to-use-farbar-recovery-scan-tool/
 
==================== Processes (Whitelisted) =================
 
(If an entry is included in the fixlist, the process will be closed. The file will not be moved.)
 
(AMD) C:\Windows\System32\atiesrxx.exe
(IDT, Inc.) C:\Program Files\IDT\WDM\stacsv64.exe
(AMD) C:\Windows\System32\atieclxx.exe
(Hewlett-Packard Company) C:\Windows\System32\hpservice.exe
(Microsoft Corporation) C:\Windows\System32\wlanext.exe
(Adobe Systems Incorporated) C:\Program Files (x86)\Adobe\E... Read more

A:Unable to Remove Dragon Branch Ads

I should also mention that it's not in my add/remove programs list or chrome extensions. Tried all the 'guides' I could find, none worked. They all seem to recommend Spyhunter 4, which is suspicious to me.

Read other 10 answers
RELEVANCY SCORE 42.8

(I hope to be in right section, this time ^^)

* Fast ring = Insider with latest updates.
* Slow ring = Insider newer than CB.
* Current Branch (CB) = Standard win10 updates. By default on 1703 (Creator Update)
* Current Branch for Business (CBB) = By default on 1607 (Anniversary Update)
* Long-Term Servicing Branch (LTSB) = 1607 or 1507 (Anniversary or RTM)
 

Read other answers
RELEVANCY SCORE 42.8

It has been confirmed by Gabe that the rs1_branch is definitely the Redstone update, however this is only available to a small portion of people at the moment. I must be the luckiest person among the few to receive this update.



Well what would I expect I have been a loyal Microsoft customer for years now

I am no longer on th2 as of 29/11/2015, but still on 10586

A:Confirmed: Windows Branch Set to rs1_branch.

So if I press the Check for Updates now probably a 50/50 chance it will pop up?

Read other 10 answers
RELEVANCY SCORE 42

  
Quote: Originally Posted by ignatzatsonic


You ought to start a thread in the Sound forum on this site and hope to get a response from "Fireberd". He has a recording studio and should be able to straighten you out on what your software can utilize.



Original thread: New Build, Nerd Crisis

Premise of this thread: ignatzatsonic brought up the i7 6700K and said it may be better for a workstation than the i7 5820K, referred me here for more specialized help.

So what do you all think? For an audio production workstation, would the i7 5820K be a good fit? Would Avid Pro Tools be able to utilize all 6 cores? If not, the 6700K may be a better fit when it comes out. But I would definitely like some input from people who know the software well may be able to tell me how it interacts with the CPU and whether I should go the quad core route or the 6-core route.

The 6700K does score higher on the PCMark, which is good for the creative side of things. But I want to know if it'll really be better in the long run. Of course, this depends on price as well (dollars per performance vs dollars per longevity).

Peace.

A:Planning an Audio Production Build (branch)

I have a Sonar (Platinum) studio.

My recommendation when someone asks me about computers is to buy "overkill" or as much as your wallet can stand. This holds true for a DAW workstation or any PC. Thus if it were me and $$ is no object I would go with the 6700.

A good place to discuss recording hardware is the www.gearslutz.com forum.

Read other 2 answers
RELEVANCY SCORE 42

Hi,
The backstory is... I clicked on a close pop-up X on B&H Photo's website and Chrome was quickly covered in ads. I had Kaspersky Internet Security 2015 on my pc but it didn't detect anything before then. I tried system restore to the day before but it didn't solve the issue. After upgrading to KIS 2016 it found Dragon Branch and treated it. After a reboot it was back.

So I went into safe mode, disconnected from the internet and uninstalled it (it looked like it was installed with another program back in April), reset my browsers to their defaults, deleted temp internet files and emptied the recycling bin. I thought it was gone for a while, but then I noticed that files were missing from at least one of my internal hard drives. The files would be gone in a folder, but sub-folders remained (but were empty). For other files, I could see them but they won't open. While others were unaffected.

I saw on one of the forum pages to rebuild the search index. I started that but after 12 hrs, it was still less than 1/3 the way through (I have a lot of photo files). So I paused that and ran Malwarebytes - it found DragonBranch.A, OpenCandy and AceWebExtension.A. It treated them and after a reboot, rerunning Malwarebytes didn't find anything.

I then ran sfc /scannow - it found corrupt files but couldn't repair them all. So I ran it two more times (the post suggested that it may take 3 or more runs). At this point, I went to see if the files were back, but the hard drive ... Read more

A:1st files gone, now the drive - cleared Dragon Branch & ran sfc

Hi all,
Looks like they were two separate events happening at the same time. I starting going down that line of thought thinking the hard drive simply failed. But on some reboots I get an error message that no keyboard is found, even with a usb keyboard. I read in a different post that that is a sign that the motherboard is failing. When I plug the usb keyboard into a usb slot on a pci card, there is no error.
I had tried reboots before and it made no difference with the current issue. Then, when I thought I was taking out the defective drive just now, I took out the boot drive instead. A reboot quickly pointed that out. When I put it back in, the missing drive was back!
So, I'm now thinking its a motherboard issue. I'm copying the files across to another drive, as I type, in case it is the drive and I got a lucky window of access. Its probably time to build a new PC.
Thanks

Read other 1 answers
RELEVANCY SCORE 42

Hi All

Using Windows XP Home and having installed SP2 a few weeks ago, this problem has appeared during the last few days : the branch indicators on the Favorites menu in IE disappear.

MS Help and Support suggests this may happen when using a colour scheme that uses extra large fonts. But I don't -- I use the Windows Classic Scehme with normal fonts. Have also tried it out with the Windows Standard Scheme without any luck.

The branch indicators just appear and disappear.

Any help appreciated.
 

Read other answers
RELEVANCY SCORE 42

I am running Win7/Pro x64.

I recently managed to unwittingly move a large branch (multiple levels of branching and many files) into my "My Documents" folder. I would like to undo what I did, but I have no idea how I did it. My guess is that I made a massive misuse of drag-and-drop

Said another way, I had a directory (very large, multi-branched folder) called "MyImageFiles" at the same level on my data drive as "My Documents." Now it is buried one level down in "My Documents."

What is the simplest way to undo this?

Thanks

baumgrenze

Read other answers
RELEVANCY SCORE 42

My son has a business with about a dozen Windows 10 workstations. So far, he has done well with a common home-type router and a sixteen-port switch. He blocks sites in the router's blocked list; but, he has discovered his Netgear router has no provision for blocking https sites.

Time for a new router and he has asked my help in selecting one.

I Googled and found there are several kinds of routers and I have no idea of their features and which type is best for his network. Of the Branch, Edge and Core Routers, which one is the common home-type? If none are, what should I look for in a home-type router for his business?
 

Read other answers
RELEVANCY SCORE 41.6

I went to customize the start menu and checked the "Show as a menu" option under Computer. So now when I go to start menu> Computer, a menu pops up showing my drives, etc. My question is how can I make it branch out all of my folders and not only My Computer? Thank you

A:How to make Windows Explorer branch out in Start menu?

Have a look at ANN: Classic Shell 2.9.3 is out - Now with Search!
Jerry

Read other 2 answers
RELEVANCY SCORE 41.6

why is this not there and how do i get it back?

A:there is no USBIO Controlled Devices branch in device manager

no one??

Read other 1 answers
RELEVANCY SCORE 41.6

My son has a NDS Action replay and while trying to get it to work he removed the USBIO-Controlled Devices branch where the driver was located. How do I get USBIO-Controlled Devices branch back in device manager???

A:No USBIO-Controlled Devices branch in device manager

Remove the USB hardware. Restart the computer, plug the USB device back in. You will get the new hardware found wizard and it will ask for the CD to install the driver.

Read other 4 answers
RELEVANCY SCORE 41.6

Hi, I'm new here. I've posted at a few other sites, but both were too technical or couldn't see the forest for the trees. Not bad sites, just not easy for me to understand and execute the steps necessary to keep my computer clean. First of all Hallelujah for the file database and other similar sections here. wish I had found it a long time ago. I intend to use them extensively. BUT, first things first. I have an HP Pavilion p6610f PC desktop computer, with windows 7 Home Premium, AMD Athlon II 635 quad-core processor, 4GB DDR3 sys memory, 750GB HD, Wireless LAN 802.11b/g/n, ATI Radeon HD 4200 integrated graphics, SuperMulti DVD Burner with lightscribe, 15-in-1 card reader, HP MediaSmart Software Suite, and started with Norton internet Security 2011 but subscribed for Norton 360. I also have an iPad2 and the apple assundries that go with it for the pc also. For periphreals I have an HP Officejet 5610v all-in-one, an HP Officejet Pro 8500A Plus Network Printer, a Wacom Pen Tablet, and a set of stereo speakers. We have ATT UVerse, which has everything tied in together. That is the home phone, the tv, the internet and the ps2 and 3, and vcrs. There was a home network set up for me and my husband which has the same computer of his own. I have it set so the only thing that is shared in the network is my music.I have been having trouble with the speed of my computer so I cleaned up the start-up section, cleared out the temp files. trash, unused and unecessary programs, a... Read more

A:Double Files, double folders, now iByte desktop icon

I'm back and I found it is iBrte desktop icon. I looked at my Norton Security logs and I don't want to list everything in this comment box. but wwhere would I upload it. I don't want to do this incorrectly. It appears that there was an attack of sorts( according to Norton 360) and it had my local ip address. It looks like there is at least 1 program on my computer or external HD that I never heard of that was responsible. I have Nerds to go pretty close by should I have them scour my machine? I have all the info that Norton shows, incluing the destination ip.

Read other 1 answers
RELEVANCY SCORE 41.2

Hi all, I'm sure my specific issue has been covered, but this is my problem:

I restarted my computer due to running slowly, when it was starting back up, it prompted me to either "Run Startup Repair - recommended" or "Start Windows Normally." When opting the latter, the screen would go black, then go back to the same prompt. When selecting the startup repair, the screen goes to a blue screen with squiggly white lines with a hummingbird and a branch on it (wtf?!) and stays there for a long, long time. Is this repairing? How long do I wait? Is there anything I can do?

I've also tried restarting and trying F8 to get to Last Good Configuration, but that doesn't work either Please help!
TIA!

A:blue screen with squiggly white lines with a hummingbird and a branch

  
Quote: Originally Posted by GPerry79


Hi all, I'm sure my specific issue has been covered, but this is my problem:

I restarted my computer due to running slowly, when it was starting back up, it prompted me to either "Run Startup Repair - recommended" or "Start Windows Normally." When opting the latter, the screen would go black, then go back to the same prompt. When selecting the startup repair, the screen goes to a blue screen with squiggly white lines with a hummingbird and a branch on it (wtf?!) and stays there for a long, long time. Is this repairing? How long do I wait? Is there anything I can do?

I've also tried restarting and trying F8 to get to Last Good Configuration, but that doesn't work either Please help!
TIA!


Blue screen is a screen for when your computer crashes but no hummingbird. You can check by going to c:\windows\minidump and seeing if there are files with the extension *.dmp. If so upload them to us.

No DMP files included in upload please try this method

We do need the DMP file as it contains the only record of the sequence of events leading up to the crash, what drivers were loaded, and what was responsible.

You may be able to get the DMP files without crashing by booting into safe mode (F8) with networking.

To enable us to assist you with your computer's BSOD symptoms, upload the contents of your "\Windows\Minidump" folder.

The procedure:





Quote:
*... Read more

Read other 2 answers
RELEVANCY SCORE 41.2

So I downloaded DaemonTools Lite for free and went for the express install (I realise now that this was a massive mistake). My computer now can't search on google without a bunch of ads (Dragon Branch), and I can't click anywhere on any webpage without being redirected to a site asking me to install malware removal software.
It's taken me several attempts just to make this post, and I need this computer to get coursework done for university, I have deadlines coming up next Friday and everything takes twice as long as it should to do. Does anybody know what I should do? I don't even know what information to provide here.

A:Downloaded DaemonTools Lite and got nasty malware (Dragon Branch Ads)

Hello, and welcome This should not take long - stay with me, and we'll get it done.MiniToolbox by FarbarPlease download MiniToolBox, save it to your desktop and run it.Checkmark the following checkboxes:Flush DNSReport IE Proxy SettingsReset IE Proxy SettingsReport FF Proxy SettingsReset FF Proxy SettingsList content of HostsList IP configurationList Winsock EntriesList last 10 Event Viewer logList Installed ProgramsList DevicesList Users, Partitions and Memory size.List Minidump FilesList Restore PointsClick Go and post the result (Result.txt). A copy of Result.txt will be saved in the same directory the tool is run.===Security Check by screen317Download Security Check by screen317 from here or here.Save it to your Desktop.Double click SecurityCheck.exe and follow the onscreen instructions inside of the black box.A Notepad document should open automatically called checkup.txt. Please copy and paste the contents of the log in your next reply.Regards,Alex

Read other 1 answers
RELEVANCY SCORE 41.2

DELL Inspiron 1545 running Windows 7
Purchased Aug 2009
I know there is spyware virus, when my wife logged on to pay bills some very suspicious pop-ups appeared asking for ss #, etc.
The real problems began when I tried to load Avast. Now when I turn it on it goes to a blue screen with the white bird and green olive branch. There is nothing to click on. I tried pressing F8 while turning on and I get to the black screen where I can choose safe mode, safe mode with networking, etc..It doesn't matter what I choose, it always ends up at the same blue screen with the bird.
I can't even see the system info to see if it's 32 or 64 bit. I know I need this to see which Windows Restore disk to create. I'm thinking it's 64 but not 100% sure.
When it's been sitting awhile, a dialog box comes open. I took a pic of it:

A:Inspiron 1545- BS w/ dove/ olive branch & Startup Repair

  
Quote: Originally Posted by thomis


DELL Inspiron 1545 running Windows 7
Purchased Aug 2009
I know there is spyware virus, when my wife logged on to pay bills some very suspicious pop-ups appeared asking for ss #, etc.
The real problems began when I tried to load Avast. Now when I turn it on it goes to a blue screen with the white bird and green olive branch. There is nothing to click on. I tried pressing F8 while turning on and I get to the black screen where I can choose safe mode, safe mode with networking, etc..It doesn't matter what I choose, it always ends up at the same blue screen with the bird.
I can't even see the system info to see if it's 32 or 64 bit. I know I need this to see which Windows Restore disk to create. I'm thinking it's 64 but not 100% sure.
When it's been sitting awhile, a dialog box comes open. I took a pic of it:



Hello there!

See if you can do a System Restore from System Recovery System Restore (Follow Option 2)

Read other 9 answers
RELEVANCY SCORE 41.2

Is it possible to create a shortcut to Open Device Manager with the Ports branch expanded?

Read other answers
RELEVANCY SCORE 41.2

I want to change settings from Double Click Zoom to Double Click "highlight" and don't know how. 

Read other answers
RELEVANCY SCORE 40.8

I've learned now heavily about the Files and Settings Transfer Wizard. I've also learned about the USMT, which I've not yet used in practice, but learned the basics of in the .inf version. Studying that was how I was able to learn this deep into the Files and Settings Transfer Wizard. Basically, the two have similar, but not exactly the same configuration.

Now here I'll post the configuration for the Files and Settings Transfer Wizard. I took what I found already there, and was adding features to it. I didn't create this from scratch, and it would've been silly to, as it's a configuration file.

My issue is that whenever I'm saving settings, anytime I tell it to save something from HKEY_CURRENT_USER in the registry, it does not work. I was needing to know if anyone knows why, so I can correct it please.
 

A:Files and Settings Transfer Wizard - Not Saving HKEY_CURRENT_USER Registry Branch

I just learned of this file. It might help too. I was repeating the options I used to see if this file came out or not for saving it. It did. Hopefully it will help, and reveal the issues.
 

Read other 2 answers
RELEVANCY SCORE 40.4

I just got a new monitor, and I've always wondered what it would be like to have 2 monitors at once, seeing as my 16" has nothing wrong with it (aside from a scuff mark in the LCD when I dropped it on a screwdriver)

Anyway, I got it setup, and it's amazing! I'd say it's increased my productivity by 20% and the entertainment factor is unmeasurable. Being able to have a youtube video on the left and have my IDE open on the right is fantastic.

Now, here comes the problems.

I have the monitor on the right (the 22") set as the primary monitor because I want games to open on fullscreen on it. But, I want my desktop icons and start bar to be on the left monitor.

Well, I can get that, but new icons created will show on the right monitor, and I have to minimize everything to get to them to move them to the left monitor. Also, every time I reboot, they appear on the right monitor.

Is there a fix for this? Or is this just a down sight of having the right monitor as the primary monitor?

A:Double Monitors = Double Desktop Headache!

I have my big monitor set as main (with icons), and the taskbar on the right (not main) monitor. Never had an issue with that.
I think all new icons will default to the main monitor, so you would have to move them.

~Lordbob

Read other 6 answers
RELEVANCY SCORE 39.2

I have a Dell Optiplex GX270. When I press the power button, the power button light turns amber, I hear some fans spinning, and the CD drive spinning. However, it never gets to the boot screen (or any screen). If I open the case and press the power button, however, the power button turns green and the computer works fine (loads all the way up and functions like normal). If I close the case after it has started, it continues to run fine. I'm guessing / hoping it's not the mother board or power supply that has directly gone bad... but maybe there is a connection or something? that changes from when it's closed to when it's open. I've heard of something like... the motherboard is shorting out by touching the case... but I'm not really sure where to look for that / how. Any suggestions would be appreciated! Thanks!
 

A:Solved: Computer boots fine when case is open, but won't boot when case is closed.

Read other 15 answers
RELEVANCY SCORE 38.8

I have an Acer Aspire X1700 (Details
It's about 2 1/2 years old now. Came with Windows Vista, I upgraded it to Windows 7. Also has a newer video card than what came with it.

Anyway, The PSU fan is getting really obnoxious, it gets really loud (more or less like a lawn mower). I have taken the thing apart and have tried every suggestion given to quiet it down, which it does for a whole week or two. This is a small form factor PC, so to even take the power supply out you have to basically take out everything else just to get to it. I have looked for replacements but they are very obsolete. It's only 220W anyway, so i'd like something a little more powerful.

What I want to do is get a larger case that I can use the same hardware is (motherboard, drives, etc) and purchase a larger power supply for that case. 220W really limits the PC. The small case holds a lot of heat even with all fans cleaned and working properly. Even just taking a CD/DVD out that was in it is very hot. I want a case with better airflow than this one.
I really am not sure what kind of case to get that will meet my needs. I don't want anything really fancy. If possible I'd like to get it off newegg.com

Any suggestions would be great.
 

A:Solved: Replacing Small Form Factor Case with bigger case / new PSU

Read other 7 answers
RELEVANCY SCORE 38.8

hie guys you the best and i got this question which jus popped in my mind,
if i double every specification that has anything to do with pc perfomance will that double the overall pc perfomance ? as in
1 gig ram,1 ghz processor,256mb video ram
against
2gig ram,2 ghz processor,512mb video ram
how will perfomance differ ??
please assist
 

A:double pc specs,does perfomance double ?

There are many other contributing factors that can have an effect on performance, you would need to look at every single component of the system.

I am no expert, but I would imagine if you doubled the capability of every single part (CPU, GPU, RAM, motherboard, hard drives etc) then you would, I suspect, get twice the performance.
 

Read other 1 answers