Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BillMc

    Click on E-mail address and Create Mail

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

    Click on E-mail address and Create Mail

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

    Click on E-mail address and Create Mail

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

    Click on E-mail address and Create Mail

    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]...
  5. BillMc

    Finding numbers not used in sequential list

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

    Click on E-mail address and Create Mail

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

    Click on E-mail address and Create Mail

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

    Click on E-mail address and Create Mail

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

    Create Desktop ShortCut with Packaging Wizard

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

    Installing Access Runtime on a Server

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

    Hide Query on Run command

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

    Hide Query on Run command

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

    Hide Query on Run command

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

    Find and Replace form open on entering the form

    Thanks.
  15. BillMc

    Find and Replace form open on entering the form

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

    Go to hyperlink address upon entering field (event)?

    With action buttons you are able to go to an address. In this case I want to play a sound file that speaks (instructions) about the field that has just been entered. In properties/Event/On Enter. I want to run a macro that will play the sound file. My question is: what are the macro actions...
  17. BillMc

    Cannot create an .mde ???

    Lightning, The problem is solved. Inadvertantly, I was working with a file format in 2000 instead of 2002. Once I converted to 2002, the mde conversion happened. Thanks for your help. Bill Bill@bmcauley.com
  18. BillMc

    Sort/Filter in datasheet application running in Access Run Time ?

    I need to be able to have my customers sort and filter the fields as they wish in Run Time. Presorting won't work. Thanks, Bill
  19. BillMc

    Cannot create an .mde ???

    Lightning, I did debug, however, the "make .mde file" is in grey and not able to start. I am not getting a error message as it just doesn't open. Do you know what else it could be? FYI: I am using Office XP. Thanks, Bill
  20. BillMc

    Cannot create an .mde ???

    Thanks. I did know something needed to be done (Complile). I just could not remember what it was. I appreciate your help. Bill

Part and Inventory Search

Back
Top