Search results

  1. Bar_NZ

    Send email from access vba using outlook V2

    Well that worked, now I'm being a total dumbass.... Runtime error 3265: Item not found in collection for the following reference MyMail.BCC = MyMail.BCC & rsemail!eMail & ";" By the way, I really do appreciate your assistance here... :o
  2. Bar_NZ

    Send email from access vba using outlook V2

    invalid use of property
  3. Bar_NZ

    Send email from access vba using outlook V2

    :banghead:, Lol... Compile Error: Wrong number of arguments or invalid property assignment With MyMail.SentOnBehalfOfName("Info@nzrwelfare.co.nz") End With
  4. Bar_NZ

    Send email from access vba using outlook V2

    Here is my code, It's a bit messy but I still get a "Object Required" 424 at the "With", I can't see where I'm going wrong, because I'm new to this, can you help me please?? Private Sub Command23_Click() Dim db As DAO.Database Dim MailList As DAO.Recordset Dim MyOutlook As...
  5. Bar_NZ

    Send email from access vba using outlook V2

    Sounds like a great trip, I really hope you enjoy yourself, the SI is awesome and I reckon the weather will be good for you....
  6. Bar_NZ

    Send email from access vba using outlook V2

    Depends on where your visiting, lol, nah, the weather is usually pretty good till the end April mid May....
  7. Bar_NZ

    Send email from access vba using outlook V2

    Hi All, can I please ask where I am supposed to put the MailItem.SentOnBehalfOfName in the code that is mentioned in the thread of the same name without the V2, lol Any help would be greatly appreciated.
  8. Bar_NZ

    Send email from access vba using outlook

    Can you please tell me where the MailItem.SentOnBehalfOfName goes and what I should use before it please Dim, Set....:banghead:
  9. Bar_NZ

    Pivot Legend only shows first two letters of the word

    Yes I think I am, how do I change which column it looks at??
  10. Bar_NZ

    Pivot Legend only shows first two letters of the word

    Hey there, can someone help me please, I have a query that pulls information from a combo box in my form, now I've made a pivot form to report the outputs, however my legend will only display the first two letters of word... I need to show the entire word, any ideas??? :banghead:
  11. Bar_NZ

    My new big-ish project - can you help?

    Hummmm, I have tried many ways to use your answer, however I can't seem to work out how to get the user information to write back to the table...
  12. Bar_NZ

    My new big-ish project - can you help?

    Question 2: Can I get the above information to populate back to a table or query it somehow?
  13. Bar_NZ

    My new big-ish project - can you help?

    Thanks, that worked a treat...
  14. Bar_NZ

    My new big-ish project - can you help?

    During this project, I will end up having multiple questions over a period of time, I really hope you have patience with me.... The database: is for tracking computer issues (this part is complete), also I need to show the on call roster (mostly complete)... This will also have a time sheet...
  15. Bar_NZ

    Help Please with a tricky Iif statement

    New result: 26/08/2012 23:30:00, however dosnt Date() mean todays date??
  16. Bar_NZ

    Help Please with a tricky Iif statement

    =CDate(DateStamp() & " " & [PullACT12])
  17. Bar_NZ

    Help Please with a tricky Iif statement

    I have tried this and I get #Name?
  18. Bar_NZ

    Help Please with a tricky Iif statement

    that's in a query i suppose?
  19. Bar_NZ

    Help Please with a tricky Iif statement

    Have attached a screen shot FYI...
  20. Bar_NZ

    Help Please with a tricky Iif statement

    I'm going to show my ignorance now sorry... How do I do that? Concatenate a date to the calculation? Sorry for being such a dumb ass.. lol
Back
Top Bottom