Search results

  1. T

    Problem sending emails from access

    Hi all. Pulling my hair out with this. I have 2 PC's one running Win XP and one running Win 7 Both have Office 2010 I can run the following code with no problem on the PC running XP, however on the Win 7 PC I get an error, details below Sub sendOutlookEmail() Dim oApp As Outlook.Application...
  2. T

    Bypasing Outlook Security Sorted, attaching a report, not sorted.

    Hello I have managed to send a mail and bypass the Outlook security message by using this code Sub SendMail() Dim outl As Outlook.Application Set outl = New Outlook.Application Dim mi As Outlook.mailitem Set mi = outl.CreateItem(olMailItem) mi.Body = "Hello" mi.Subject = "Please Read" mi.To...
  3. T

    DoCmd.SendObject Dcount

    Hello all is it possible to add the results of a dcount in a message body, I have tried many combinations of code and searched the net but cannot see if it is possible or not. like this in the message body text: DoCmd.SendObject acSendQuery, "my_query", acFormatXLS, "Joe Bloggs", , ...
  4. T

    Dcount help in VBA

    Hi guys I am looking for an answer to a Dcount query. I am pretty new to it and have look through the internet but cannot get what I need to know. I was wondering if you could help? Thanks in advance I want my results to only show if they are less than the date I have specified in the...
  5. T

    Count "0" rather than not including data

    Hello all This is my first ever post, first of all thank you to everyone as this forum has been a godsend at times. Excellent work. I have been looking for the answer to this for some time and cannot find it anywhere. I am hoping you can help. I am looking to have the result of a count...
Back
Top Bottom