Search results

  1. S

    Solved sendobject and default email program

    So I decided to take the risk and uninstall Windows Live Mail. Everything is working through outlook now. Problem resolved. Apparently even after setting Outlook as the default app there was still something either in the registry or somewhere else. Thanks for the help people.
  2. S

    Solved sendobject and default email program

    Yes, have rebooted multiple times. Uninstalling WLM may fix the issue by removing whatever entry in the registry is making it happen, but I also fear that upon uninstalling perhaps the code will generate no action and no mail program will open.
  3. S

    Solved sendobject and default email program

    Default mail app is set to outlook in the reg. There are other entries for outlook and WLM under protocols and other entries but I am not certain about the effects.
  4. S

    Solved sendobject and default email program

    Default apps > email> Outlook (was WLM before)
  5. S

    Solved sendobject and default email program

    I was hoping to not uninstall WLM because I would like to keep my old emails around for a bit until I feel they will no longer be needed. I just do not understand why Outlook will not take over as the default mapi
  6. S

    Solved sendobject and default email program

    I have been using sendobject code for many years to send invoice copies through my email client which until last Friday was Windows Live Mail. The issue I am having is that I now want Outlook to send my reports. I have changed the default email app, but WLM is still opening when I run that code...
  7. S

    Send email based on unbound form controls?

    thank you! Let me review all and see if I can get it working on my project.
  8. S

    Send email based on unbound form controls?

    hi thanks! 1- i will hard code the email address into a value list for the control. It only has 1 or 2 options and will not change often 2- no formatting, just a control as text, line space, next control as text. Just to let you know in case it helps. We are emailing a freight broker for a...
  9. S

    Send email based on unbound form controls?

    I would like the user to be able to send an email based on values he entered into a form. I do not need to store the values as they are not going to be needed later. Will I have to generate a report first? Ideally I would like to.. 1- have user complete the form 2-press "send email" 3-List the...
  10. S

    DLookup multiple criteria

    Its a one shot, one kill. Thanks Man. I did try removing one set of " before Company name but was getting syntax error, coouldnt figure out which other " needed to be removed. Thanks so much!
  11. S

    DLookup multiple criteria

    Hoping this thread is still valid as It seems my issue is comparable... I get a type mismatch on the following. Truth is I never came to understand all the double quotes and quotes. I am working from similar statements but apparently not similar enough... Me.[Salesperson] =...
  12. S

    Solved Dlookup syntax issues

    Works:) thank you Sir! Much appreciate
  13. S

    Solved Dlookup syntax issues

    I have changed Product Description to a textbox and changed the code on SKU event AfterUpdate to: Me.[Product Description] = DLookup("ProductDescription", "Products", "SKU = '" & Forms![Orders2].[Order Details Subform4].[SKU] & "'" Now gives me this error...
  14. S

    Solved Dlookup syntax issues

    Is syntax proper on the... Me.[Product Description] = Is the fact that the Product Description control is a dropdown that selects from a query an issue?
  15. S

    Solved Dlookup syntax issues

    I am still getting a "object doesnt support this property or Method" error
  16. S

    Solved Dlookup syntax issues

    Good day. Having issues getting the syntax correct on this AfterUpdate event featured on one of my forms. The code I am trying : Private Sub SKU_AfterUpdate() Me.[Product Description] = DLookup("ProductDescription", "Products", "SKU = " & Forms![Orders2].[Order Details...
  17. S

    'group/combine' similar query results with a + symbol in datasheet view

    I have a simple query that lists order history, one record for each Order Detail. I want to group all the same customer orders with a '+' (that acts as a dropdown) so that it will shorten the list and make it easier to view. In the above example All those records would combine into one and...
  18. S

    Dlookup as a default value

    Arnelgp: No the Prod_Desc must also be stored at the time of issuing of the purchase order. In case the description should change in the future for whatever reason. If there is a dispute regarding the PO, the exact text desc must retained. I have tried to add code to my AfterUpdate event on the...
  19. S

    Dlookup as a default value

    Thanks for the replies people. I do realize I am storing the data twice, but I need to keep record of what was ordered 'at the time as product descriptions can change, and I also want the user to be able to add a note that might be relevant to that specific order "Red caps only" or something...
  20. S

    Dlookup as a default value

    Hello. I have used the following code as the default value for my subform field "Product_Desc": =DLookUp(" [Supplies]![Product_Desc] "," [Supplies] ",[Supplies]![TP_Prod_Code ]=[TP_Prod_Code]) To put it into words, I would like the default value for my subform field Product_Desc to be the...
Top Bottom