Recent content by BaudKarma

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...