Search results for query: *

You need to set up and import specification, then use it in your macro. Import your file manually with File/Get External data etc. The Wizard will come up to a screen that says "Your data seems to be in a 'Delimited Format'.... At the bottom left is an Advanced button. Clicky. The advanced...

Nifty trick, but it doesn't work for me. However, when I click an individual blank cell and do the "Clear contents" thing, then reran the paste special, the cell coverted to 0 without a problem. I guess there's just something funky about these cells. I did a little poking around, found the...

I've got a largish spreadsheet that I imported from Access. I'm using the values in the spreadsheet to calculated averages on another worksheet. The problem is that the imported data has a large number of blank cells. I want to convert those cells to 0 when I use them to calculate the...

Excel newbie, please forgive me if this is obvious. I'm calculating a variance column as (A2-A1). Negative numbers display fine, but i'd like to display positive numbers with + in front of them, in other words like +4.02%.

I'd like to open a form with docmd.openform ...acreadonly..., then make a single field on the form editable. Is this possible?

Hold down the shift key as the database loads.

If performance really isn't an issue, maybe an old laptop is the answer. Pick up a 3-4 year old laptop and run your stuff from there. Silent, small, and you'll have a screen and keyboard right there when you need to troubleshoot or reconfigure.

I agree, let the pros handle it. Just make a little extra time to make sure you've got a good backup and maybe test to make sure you can do a restore from it. Then you might keep the backup tapes with you so you know where they are.

I agree, let the pros handle it. Just make a little extra time to make sure you've got a good backup and maybe test to make sure you can do a restore from it. Then you might keep the backup tapes with you so you know where they are.

Service has its own set of hidden problems and back-end costs, but I definitely agree you've got a better chance of making a business out of that then from budget PC building. If I was going to try to make a living from building computers, I'd try to go high end. Build custom gaming PCs with...

That'll be in "Disk Management", which is under "Computer Management" in Administrative tools. Alternatively, type "Disk Management" into Help and follow the links.

4 Make sure your fan is connected to the proper 3 pin motherboard header.

(For reference, lowest price NewEgg has for a 512 RDRAM is $209.) If you buy the RDRAM, how long do you think you'll use this system before you want to upgrade? If you're pretty happy with it otherwise and you think you'll keep it for a year or so, get the RDRAM. If you expect this system to...

Do you hear any beeps when the computer powers on? Also check the motherboard, there should be a LED on there to let you know if it's getting power or not.

I'm building a program to track promotions within our company. One of the requested functions is for the program to automagically send an EMail to payroll when HR has recieved all of the paperwork necessary to approve the promotion. I've got the code to compose and send the EMail completed. I...

Rethinking a little... there might be a setting buried somewhere in your machines BIOS to reset everything to factory defaults. What kind of computer/motherboard do you have?

If "wiping the drive clean" just entailed reformatting it, you might try deleting the primary partition on your hard drive and recreating, *then* reformatting the next time you do your Windows install. If that works you wouldn't need the bother of a drive utility.

I have my RAID array set as the only boot option. The only time I ever boot from floppy or optical is if there's a problem, and then I'm probably poking around in BIOS already. I'm not sure if removing the other boot options makes the boot time any shorter, but it can't hurt.

I wish I'd come into this thread earlier, I might have saved you a little hair-pulling. I'm glad you got things up and running finally, though. I can collaborate what you finally learned, though... my ASUS mobo doesn't need the F6 drivers loaded unless I'm setting up a RAID configuration. If...

Franklin, after the original outage, the system was never working with the original CPU and a WRT54GS router. Every other configuration was working, just not that one. Actually, it looks to me like a pretty thorough troubleshooting process. Helen, you might try getting the latest version of...