Search results for query: *

I have an Excel worksheet that has had 2 pictures inserted on it. I need to be able to delete one of the pictures when I need to. Since this would be done repeatedly, I was trying to set up a macro or some kind of hot key combination that would do it. Since the picture is on the second page, it...

At this point I can change the page to either one if that is what it takes to make this work. Currently it is a controls toolbox. It really doesn't matter to me about rebuilding the page, as long as I can print it without the arrow being printed.

I have a worksheet that has a drop down list control on it. Is there anyway to set it to where when you print the page, it will print the data chosen from the list, but NOT print the drop down arrow?? I've never seen this done, but I really need to be able to do this. Any help would be greatly...

If anyone has any info you can point me to on this I really would appreciate it. What I need to do is look through a text file, grab every Nth word and then write those words to a new text file in order that they came in. I really need to be able to set N to what I need it to be, whether it's 5...

Thanks, I'll try it first thing in the morning when I get to that machine.

I have searched the KB and haven't found any help so, before I trash the computer, curse Bill Gates, etc., etc., I thought I'd see if anyone here has run into this problem. My printer has quit. Original error message was something like: "Spooler subsystems app encountered an error and is...

Hi Cheerio, As to the first part, I knew I was shutting it down everytime. That was one of the first things I learned about automation. :) And I was pretty sure I had the ob var set to nothing, but I did go and double check the code and yes, it is set to nothing. Good ideas, I wish one of them...

I have a Access db that I use a lot of automation on. The form queries data, opens an Excel form, saves as one of the fields data, and populates some of the cells. Then I edit other cells and print. At that point I close Excel, hit another button on the form which opens Word and does the same...

Mike....you da man!!! works like a charm!......starting to feel more like Friday already! Thanks for the help! Have a great week! Robert

ahhh...if only it was that simple! LOL....this is the error I got. Runtime error 13: Type mismatch and it highlighted the If Box1 = 400 or box1 = "400R" Then line. The field for Box 1 in the table is set to text. Why does it feel like a Monday?

This seems like it should be real simple but I can't make it work. I need the code to look at one box on the access form and put the appropriate value in another box. Box 1 is text data type. Box 2 is currency. Box 1's value may be one of several possiblities, ie; 400, 400R, 314, 315, 320. My...

Sorry, I meant to post this a couple of days ago, but I got busy and forgot! What happen was that the modem took a hit and it fried the motherboard. Or at least it fried the bios, I guess. That's why it wouldn't boot or count memory or anything. So as it turns out, the fact that he was using a...

Well, the saga deepens....it turns out that he did hit the windows key and something. What's wierd is that mom can't even get the machine to boot off of a floppy! She said she thought she heard the memory count but can't tell if the HD is running or not...Could some key combination actually blow...

He was not in a program at all. He was at the desktop. That much we are sure of, the only thing I wonder about is if he hit some other key along with those two. He is pretty careful about what keys he hits. Mom writes down instructions for him to work in his programs and stuff. This time he just...

Does anyone know what happens in win98 if you hit the alt & B key at the desktop? My dad did that and now the screen just comes up blank. I'm going over there tomorrow and see what I can do, but I've never heard of this key combination and don't know what it would do. Any help or pointers would...

Thanks euskadi, I do believe that will work! I appreciate the help!

Actually, "write a little routine" is just what I would like to do, just don't quite know how. I can write code that will manipulate data, populate Excel and Word documents, send email, and some other stuff, but I've never tried to write a text file from code. If you know of somewhere...

I have a command button that builds a text file based on a table. Like this: DoCmd.TransferText acExportDelim, "MySpecs", "Mytable", "F:\Mytable.txt", True That works fine, my problem is that the program that I have using this file for import into has to have a...

I have a command button that opens a select query. What I need is to have it do the whole Tools/Analyze with Excel thing. Is there any way to have that same button open the query, convert it to excel and save it? If it would also close excel and the query that would be cool too. Thanks for any...

Well, that would just be too simple!! LOL...It's going to be a few days before I'm ready to set it up, but I'll find out then. It seems like that would also work if the other HDD was Win98 also..or whatever..mmm... Thanks for the help!