Recent content by BillMc

Thanks for your response. My customers are already enjoying the convenience of automatic email from my application. I will now add in these additional features. Sincerely, Bill

Kay, Thanks for your help. It works! I have one more question. I am going to create a "Subject" and a "Message" field now on this same form. Both fields are going to be combo boxes with pre-written messages to pick from. I assume that I can tell those fields to go into the...

The code works fine now. No errors. We are almost there. When I click the command button I get this message: "You cannot create a new Microsft Outlook profile at this time. To create a new profile, open the Control Panel, double-click the Mail icon, and then click Show Profiles.&quot...

Kaygirl, I tried it. Here is the code I entered: Private Sub Command101_Click() On Error Resume Next DoCmd.SendObject acSendNoObject, , acFormatRTF, Me [EmailAddress] , , , , , -1 End Sub I am getting a compile error: "Invalid use of property" and it highlights [EmailAddress]...

What I would do is create a query that will be the souce for a combo box. In that query you will create an expression that looks something like this: IIF([Name]=" ",1,0) I would then use "1" as my sort criteria. Therefore only those records with no text would appear on...

Ok I'm not there yet. I want to click on the email field and have the address that is in that field, which is different for each customer, go to Mail to field in Outlook. Bill

Thanks for your help. This is really works well. Bill

My form contains a field "EMAIL", data type Hyperlink. I want to click on this field and have the following event take place: 1.Open Outlook Express, 2. Create Mail, 3. Automatically enter this "EMAIL" field as the send to address. How do I accomplish this? Thanks, Bill

I would like the Access Packaging Wizard to create a desktop shortcut for my application. How can this be accomplished? Thanks, Bill

I use the Access Packaging Wizard to create the install program for my applications. It automatically installs Access Runtime on the local computer. I have a situation where I need to install Runtime on a server. Where can I get an installation program that will allow me to install Access...

John, I tried removing the AcViewdesign.. and ran the query. It ran and ran. It just did not stop. According to microsoft Access help, an action query needs to be in design view to run. Bill

Hi John, Thanks for the response. I will give this a try later today. Bill

My application uses many action queries that run as an Event Procedure. Following is one example: DoCmd.OpenQuery "AutoQDate", acViewDesign, acEdit DoCmd.SetWarnings False DoCmd.RunCommand acCmdRun DoCmd.Close acQuery, "AutoQDate" Although I have reduced...

Thanks.

Upon entering my form "Reservation Look UP" I have the macro go to the "LastName" Field and then go to a command button that opens the Access "Find and Replace". I really want the "Find and Replace" form to appear automatically on entering my form...