Recent content by telco25

Chris, I'm not exactly sure if you're trying to do this from a form or reports directly. If you are doing this from reports have you tried using SendObject? Leave the TO field blank and OUTLOOK will open prompting you for this. If you are doing this from a form you can use a command button...

Thanks, Chris. Tried what you suggested, but still getting the same results as before. I may have gotten closer though, I have the path "\\...\...\stOrderNum.doc". The end users seem to think this is doable since they have to move it to the correct sub-directory when they save it anyway...

Hello, Need help again. I believe I'm close but no bananas! Trying to get a report generated from data inputted in a order form so when the user clicks on a command button it will output this form to the correct subdirectory with the order number as report name. I have done something similar...

Rob This is what I did try in the first place and it didn't work. Chris was right with his suggestion on using the index. Since the index field was hidden I forgot all about it. TFTH Telco25

Yippee! Thanks. Chris got me facing the right direction and Skip you hit it right on! It works great!!

Thanks Chris, I did try ElseIf and the name is spelled right. However, I'll try you're suggestion 3. Also not sure if it manners that this is an unbound combo box. Thanks again.

Hello, I need some help on getting an IF-Then Statement to work. This is working off the OnChange in a Combo box. The user picks a company from the drop down list & I want the facilities table associated with this company to open. Here's my test code: If Fac_tab = "BADGER" Then...

I have a macro run a make-table query with the data mode as add, but I want it to automatically select the "yes" button when the warning comes up that it will destroy the existing table. Does anyone know how to do this, please? Thanks.

You and I are trying to do the same thing, I think. Check out the Question in Macros submitted by Yarlie 7-5-2000 called "RunnApp Macro Madness". I tried this and it worked. Hope this is what you're looking to do as well. Good Luck.

Not that savvy with VB. I have a union db that the linked tables are updated by running a query in their db. The users do not want to run these queries to use the union db. Is there a way when they open the union, a macro will open and run the update queries in the linked databases? thanks.

Have a union (marriage) database that the linked tables must be updated for the user to get accurate queried data. Presently I have the users run the queries first that update the linked tables. Then open the union db,but they don't want to do this. I believe there is a way that when the...