Search results

This code opens the template doc, merges the info, saves the doc with a different name, closes the template doc, and then opens the SaveAs doc. But it seems to leave a system file open from the template doc. Hopefully we can solve the original problem, but I'll start looking for alternative ways...

I've used Albert Kallal's Super Easy Word Merge with good success. I have however found that this code lease the Word System Files open. I check around this forum to see if there was a fix for this but have not been successful. Can someone help me with closing this system file? I'll get...

Thank you so much. One cannot underestimate the value of error handling. I found the problem, it was a "Type Mismatch". It's alway nice to have a second set of eyes when you need help. Problem is fixed.

Thank SOS, I changed all of my params to make sure they were different. But unfortunately it did not help it run. Any other suggestions?

Thanks for your suggestion. I tried getting rid of all of the options so see if it would run different. That is why I had the "", but it didn't seem to work. I also have a side question. If you leave an option blank, is the blank null or ""? Any other suggestions on what might be wrong...

I have the following function below. When I use: Call ChartAudit(me.PtID, me.PtName, "", "", "","", strNextVisit) The function doesn't even run. It's just skipped over. When I use: Call ChartAudit(me.PID, me.PName, me.Proc, "", "","", strNextVisit) the function does run. The only...

A big THANKS HiTech, IT WORKED! I just had to tweek it a bit but this code worked great. Thanks again. I can send with an attachement. That's a big step for me. I haven't been able to get the status and progress bars to work for vbsendmail. Any ideas?

Thanks for both of your suggestions. HiTechCoach, I tried the vbSendMail, but I'm afraid it's too far over my head to figure out. So after 2 days, I'm giving up. Got stuck on connecting to the server. Mike375 - I'm trying your code as above but am also getting stuck with an error code...

Thanks HiTech for your suggestion. I've looked at the files and scanned the .doc file, and holy smokes, it's going to be over my head. But I can follow instructions. Is there a tutorial that you know of on how to install all of this properly? I think once I get it installed, I'll be able to...

Thanks for your help. I'm starting with Window Mail and Outlook Express for now. But I'll want to add to the code eventually so that everyone is included. Not sure where to start. I went to Access FAQ but did not see anything. I'm not sure what FAQ you were referring to. There are only 4...

I've looked all over the place for this, but I haven't found any solution related to Ac2007. I want to use a default email client and attach a file (in this case a word doc) to it, the automate send and close the email. I've seen code using sendkeys but it doesn't sound like this is a good...

Thank you for your thought. But I do to have Open Explicit at the top.

Thank you both for all of your input. Your suggestions are things that us amateurs can't get anywhere else. I found out that one of the variables was not declared properly and fixed it. Both codes work, so I have a choice now which one to use. The funny thing was that the Editor was not...

Thanks Gemma and Galaxiom for your input. Galaxiom, I'll try and exit procedure to see if this works. Are you saying that I have to have a case for vbYes and vbNo. I have a case for vbNo already. Gemma, If I comment out the above code, the rest of the code works fine. Impheader always has...

I've been getting this runtime error that closes my application. I don't get this error in the full version of Access2007. I've tried error handling but can never get it to catch. I need help! Here is the code that produces the error: I've tried it like this: 'Check to see if...

Thanks for your help Bob, I have some good ideas now. Great suggestion.

Thanks for your reply. It's nice to have you experts around to help us amateurs see what is possible. I'm just curious how to make the field size get bigger. What property/code would I use. I'm thinking I need to use this method rather than another form, so that I can still use my...

I need help figuring this one out. I have a memo field that shows about 700 characters on my form but can old a lot of text sometimes. The memo field is populated with text that comes from stock phrases from a listbox click. When I open the form, or add text by the stock phrases from the...

Thanks RuralGuy for your help and suggestion. I'm curious what will be the result at runtime? If I get an error will it boot me out of the application that is running and force me to debug? If so, who can I just let the user resume without getting booted out? Thanks again for your input.

I have a split Ac2007 database with a frontend and backend, that is not even close to being max size. The other day, one table quite accepting new records. My frontend forms would just make like it was adding a record, but pooff, the record dissappeard into a black hole without any warning...