Search results

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

Brilliant. Thanks so much! Best, Pat

Hello, I hope you don’t mind my using this forum as a learning tool. I am running an Access 2007 database. I am trying to create a query from 3 tables: TblTrainingPrograms containing the following fields Program Number (unique value) Program Title Program Date TblInstructors with these...

Hi, Yes. We've reinstalled. I am really stumped.

Hello, This is the second time I am posting this thread as I didn't receive any replies the first time. Since then, I've realized that the problem I've described below is happening on a computer that has a full installation of Adobe Acrobat 7.0. None of the other db users have this. Maybe...

Hello, I have a split Access 2000 database. 15 users are able to view and enter data with no problems. One user is continually receiving this message: The expression On Click you entered as the event property setting produced the following error: Error accessing file. Network connection...