I have a spreadsheet with various worksheets in it. From these worksheets, I want to create another, based on the data in the previous worksheets. I've tried to do this using MS Query and SQL to grab the data and this works fine, except one of the columns I wish to display is a percentage...
Hi,
I have a W7 64 bit laptop running IE9. For some reason, it takes an absolute age to open and do anything with, and 'interet options', 'manage add-ons' etc. are greyed out. I've run malwarebytes which found nothing.
In safe mode, everything is fine. This is a personal home laptop,so anybody...
When you know a little bit about computers, everybody thinks you know it all, so thank heavens for tek-tips!
A friend has asked me to look at his daughter's laptop which has suddenly stopped accessing the net. It's a Dell machine running Vista. Here's the symptoms and what I've looked at and...
Hi all,
Not sure if this is the correct forum for this. If it's not, please direct me to the correct one.
A friend's daughter's laptop, running windows 7, has recently stopped accessing the internet and he has brought it round to me to see if I can find anything wrong with it. At both my house...
I have an old Dell windows XP machine that has an integrated graphics card that I am attempting to upgrade. The machine has PCI rather than PCI-e slots and so I have bought an ATI Radeon 9250 PCI card off amazon which came with an installation disk. Before installing the card, I attempted to...
Hi
I've just recently replaced my wireless mouse and keyboard as I'd worn to many of the letters off the old one!
The new one works fine, but does not hold the install between power downs. This means that when I turn the machine on each day, the wireless dongle is unrecognised and therefore the...
Hi,
Many years ago somebody created an Outlook signature for me that vertically scrolled my name, telephone etc. to the bottom of my emails. I'm not an HTML coder, but it was a little HTML file that used the MARQUEE tag that I could understand what was going on.
I've discovered though that...
Hi,
We have a number of CICS DB2 programs that taking an excessive elapsed time. They are supposed to be quite high burners, but even though I have tuned them as much as possible using explain and the cost tables, they still take a long time.
Examination of the log shows that the actual CPU...
Hi,
I have a windows XP machine that needs to be re-installed to factory settings wiping all the data. I've taken the hard drive out, placed it in a USB caddy and have copied the majority of the documents, music etc. onto my windows 7 machine. Some files wouldn't copy giving me an error 'you...
Hi,
I have a monitor with DVI and VGA input which both my wife and I use for a desktop and lapt (not at the same time). We both connect via a VGA switching box and this works fine for our computing purposes. Recently I decided to upgrade my graphics card in the desktop to an nVidia GeForce 210...
Hi all,
I have a dual boot Windows 7/Vista system with two separate hard drives in the machine, one for each operating system.
I originally used to use the Vista disk more, and that's where the majority of the data lives, but I now tend to boot into the Windows 7 drive more often than not...
Hi,
Not sure if this is the correct forum, but I'm lost as to guess which one is. Let me describe my problem and then if nobody can help at least somebody might be able to point me to the correct place.
I have a Dell Studio PC which came with a 500Gb hard drive and Windows Vista about 18 months...
Hi all,
I have a Dell PC running PX Home that crashed and gave an error message on reboot that said it could not find c:\system (or something similar) and that my best bet was to repair from the xp disk.
This I did (SP1) and the machine is now up and running, of a fashion. The problem is now...
I have a spreedsheet that has data that I need to export to the mainframe. It consists of 3 columns of differing sizes, that I need to save as a fixed size. A subset of the data is:
1330-20-7 Xylenes (incl. META PARA-XYLENE) 215-535-7
71-43-2 Benzene...
Hi all,
I've got quite a bit of data in some Excel spreadsheets that I want to export to a mainframe db2 system. I can transfer flat files backwards and forward to the mainframe and then either load via a spufi or a bespoke program, but I wonder if anybdoy has any better ideas.
I can get data...
Hi all,
I have an old Dell Dimension that keeps blue screening. I called someone in from a local computer shop and he installed some bit of driver finding software which solved the issue for a couple of weeks, but then it returned. Rather than call him back I decided to hive off the data and...
Hi all,
I have put together a World Cup spreadsheet which I can't get to work 100% correctly and I'm struggling to sort it out.
I have two columns which are the actual result of the match, plus two columns which are the users guess. What I want to do is compare the result against prediction and...
Hi all,
I have a world cup score prediction spreadsheet with a complex formula in one cell. This formula compares the actual score of a game in two 'master cells' with the score predicted by the user in two other cells and, depending on whether they've guessed the right score, awards points...
Hi,
In my wife's office, they sometimes have to send an email outside of their company, to around 100 recipients, all of whom know nothing about each other. They use what I guess is a standard method of hiding all the email addresses, by Bcc-ing everybody and sending it to themselves.
Recently...
Hi,
I have a Vista machine that has recently started to exhibit poor performance. In order to rectify this, I have increased the memory to 3Gb, used msconfig to remove any unnecessary startup programs, and made sure that all windows updates are present. I've also run malwarebytes, a full virus...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.