Recent content by arkres

After watching the videos, I'm thinking that I don't really need cascading combo boxes because the two tables aren't related. In other words, I think that I would need to restructure the tables first in order to make this work. Thanks for you help.

Thanks for these. Is there a way to accomplish this with VB as well?

Hi, I'm not a database developer, so I really need someone's help with this. I have a combo box containing "ProgramType". If "DDI" is selected from this combo box, I would like it to open up another combo box containing the contents from "tblDDI". Then I would like the selection to be...

Thank you!

Hi, I have one field on a form called "Program Title". It consists of a drop down menu. I would like it if when a particular Title selection is made it would open up another dropdown menu of sub titles. I then need that selection to appear in the "Program Title" field. I hope that makes sense...

Thanks to both of you. That did the trick!!

Thanks, David. I'm getting the message that my DB can't find the object DisplayExcel. Any ideas?

Yes, please. Export and then Open.

Hi, I apologize if I've posted this twice, but I don't think the first one processed. I am a newbie to vba. I have a button on a form. I just need the proper code to have the button open a query in Excel format. If someone can help, I'd really appreciate it. Thanks so much.

Hi, Yes, I can use Word. I will check the Outlook settings on Monday morning. Thanks to both of you for answering my post. I appreciate it. Pat

Yes, we can create the rtf, but we can't send it. I am completely stumped!

Hi, All other users can perform the same SendObject from similar machines, and the original user can log on to other machines with her own ID and send the object. So it's definitely the machine. Thanks. Pat

Hi, I am using an Access 2007 database. I have several reports created in Access, in that are all sent out through Outlook as rtf attachments using the SendObject method: DoCmd.SendObject acSendReport, "My Report Title", acFormatRTF, RecipientEMail, , , , Email Message, True, False I send...

Thank You !!!!

Hi, I'm new to vba. I am trying to get a clear example of creating a recordset with a query for the purpose of creating an email message using the details of that query. I know how to do this if I am looping through the records in that query, or if I use a make-table query, but I cannot find...