Recent content by IceDarkness

  1. I

    "You can't carry out this action at this present time..." error

    Hi, need a little help with this error message that is suddenly appearing for one user in our Access database. We're primarily using Windows 7 with the full version of Access 2016 which works fine but IT are in the middle of upgrading to Windows 10 and they're refusing to put the full version of...
  2. I

    Solved Error 424 Object Required when creating word template

    I did actually solve this issue. The problem was putting the link to the template inside the oWord.Documents.Add(). When I put the template inside of a variable first, then called the variable in the function, it worked fine. Dim strFilename As String strFilename = "F:\whatever.dotx" Set...
  3. I

    Solved Error 424 Object Required when creating word template

    I have a found a little work around. I've altered the Error function just to create Word again. I know it's not ideal but it does work fine with this. Exit_MayCauseAnError: Screen.MousePointer = 0 Exit Sub ErrHandler: 'I don't know why Error 424 keeps popping up every 3 or 4 button presses...
  4. I

    Solved Error 424 Object Required when creating word template

    All I seem to be getting with that is error 91, object variable or with block variable not set.
  5. I

    Solved Error 424 Object Required when creating word template

    The templates are on a mapped network drive actually. I know some colleagues do have trouble with F/H drive disappearing and they have to go to the network address instead. But that's never happened to me. F/H Drive has always been there. I tried changing the template name to something else and...
  6. I

    Solved Error 424 Object Required when creating word template

    oDoc is after oWord is defined so it's empty when it tries to use the contents of oWord.
  7. I

    Solved Error 424 Object Required when creating word template

    It's not, that's the thing. It's Microsoft Word every time even when it fails.
  8. I

    Solved Error 424 Object Required when creating word template

    It says "Microsoft Word" in the msgbox.
  9. I

    Solved Error 424 Object Required when creating word template

    I added a Watch to the variable with various breakpoints to see if it was empty or not when it fails. It's filled with the Word Document everytime which is puzzling.
  10. I

    Solved Error 424 Object Required when creating word template

    I'm wondering if it is a reference issue but surely it would be failing every time if it was. OLE Automation is enabled on both computers.
  11. I

    Solved Error 424 Object Required when creating word template

    It's in the same form Sub. But it doesn't really matter as the error still happens even if I was creating oWord in Command154_Click.
  12. I

    Solved Error 424 Object Required when creating word template

    It's at the bottom of the code. Before I was just using CreateObject("Word.Application") but wasn't sure if I should be using GetObject so I found a function to combine both. It still fails even without the separate function.
  13. I

    Solved Error 424 Object Required when creating word template

    Hi, what I'm trying to do is open a word template from Access, populate some information and then attach it to an email. This is working fine in Office 2019 at home but our work computers are running office 2010 and it seems that after every two/three attempts, it fails with Object Required...
See more
Top Bottom