This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 2201. |
Solve : I want to control which programs access the internet.? |
|
Answer» hi, If I'm USING the internet, there are occasions when my download slows down and upon checking my Zonealarm panel I see that a program such as Java is using my download. I don't mind if Java checks for updates, but if I am doing something I want to be able to throttle whatever Java is doing until I finish what I am doing. After all I bought the computer and the broadband, so I want control. Can I get SOFTWARE to do this?Java should not be RUNNING unles you ask it to. You can stop this in services in msconfig, Java should not be running unles you ask it to. You can stop this in services in msconfig,Ignore this guyYou can always go to the "Program Access" window to Tick or Untick the programs against the 'Net Access'! I don think there is any better alternative to Zonealarm when it comes to having a better control of Programs! Moreover, this is what you can try>>> Control Panel>>Locate the JAVA Icon>>Go to Advanced Tab>>Uncheck the last TWO options. Hence, No more Tray Icons & no more Bandwidth restriction! |
|
| 2202. |
Solve : HELP!!! Something just happened - something called System Tools tried to invade? |
|
Answer» I was looking at the things you were TELLING me about the PPV 2007 and 2003 when all of a sudden this THING popped up on my screen and said it was System Tools, all these viruses and Trojans had invaded my computer, scan now, pay $29.95 ONE time charge and my desktop is black, it wouldn't let me do anything but turn it off. I restarted in safe mode, it was still there, every time I tried to do anything, it wouldn't allow Windows to open, frantically trying to get RID of it, I have F-Secure (don't like it but my computer dude insists it's the best-he's going to hear from me!) and now am running a virus scan because all of a sudden that "Security Tool" has vanished except for the fact that my desktop is black, no ICONS whatsoever. I'm afraid to cut off the computer for fear it will come back. This has never happened before. I don't know what to do. All these windows kept popping up on my screen telling me I was running my computer unprotected, did I want to continue, when I said yes, it still kept popping windows up at me asking me. Am I being attacked? It had icons on my taskbar at the bottom and now all of a sudden they are gone, however, desktop and icons are not there. |
|
| 2203. |
Solve : I'm trouble again - got a question about pps. files? |
|
Answer» I get emails with attachments that are pps. I click to open and it says I need to set a file association. Before Vista reinstall, I had to download Microsoft Power Point Viewer 7. I did that and then when I get an email with pps., I saved it to my desktop, double clicked it and Power Point Viewer immediately opened it up. So I downloaded it again but this time when I double click where I sent it to desktop, it says the same thing, I need to set a file association. What am I doing wrong? Did you try going to your "Control panel", and then to "Add and Remove Programs" and uninstall PPV 2003 from there? That's a good idea! Anyway, when you get more familiar with how things work, then it'll be easier. I'd try to learn how to get your computer working like you want it; after all, your using it Vista doesn't have add or remove programs. It just has Add Hardware. If it has an add or remove programs, I can't find it. I just found this - you can go to Control Panel, and click Programs and Features, and you can uninstall there. Strangely, Power Point Viewer 2003 is not on there but Power Point Viewer 2007 is. And the 2003 is on my Start Menu. ? If you have upgraded a software, the newer one will be listed in the uninstall panel. Programs and Features is the Add/Remove program in Vista. I mean, PPV 2007 you installed without uninstalling PPV 2003 first correct? PPV 2007 is therefore an UPGRADE, and probably has upgraded from 2003 to the newer version. Hence, you don't see it in the uninstall panel. I would think if that's what you did, you could uninstall PPV 2007 (probably will revert BACK to PPV 2003, else if not, you have no PPV on your computer and can reinstall PPV 2007 if that's what you want) I would install latest version because it can handle the newer file types that you might see.In the meantime... you can start powerpoint viewer and drag the pps file onto it to open them. |
|
| 2204. |
Solve : Network Computer -- Outlook 2003 -- Printing Error -- Multiple Messages? |
|
Answer» Okay, so at work, we have Public Folders set up on Outlook (not uncommon). In the "Demand Folder" our IS department has set up a CUSTOM template for one of the folders (Credit Card payments). On very few computers in our office, you can go into the folder, select multiple messages in the list at the same time, and hit the print BUTTON. Naturally, the emails will print out in order individually. On MANY of the computers in our office though, if they try to print more than one email at a time, they get the error message: "one or more of the items you tried to print does not support printing and was not printed". Our IS department has no idea what this means. I'm pretty sure they don't even care... |
|
| 2205. |
Solve : office delema? |
|
Answer» Decided we REALLY need to up-date from OFFICE 2003. Should we buy office 2007, or try OpenOffice 3.1. Decided we really need to up-date from office 2003.What brought you do that decision?Looking at various forums, it seems there is quite a bit of difference between the 03 and 07 versions. That's why I thought about upgrading. Then when I found OOo I thought..Why not and figured this was the place to get good feedback.What differences are there that you need?Looks like there are MANY more integrated things in word, and I seem to find more formulas and COLUMNS in excel.Never ever consider about OpenOffice..or you'll witness further fall in the Staff Productivity! Everyone will then have a decent time to relish a CUP of Coffee till the document loads using OO, instead remain stick to Microsoft Office 2003. One needs to have a 'Robust'* machine to run Office 2007 as optimally to that to 2003! * Pentium 4 struggles with modern day Software Applications, Core2Duo & respective chipset are the pre-requisites nowadays! Quote Never ever consider about OpenOffice..or you'll witness further fall in the Staff Productivity!Well it isn't exactly expensive.... Quote from: Saurabhdua on December 29, 2009, 04:47:16 AM Pentium 4 struggles with modern day Software Applications, Core2Duo & respective chipset are the pre-requisites nowadays! Nonsense. For MS Office? So are the rest of his assertions... |
|
| 2206. |
Solve : Doing a backup-not sure if posting in right forum? |
|
Answer» For Christmas my husband gave me a Seagate portable hard drive to backup my computer. So I PLUGGED it in, installed it, read about it, but still not sure about what I'm to do. At 10:00 p.m. tonight it is scheduled to backup my computer, my drive c, personal and public folders. Am I supposed to backup the whole computer??? He bought it because earlier this month I downloaded the new version of my antivirus program and it stuck a password page on it and I had never used a password and we couldn't get into the computer, not even in safe mode. I ended up having to take it for repair ($202.00), which he ended up having to uninstall Vista and reinstall it. I lost a lot of stuff, all my husband's music downloads, my email addresses, but he did manage to save My Documents, My Pictures, and a few other things. Can anyone help me with this, I'm somewhat computer stupid and I'd just like to know if having this start a full backup at 10:00 is the thing to do. Thanks in advance. So you are saying in a week I need to delete it and redo it?No, next time, you'll perform so called "incremental backup", which is going to be much faster and smaller. It'll back up only those files, which changed, or were added since the backup, you just did. Quote patio - Did not see anything that said Acronis True Image on anything. Did you recieve a CD with the drive ? ?No, no CD. It is Seagate: FreeAgent Go Portable Drive. The box says: FreeAgent Go Drive FreeAgent software pre-loaded on drive (Windows only) Quick start guide Compatibility: Windows XP/Vista - and I have Vista |
|
| 2207. |
Solve : Opening .nrg (Nero Burning) with other software? |
|
Answer» Hello, use PowerISO This was already suggested... |
|
| 2208. |
Solve : Obsolete software key 14919ea49a8f3b4aa3cf1058d9a64cec what is it?? |
|
Answer» A FRIEND has an obsolete key which keeps appearing in a registry scan That computer is seriously infected with rootkit(s), so you better continue right there. agreed. But, to answer the direct query, "14919ea49a8f3b4aa3cf1058d9a64cec" is a 128-bit GUID. The hijackthislog is nothing to do with me. Found it when googling "14919ea49a8f3b4aa3cf1058d9a64cec" can you explain a little mroe what that is plzHKLM\SYSTEM\CurrentControlSet\Services\sptd\Cfg\14919EA49A8F3B4AA3CF1058D9A64CEC sptd is DAEMON Tools DRIVER, so that numeric entry is part of it. No mystery here. |
|
| 2209. |
Solve : favorites is lost …? |
|
Answer» Hello |
|
| 2210. |
Solve : Audacity? |
|
Answer» I'm running Win 7 & was wondering if anyone know's if the Audacity software will work? It list's Vista, but not 7. How about the beta version? The software would only be used to TRANSFER some of my OLD cassettes to my hard drive if I can figure out how to do it.Without the site providing information EXPLICIT to Windows 7 I could only recommend that you try it. There's no reason why it shouldn't work. You can always run it in COMPATIBILITY mode. Windows 7 (32 bit) runs pretty much everything Vista & XP did.Sorry, but I should have mentioned I'm running 64 bit. It also show's to have a compatability mode.I'd guess it will still work - download a trial version. 64 bit is a little more finicky than 32 bit, but again - most standard apps should be fine. |
|
| 2211. |
Solve : getting my usb only laser printer to print? |
|
Answer» I have been using a home-brewed (in basic) data MANAGEMENT PROGRAM for about 20 years, on a series of computers running DOS 3.1 and subsequent. I now have a (RELATIVELY) new Dell Dimension3000 running XP and a hp2600n color laserjet. The computer has a serial port (along with the usb) but the printer does not. |
|
| 2212. |
Solve : wav injector? |
|
Answer» hiei every1 do you seriously think we are going to run an an unknown .exe file? VMWare is very helpful in circumstances like this. I will examine this mystery file.used it in my XP VM. doesn't SEEM to do ANYTHING. Whatever it is, it's very badly written, as it refuses to accept ANY filename as the output file; it seems to PACKAGE them up into- something. Not sure what. premiminary google searches make me think this is for packaging sound to be used by games.It is for educational purposes only increasing knowledge is not a bad thing i was just modding a game it thought this tool cud help me (Not Sure) on xentax some user was defining this tool a data reinjector used by TECHNIC (Warez Group) your boss wants you to screw around with game music files?he is Not really my boss but my younger bro i call him my boss Quote from: the_mad_joker on December 26, 2009, 02:24:31 AM he is Not really my boss but my younger bro yeah.... that makes sense. its joking but wat can i do der is no 1 except ma bro in dis world lost Parents in Car accident hence i take care of ma lil bro, and fulfil all his need so can u help Quote from: the_mad_joker on December 26, 2009, 01:25:06 AM on xentax some user was defining this tool a data reinjector used by TECHNIC (Warez Group) I think you just terminated this thread no no i waz just GIVING info abt the thread so can u help me Quote from: the_mad_joker on December 26, 2009, 02:36:05 AM no no We don't do warez stuff here. i said its 4 educational purposes its not a warez stuff i wanna us it for modding crysis , now dont say its illegal |
|
| 2213. |
Solve : Doubt on CCleaner's Fidelity?!? |
|
Answer» Hello There! No..that's not correct! Thats not correct. In November 2008, M$ announced that Windows Live OneCare would be discontinued in June 2009 and will instead be offering Microsoft Security Essentials. The subscription will only continue until the subscription expiresTrust me...you've been abandoned. Why anyone would insist on running a PROTECTION APP that has been dis-continued is something i just can't comprehend. |
|
| 2214. |
Solve : Have I been scamed?? |
|
Answer» I'm having trouble which may relate to my hard drive. I went to Western Digital and downloaded a DIAGNOSTIC program which must be activated by booting from my CD drive. I thought Vista's "burn" function which appears across the top of the explorer window would do the trick, but it doesn't. The disk will not boot. I noticed that they recommend using Nero or Roxio. |
|
| 2215. |
Solve : Help cannot put my Christmas PowerPoint slide show on youtube? |
|
Answer» I'm creating a Christmas PowerPoint slide SHOW of my family, can someone tell me where I can download free Christmas templates for my presentation? And I want to put this PowerPoint slide show on Youtube to share with all my relatives and friends. I tried to upload a .PPT file to Youtube but failed, any idea? thanksHi, you can download free Christmas PowerPoint templates from these sites: |
|
| 2216. |
Solve : Scanning lots of photos? |
|
Answer» Hey! Do you all know any free software that would allow me to scan lots of pictures? I have a scanner already, but I want to digitize four or more 4x6's on the flatbed at a TIME. I NEED software that will automatically separate them for me (I have lots of photos). I'm good enough with GIMP...but I don't want to manually separate thousands of photos. Quote from: aniketkar94 on December 20, 2009, 05:20:11 PM I need software that will automatically separate them for me ...I don't know of any such software. I think this is going to take some MANUAL effort. This seems to be the best option: How to Scan Photos to a Computer Efficiently; however, I would agree the only efficiency the procedure offers is not having to scan one photo at a time.Try Picasa, free photo MANAGE software, though I am a little aware of its too powerful SCANNING which would compromise my privacy. |
|
| 2217. |
Solve : Driver scanner and updater? |
|
Answer» Does anyone know of a good driver scanner and one that will update the drivers. Thank OjasDrivers should be uploaded INDIVIDUALLY by the user. THIRD party "driver scanners" are at best USELESS and at worst dangerous. Visit the website of the hw manufacturer for the device you want to update, download the latest driver, and install it manually. More Important - do not update ANY driver unless there is a specific need and reason to do so - "NEWER" is not a good reason. If your current driver provides the needed functionality, do not update it.I stand my point with #2, because I USED to have painful experience with driver scanner and updater. The allegedly powerful driver scanner almost killed my system with wrong drivers. I should have not be tempted by the misleading driver update news issued by the driver scanner. So make your update through official approach. |
|
| 2218. |
Solve : how do i know that my windows 7 is orginal or what?? |
|
Answer» lately i bought a new windows (7) ,so how do i know that my windows 7 is original or what? Then why would you question its legitimacy?That should be obvious! Other countries are behind in copyright enforcement. Well, IMO. True,He said he purchased it directly from Microsoft.And you trust them ? ? Implicitly Quote from: Allan on December 19, 2009, 12:37:32 PM Implicitly OK...I'll BITE...www.howtotell.comOh ye of little faithokay i will blindly trust Microsoft in our country ... and i will update it if it WORKS then its original but thank U all for ur help yes in our countries everything isn't original like any one need an antiviruse go and download it free with working serials but hey that is stealing isn't it or what ? |
|
| 2219. |
Solve : Justify alignment? |
|
Answer» there are spaces that are being ADDED in the middle of word when printing documents. when using Justify alignmen. any ideas ?Hi, and welcome to the forum. Are you referring to Microsoft Word in your question? If so, what version? yes office 2003 Could be corrupted or unsuitable printer driver. Check that you are using the latest version, correct, manufacturers printer driver, especially that it is not an MS generic driver. This problem is known to happen with HP printers where the printer driver is one that came with Windows. there are spaces that are being added in the middle of word when printing documents. when using Justify alignmen. any ideas ?I see nothing unusual here. What you see is what Justify alignment is supposed to do. If you don't what your print output to look that way, then don't use Justify alignment. Am I missing the point here? Quote from: soybean Am I missing the point here? It is more usual to add the spaces between the words. Spa ces in the mi dd le of wo rds, as the OP me ntion ed, (and as you have quoted) looks kind of weird. OK, I KINDA overlooked that point. But, yeah, if it's putting spaces within words, not just between words, that would be messy. It should not be doing that. Like I said, could be a driver problem i have tried a fresh driver INSTALL and no improvement but thanks anyway i have just uninstalled office and reinstalled as a work AROUND and will keep looking for answers thanks for taking TIME to answer.http://www.openoffice.org/ download the above good and free |
|
| 2220. |
Solve : Anybody know of a good music making software for windows?? |
|
Answer» Hey guys, FruityLoops?It's not free, usually runs up quite a lot. I think there are free music sequencing apps like it available, but I'm not sure if there are any free ones. (unless you count the quaint little apps that let you bang about on an on-screen piano keyboard using MIDI) It's definitely comprehensive, there's a demo on their HOMEPAGE you could try: http://flstudio.image-line.com/ And of course, there are WAVE type sound editors. Not really good for making music, but they have their uses. I used to use one called GoldWave, it used to be free, but I don't think it is anymore. I usually reach for Audacity when I need to edit waveform sound files. Quote from: BC_Programmer on December 22, 2009, 07:24:33 PM And of course, there are WAVE type sound editors. Not really good for making music, but they have their uses. I used to use one called GoldWave, it used to be free, but I don't think it is anymore. I usually reach for Audacity when I need to edit waveform sound files. Audacity will also do MP3 with the Lame-MP3 codec which I believe is also available on their website (or at least a link to it).Thanks for the reply guys. I already have audacity and i just use it for trimming music and stuff. And I think I'll try the Acid Pro one. Might give Fruity Loops a try as well. There's not really something specific that i'm looking for - just something to fool around with . Thanks again! flstudio is a pretty good program. Its worth the price Quote from: quaxo on December 22, 2009, 07:26:12 PM Audacity will also do MP3 with the Lame-MP3 codec which I believe is also available on their website (or at least a link to it). yes... but Mp3 is just a compressed format for digital waveform sound, which is kinda what I meant, Audacity can open all sorts of different formats, but they are really all just some sort of waveform, either compressed (mp3, ogg, flac,voc) or uncompressed (riff/wav/aiff) Flstudio and so forth are full fledged sequence composition programs- (not sure about the others mentioned... they probably are as well, at least to some degree.And on the more high-end scale, Adobe Soundbooth.I think he wants something with a bunch of different instruments in it and stuff. Soundbooth doesnt have that. Its an editor Quote Adobe® Soundbooth® CS4 software gives web designers, video editors, and other creative professionals the tools to create and polish audio, customize music, add sound effects, and do much more.I haven't used it, but I assumed because it said "create" that you can "create" audio.Audition. Be prepared to spend some cabbage... Quote from: kpac on December 24, 2009, 04:42:14 AM I haven't used it, but I assumed because it said "create" that you can "create" audio. Look at it this way; what they want is a "vector" audio program; that sounds like it's a "raster" audio program. One works with instruments, tempo, etc. the other works with the pure waveform. I don't know which one the adobe program is. Sounds like both, actually.Adobe makes Audition...i probably should have mentioned that. |
|
| 2221. |
Solve : VMWare workstation can not understand USB perfectly? |
|
Answer» Hello I use VMware Workstation v5.5.2. Quote 2005-09-12 - VMware updates Workstation to version 5.5 Boy that is an old version. Latest is 7.0 something! This is production environment? You have VMWare licence? You do not have access to support? You are running 4 year old release? Get 100% up to date and then see if you still have problems. May VMWare compatibilty fixes since September 2005! thanks "salmon trout" is it good idea to get new release of VMware player and run visual windows over it? it's free. Quote from: k_mohsen on December 25, 2009, 02:35:06 PM is it good idea to get new release of VMware player and run visual windows over it? Yes. |
|
| 2222. |
Solve : Icon in control panel? |
|
Answer» Hello, I am using Windows XP Home, SP3. I just installed Avira A/V and the icon in the control PANEL is a generic icon and not the Avira icon. I have tried moving it to my Sys32 FOLDER but that just makes it disappear from the control panel, it doesn't affect the operation of the program but it agitates me because it should be the Avira icon. If anyone has experienced this and knows how to correct it I would appreciate any help. Thank you. And your controlled experiment is what exactly? A secret. actually, it was a plan for a blog entry. I already have the VM sort of set up, just have to be bothered to actually perform the experiments with my XP snapshot. The idea is this: I create a setup with a Clean XP Install, and test several "registry cleaners" on it; after each one, I revert to the snapshot I took of the clean install, and try another. I also have a "loaded" system, where I uninstalled, reinstalled, deleted without uninstalling, added back new versions, deleted old versions, and basically tried to muck around the Install as much as I could to "simulate" what might happen over a longer period. Again; each time I will test the cleaner/fixer TOOL, and then revert to the snapshop I made of this "loaded" XP install. For each one, I use Process Monitor to determine exactly what the cleaner is doing; most illegitimate ones (one on my list being RegCure) will likely show that they hardly access any registry keys at all and simply report specific keys as invalid using a time delay. Additionally, I'll ensure that the programs installed work properly- in all respects- after running the cleaner.Nice... Quote from: bxgy on December 23, 2009, 05:26:35 AM After 6 installs and reinstalls and by using Wise Registry Cleaner (a great and simple program) I have fixed the problem. I am very joyful. Glad to see that you have the problem solved.. not an easy process. BC, When do you think the results of your experiment will be posted and where can we find them, I would enjoy reading what your findings were. |
|
| 2223. |
Solve : Problem printing on to CD's.? |
|
Answer» I used to have an Epson R300. Printed onto Cd's no bother and included an extensive editing programme (Epson Print CD). It's now broken so I bought a new printer. HP Photosmart Premium C309a all in one. It comes with the software Photoshop 3.5, which is absolutely terrible. It will print a PICTURE with a text. The text can only be black, in bold or ITALICS. It cannot be moved, nor manipulated. There is no choice of font. Even the picture cannot be altered in any way. In short there is no editing facility whatsoever. |
|
| 2224. |
Solve : How do I increase server timeout in Microsoft Outlook? |
|
Answer» When I send large attachments, Microsoft Outlook TIMES out and the email is not sent. I changed the server timeout to the max of 5 minutes in Tools > Accounts >Properties > Advanced > Server timeout but I need more than 5 minutes.Time and again, this point needs clarification. Is it Outlook or Outlook Express? I'm sure I know the answer, but it needs to come from you. When I send large attachments, Microsoft Outlook times out and the email is not sent. I changed the server timeout to the max of 5 minutes in Tools > Accounts >Properties > Advanced > Server timeout but I need more than 5 minutes.Your description here fits Outlook Express. Outlook does not have that menu sequence.You need to review your Terms of Service with your ISP... Most have a limit and/or throttle down large attachments... What are you sending that's 9MG ? ? Quote from: cojack on December 18, 2009, 03:57:17 PM 5 minutes is not long enough.I don't believe that setting pertains to this situation anyway. The setting relates to how long OE will TRY to connect to the server before it quits due to not having established a connection. But, once a connection is established, OE won't interrupt the connection due to a large file taking a long time to upload. Quote from: patio on December 18, 2009, 07:05:38 PM You need to review your Terms of Service with your ISP...Yes, this is this is the string for Outlook and OE has the same string. Believe me. I have the same problem with OE. I've already worked with my ISP and there are no retrictions as to the size of files to download. When I send a large attachment, it indicates it is being sent, if it is not complete at the 5 minute mark it aborts. I am still online in outlook and can send other emails of smaller content but I need to delete anything that is larger than 9 Mb from the outbox. I can send them in Webmail but I receive my email in Outlook but when downloaded, it is removed from the server and doesn't appear on my webmail. I'm forwarding emails with large attachments 9 or 10 Mb, that were sent to me by friends that are on the same ISP. I assume they are sending them using webmail or another email client that doesn't have any server timeout restrictions. Then check your other scheduled apps such as A/V programs to see what's triggering an interruption... Quote from: cojack on December 18, 2009, 08:58:01 PM Yes, this is this is the string for Outlook and OE has the same string.No, they don't. I have both and the menu STRUCTURE is not the same in the two apps. The setting exists in both but the menu route to it is different. Quote from: cojack on December 18, 2009, 08:58:01 PM I can send them in Webmail but I receive my email in Outlook but when downloaded, it is removed from the server and doesn't appear on my webmail.Incoming mail disappears from webmail once downloaded unless you have your email client (Outlook or Outlook Express) set to leave messages on the server. However, outgoing messages sent via webmail WOULD remain in the online Sent folder until you delete them via access to your webmail interface. I don't know what version of MS Outlook you are using but my version 2000 has the same string as OE. I don't want to leave copies of my emails on the server and get these files rarely, maybe once every couple months. I'm not sure if Thunderbird has any restrictions but I don't care for Thunderbird. I also us Mailwasher Pro to receive my email from the server before it gets into my PC so I get no spam and my PC runs really clean! I guess one solution would be to see if any of my emails are 9 Mb in Mailwasher before I send them to Outlook. If there are any, I can read my email in webmail and send that large attachment there. I don't like to do that because I have several email address groups set up in Outlook and I would have to add email addresses individually. |
|
| 2225. |
Solve : Is AVAST still Free?? |
|
Answer» Is AVAST still FREE? A friend of mine uses Avast. He has never registered it though. Every time it expires, he just uninstalls it and reinstalls it and gets a new license. Why UNINSTALLING and reinstalling so many times? It would be easier to get a key once a year instead of uninstalling after 60 days. I know. I've tried explaining that to him, but he just thinks it's easier this way. He's UM... not exactly what I'd call a normal person. Really. |
|
| 2226. |
Solve : Excel if/then formulas? |
|
Answer» I would like to create a spreadsheet that uses a formula that recognizes a word in one column to add avalue to another column. Can anyone help?Hang in there some one will help. It's over my head Your question is skimpy on details? Can you ELABORATE, maybe GIVE an example?Yes, |
|
| 2227. |
Solve : String formula in Excel 2003? |
|
Answer» Hi =(A6=>2)*(RETURN A NUMERICAL SATEMENT)+(... Many thks for yr interest, hope this will shed more light on what i am trying to achieve. By ENTERING a value in cell a1, for example "ATL" then i want to display in cell b1 the full name of the entered abbreviation i.e. "Atlanta" When you use the IF, Else Formulae statements this is a breeze as IF,Else statements can display/return either a numerical value/calculation or text (as in my requirement, but this string is limited to seven enclosed if,else statements My situation calls for (14) fourteen different abbreviations that need to return a full name, so I cannot use the if,else method another way of doing this allowing up to 250 scenarios is showed/explained in the below example instead of the standard if,else which will look like this =If(A1="a",1,If(A1="b",2,if(A1="c",3,if .... will only allow (7) seven ifs in one string, but this method =(A1="a")*(1)+(A1="b")*(2)+(A1="c")*(3)+(A1="d")*(4) where "="represents the same as "if" and the"*"represents "then" if true or the "+" represents "else" .... caters for a total of 250 statements in one string. However my problem is that instead of displaying/returning a numerical number ... 1,2,3,4, as shown, i need to display/return text or a name like this ... =(A1="atl")*(Atlanta)+(A1="lhr")*(Heathrow)+ ..... but the statement display/return a ... #VALUE! error because of the text"atlanta" Can i, and how, do i get this to work I believe the VLookup Function is a solution for you. Here's a reference: http://www.contextures.com/xlFunctions02.html. Many others can be found by doing a Google search on vlookup function in excel. |
|
| 2228. |
Solve : Problem with Headset/Mic please help? |
|
Answer» Within the past 24hrs, I am having a problem with my headset (a plug and play) using my computer only...it does work on another computer...When using any program to talk with friends (ie skype ventrillo) The other parties can hear everything on my computer through my headset speakers.I've checked all my sound OPTIONS and can't seem to find a resolution..please helpHave you checked your card it plugs into?? maybe loose or broke!!Hello, |
|
| 2229. |
Solve : Burn Double Layer Image Iso to Single Dvd / 2 Dvds? |
|
Answer» How do i do it? What burning app do you use ? ?I still haven't tried anything, i would like to try the latest cd burner xp, how do i do it? Simply, just burn? I am not clear what the OP wants to do. To make the disk, that an 8GB ISO is the image of, REQUIRES a dual layer disk. To store the ISO as data on a number of dvd5 disks is a different thing. So is extracting the data files from the ISO and burning them to separate disks. What kind of ISO is it? If it is a DVD9 movie you can use a program like DVDShrink. Quote from: Salmon Trout on December 06, 2009, 03:45:42 AM I am not clear what the OP wants to do. To make the disk, that an 8GB ISO is the image of, requires a dual layer disk. To store the ISO as data on a number of dvd5 disks is a different thing. So is extracting the data files from the ISO and burning them to separate disks. What kind of ISO is it? If it is a DVD9 movie you can use a program like DVDShrink. No, its an ISO of PC DVD Games.You're not going selling them I hope.Excuse me, how do I burn my downloaded pirated game onto a DVD? Oh wait, I'm not supposed to ask that here, am I? kuszmania9999, you've been here long enough. You should know better than to ask something like this. Quote from: quaxo on December 06, 2009, 09:09:35 AM Excuse me, how do I burn my downloaded pirated game onto a DVD? And all because he is too cheap to buy DL disks Quote from: Salmon Trout on December 06, 2009, 09:13:57 AM And all because he is too cheap to buy DL disks He might have an older burner which doesn't support them. Quote from: quaxo on December 06, 2009, 09:15:01 AM He might have an older burner which doesn't support them.Would have to be very old; my LG burner I got over 5 years ago supports them. Anyhow he says Quote dual layer still expensive for me Between 60 and 70 Cents apiece here.... My LG burner would always THROW a failed burn when it got to the layer break with every brand except Verbatim which are still not very cheap. Around 1 UK pound if you buy them in 10 packs, that's around $1.65 in US money. Considering I can get single layers DISCS in any supermarket for around a quarter the price, I don't really have much use for DL. The only thing i use them for is to burn my Monthly Acronis disk images...as the files have long since crept over the 4G mark...I use Paragon Disk Manager & split them to 4 G; my Windows partition is around 20 G Quote from: patio on December 06, 2009, 09:33:08 AM Between 60 and 70 Cents apiece here.... That good , at my place they sell DL around 4-5, the single layer dvd only 70sen, so you can see how much i can save. |
|
| 2230. |
Solve : Programs randomly lose/gain focus? |
|
Answer» Hello! Long time reader, first time poster here. Maybe there is hope yet. I googled once more, using different words to get different hits. This time I found one who had a similar issue on Microsoft's support site. Someone had replied with, amongst the few solutions, a tool that logs the foreground window. So I started the tool and went to play the Left 4 Dead 2 demo yet again. After about 20 minutes, BAM. Tool has logged what looks to be some kind of virus. So I'ma go ahead and post a HijackThis log soon. Hi, I have exactly the same problem. Any luck finding a solution?I think I found a solution. Haven't RESTARTED yet, but thought I'd just post it before I forgot. http://forums.avg.com/cz-en/avg-free-forum?sec=thread&act=show&id=41015#post_41015Hi, I solved it on XP: I had the same problem and some more: - Programs losing focus because of malware - Many anti-virus programs being blocked (looks like they've been uninstalled) - I was unable to successfully install software onto my PC like other virus scanners. I scoured the internet looking for solutions. I spent tedious hours, searching and trying different approaches. I found the Internet Explorer window which opens invisibly every 10 or so seconds, but after that it was back to searching for solutions. I came across a set of programs I was able to install and run on my pc. These come from Trend Micro. The program I used was RootkitBuster. The link is here: http://free.antivirus.com/rootkit-buster/. Install and run it on your PC, then take the following steps: - Click the scan now button - Click delete selected items. - Let your system restart. - Once you're back on windows wait for your virus scanner to open or open it yourself - Run a scan. In my case everything was back to normal apart from my internet connection. After restarting the PC and having windows install updates everything was sorted. This was my encounter, not sure if it works for everyone but it might be worth the try. good luck ^^ |
|
| 2231. |
Solve : need an os on my laptop? |
|
Answer» i have a LAPTOP with no working diskdrive and it cannot boot to flashdrive, how can i GET an oparating system on it is there any way apart from connecting it up to another computer and putting an IMAGE on the hard drive that way? i have a laptop with no working diskdriveYou need to get a hard drive in that laptop. Then, you can INSTALL an OS. |
|
| 2232. |
Solve : Backup discs w/Vista? |
|
Answer» As some of you may have seen my problem in the heading of Windows Mail, an antivirus program I downloaded changed some settings, specifically the password command page which left me no access to my computer as I had never put a password in. To make a long story short, Vista was uninstalled and reinstalled and in the process my husband's music got lost. There are folders that say they HOLD x AMOUNT of music, but I can never open it. Before this all happened, I had started a backup of the computer, but ran out of discs, and I NOTICED it was BACKING up music at the time. If I put one of the discs in CD/DVD player, will it put his music back? Or EXACTLY what does happen if I put the first backup disc in? Thanks in advance! |
|
| 2233. |
Solve : outlook 2003 erroe message? |
|
Answer» i cannot close OUTLOOK 2003, the message reads outlook is not responding,if you are using an exchange server email account, you can cancel pending server requests by clicking the outlook icon in the notifications area...... i have try the task MANAGER, sometimes this works, but most the time does not, icon just freezes in the task bar, with this message in, i have also try GOING into start menu,microsoft office,office tools,application recovery, choose end application, does not work, i use this outlook on my desktop to send text to my sales force, any one any ideasFirst try the Outlook Inbox Repair Utility: HTTP://support.microsoft.com/kb/272227 |
|
| 2234. |
Solve : I'm trying to make some DVD's...? |
|
Answer» My dd has a VIDEO Now player. I got some software and blank discs with it. You're supposed to be able to put cartoons onto the blank discs. If they're copyrighted, you can't (legally). but if you're making backups for just yourself to KEEP your originals safe, does that work?It won't let you and in the US it's illegal. Quote from: 2x3i5x on December 15, 2009, 10:31:42 PM but if you're making backups for just yourself to keep your originals safe, does that work? there is no legal clause that says you can have your own copy. People make that up. Quote from: Broni on December 15, 2009, 10:44:05 PM It won't let you and in the US it's illegal. I believe that it's not the copying (there is such a thing as "fair use" in US copyright law) that is illegal in the USA, but the circumvention of DVD ENCRYPTION. You're right and we're here in gray area: http://www.wired.com/threatlevel/2009/08/judge-copying-dvds-is-illegal/ At least in US. I believe, I've read somewhere, that copying DVDs for own use was declared legal, by some judge in Canada. Quote SAN FRANCISCO — A federal judge ruled here late Tuesday that it was unlawful to traffic in goods to copy DVDs.Use DVD SHRINK that will nock anything off |
|
| 2235. |
Solve : Adobe Photoshop compressed???? |
|
Answer» I was DOWNLOADING Adobe Photoshop 7 on desktop but it is showing compressed file on the desktop, that is "PHOTOSHOP_7.0.ZIP-WINrar(evaluation copy) should i unstall it and then download it again in a harddisk instead of desktop?Huh? Quote from: searcher on December 17, 2009, 11:54:32 AM I was downloading Adobe Photoshop 7 on desktop but it is showing compressed file on the desktop, that is "PHOTOSHOP_7.0.ZIP-WINrar(evaluation copy) No. You should buy it. This would appear to be your only option anyway, if the concept of a compressed file escapes you.Wait...LET me scarf this $700.00 program off the web... Then when unpacking it something goes terribly WRONG... I Know...i'll ask on a help forum...that's the TICKET... |
|
| 2236. |
Solve : Corel Paintshop Pro/DirectX downloading problem? |
|
Answer» I am having an issue with Corel Paintshop Pro and DirectX. I downloaded the Corel with no problem. I then TRIED to use Corel, and it told me I needed DirectX 9 or higher. I downloaded the latest VERSION of DirectX from the Microsoft website. I then tried to run Corel again. It told me that I did not have DirectX on my computer. I see the file associated with DirectX......not sure why it is not recognizing it. Any ideas ? Thanks !I am using Windows XP.System Requirements for Corel Paint SHOP Pro |
|
| 2237. |
Solve : Recording Flash player Videos an You Tube Videoson Xp? |
|
Answer» What can I use to record You TUBE videos and FLASH Player video? |
|
| 2238. |
Solve : Microsoft software? |
|
Answer» Can i INSTALL MICROSOFT OFFICE 2007 and Microsoft Office 2010 BETA on same computerYes. |
|
| 2239. |
Solve : How do I find what file it needs?? |
|
Answer» Often on while using the computer, I keep getting a box that says this: You might find out what program is causing the problem. An alternative method to this is to tell us what program your using when this error messagebox appears and what the title text is. I'm using all the programs that are needed for a computer to function. Windows XP is the operating system. Bellsouth which I think is now AT&t even though our email address still has bellsouth after the at symbol, is our ISP. So, the stuff that is needed for the INTERNET to run I guess you would say is running CONSTANTLY ever since we got DSL. So, like if you hit ctrl, alt, delete and bring up the Windows Task Manager, for Processes it says 49. When you say title text, do you mean what is listed in the title bar? I guess it would be Oops that is listed since it says "Oops...... I am sorry, we had trouble loading a required file. Please try again." So, since Oops is the very 1st thing, I guess that would be the title. What program shows the error message ? ?Malware?Just had this come up Adobe Flash Player 10 A script in this movie is causing Adobe Flash Player 10 to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script? I don't know what movie it is talking about. I wasn't even watching a movie. Then there are 2 options YES or No. If I hit yes, it closes the browser out. Then if I hit No, the message keeps coming up. Quote from: patio on December 11, 2009, 07:37:37 AM What program shows the error message ? ? |
|
| 2240. |
Solve : Thunderbird 3 (final) released? |
|
Answer» Thunderbird Release Notes: Got it last night Over the top install ? ?I don't use it, but as a rule with Mozilla yes.They recommend to install it in a new folder. I did just that. I'm not sure, if I like it better, than ver. 2I have to tell you....after running it for 1 day, I gave back and I went back to ver. 2. Couple of reasons: 1. No matter what I tried, it wouldn't connect to Gmail POP server. 2. Several of my add-ons wouldn't work, even with Mr. Tech Toolkit installed. 3. I didn't like expanded message header, which is not shrinkable. Actually, there is an add-on, which apparently will do it, but I discovered it after I uninstalled ver. 3.In Server settings are you using port 995 and SSL for the POP settings ? ? Because the DEFAULTS don't work here...Yep, 995...SSL ? ?Sure thing Is your Gmail working? How about add-ons?Works fine here...not many addons and only a few of my favorite Themes...Not sure, what's going on here, then. I'll wait a little and WATCH Google for TB3 problems. Not too many hits there yet. Thanks, my friend pop.gmail.com Port 995 SSL Outgoing: smtp.gmail.com Port 465.This is exactly what I had....oh well...Have you double-checked your settings on GMails end using your BROWSER ? ? ? |
|
| 2241. |
Solve : global.sw2, softwrap files? |
|
Answer» i am running xp professional / SP3 on a refurbished system. |
|
| 2242. |
Solve : Norton 2009? |
|
Answer» Hi guy's, |
|
| 2243. |
Solve : 'NULL' error when starting up MSN messenger?? |
|
Answer» hi, whenever i start up MSN messenger, i get an error box. at the top of the box it says 'pyagcore.search.searchdetection', and 'NULL below it. |
|
| 2244. |
Solve : Microsoft Access Database Viewer? |
|
Answer» Hey everyone, |
|
| 2245. |
Solve : Can't open VistaGlazz? |
|
Answer» Hi, I don't know what's going on with VistaGlazz. I'm TRYING to install a third party theme to make my taskbar look like a Windows 7 taskbar. |
|
| 2246. |
Solve : Acer Recovery CD? |
|
Answer» my acer pc this noisewhich one?i CALLED acer but they told me i have to pay for that recovery cd,,,and i was wondering so their is no way i can do this another way? Quote from: rroonnjjaa on December 10, 2009, 05:50:28 AM i called acer but they told me i have to pay for that recovery cd,,,and i was wondering so their is no way i can do this another way? No. You can borrow an XP CD of the exact same version you have installed and try a repair installation (it is perfectly legal to do this). Boot to the CD and choose the second repair OPTION, allowing XP to install on top of itself. All programs and settings will remain intact. You will have to go to MICROSOFT UPDATE and install all updates after doing the repair. NOTE: You cannot use the borrowed cd to do a new or clean install - only the repair install.i did borrowed a XP CD from my dad and installed it on my computer and now i got THINGS in order and it doesn't goes on and off...thanks Allan... but i still have to fix it and order the acer recovery cd..... |
|
| 2247. |
Solve : Software onto a memory stick? |
|
Answer» My girlfriends computer I just recently resetted to FACTORY settings and we are having problems installing her printer, we have the installation disk but when we put it in I doesn't do anything and when I run the disk an empty window appears. I have also looked online for online installation but with it being an old printer it doesn't get much attention and there is no software I could find. That is if the CD for a printer this old has a setups, might as well just have the drivers. there were setup programs on the floppy disk installs of almost all printers. CDs are a lot newer, and at the very least they all have an autorun program that deploys the driver, which can be run manually. Also, there is always the possibility of simply DOWNLOADING the latest driver, too.Thanks guys, ill try that today if my girlfriend can find the *censored* memory stick lol thanks everyone x Quote from: crog13 on December 02, 2009, 08:19:21 AM Thanks guys, ill try that today if my girlfriend can find the <censored> memory stick lol thanks everyone x Like BC was saying, you can just download the driver from the manufacturer, eliminating the need for the CD or a memory stick. If you can tell us the model of printer as well as what version of OS she's using, we can direct you where to download it from.drop the model herefemale model? |
|
| 2248. |
Solve : Any free alternative to tvu player to record live TV?? |
|
Answer» Recording LIVE TV streaming is not available with free version of tvu player. |
|
| 2249. |
Solve : IMAP Mailbox - Outlook 2003? |
|
Answer» So I've been using Outlook 2003 to access my AOL (IMAP) for years. Outlook Express does not use .PST; it stores messages in .dbx files. Quote from: rjbinney on December 01, 2009, 10:07:34 PM Computer died - I saved my "Application Data - MSFT - Outlook" directory and loaded onto new computer.Exactly how did you go about doing this?First you say Outlook 2003 then Outlook Express - which is it? And make sure you've enabled hidden & system file viewing in Windows ExplorerWhoa, officer, you got me... Body's in the trunk. Yes - all "hidden" files unhidden before search. Quote from: rjbinney on December 01, 2009, 10:07:34 PM So I've been using Outlook 2003 to access my AOL (IMAP) for years.I'm using Outlook 2003. Quote from: rjbinney on December 01, 2009, 10:07:34 PM (which is what I remember from my Outlook Express days)Which are like sands through the hourglass. (And I guess I remembered the wrong thing). I booted the machine in Linux and copied the entire "Application Data" folder from the old machine onto a disc and copied that onto my new machine. So, again: IMAP Outlook 2003 Win XP ...name and location of the archive? ThanksRead this: Where is my Outlook "PST" file located?Awesome. The LINK totally solved it. It's in "Local Settings" not "Application Data". What's weird is - it STILL doesn't show up on "Search", but if I go to that folder, it's there. Must be something tricky with IMAP - a hidden character or something? |
|
| 2250. |
Solve : is there any software to block adult games and sites?? |
|
Answer» now i'm using aobo porn filter, it's fine but i need a more functional one, because I found they are INVOLVED into A games!!! |
|