Search results

  1. G

    Run-time error 3251 - Operation is not supported for this type of object

    Hi vbaInet It wasn't returning Null, that's the problem. If it was, then the If statement would skip the .attachment.add command. As it is, there is an entry with a value assigned to the rst variable, but it seems my database wasn't able to process a value assigned to a dao.recordset...
  2. G

    Run-time error 3251 - Operation is not supported for this type of object

    Thanks vbaInet I checked the path and the item was there. I posted the path into Explorer and it opened the perfectly. I've managed to resolve the problem. You'll notice two lines above the problem code is .Attachments.Add stPath, where stPath is defined as a string. This piece of code was...
  3. G

    Run-time error 3251 - Operation is not supported for this type of object

    Hi I've just upgraded from 2003 to 2010 and split the database into front and back-end. The following code now produces "Run-time error ‘3251’: Operation is not supported for this type of object" and stops at .Attachments.Add rst!ConsolidatedFile (highlighted red): Private Sub...
  4. G

    Problem with VBA email code

    Brilliant, thanks for the advice darbid.:)
  5. G

    Problem with VBA email code

    Hi there I have some code that creates an html email and it works fine. However, I have just tried to add a second line that includes a link to a web page. How do I make the web address "clickable"? Whenever I try an insert html tags, I get a compile error...
Top Bottom