Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. S

    Requery a combobox in a subform

    First post! I have read similar threads with a question close to mine, yet still unable to solve this challenge :( I have attached an image of my form. I have a purchase order form and a PO details form within. When the user selects a Vendor from the VendorIDcombo, the combo box in the subform...
Top Bottom