Recent content by Alc

  1. A

    Solved Nz has started throwing up an error message

    Firstly, thanks for all of those who suggested various causes and fixes. The issue was finally resolved and it was one of those very annoying ones where the only symptom I was seeing that Nz stopped working but the cause was larger. It seems that something happened during the latest software...
  2. A

    Solved Nz has started throwing up an error message

    Not the cause here, unfortunately. It's a field called 'Approval' in a table. I just tried recreating the control, in case there was something 'off' with the original, but no change. I'll find some workaround, it's just going to take time.
  3. A

    Solved Nz has started throwing up an error message

    Sorry, missed this response. Yes and yes. As far as I can work out, txtApproval is not null but also has no value. If I try to assign a value just before the error line, I get told I can't assign a value to it.
  4. A

    Solved Nz has started throwing up an error message

    Thanks for the feedback, gentlemen. The version, etc. is as follows The references are as follows
  5. A

    Solved Nz has started throwing up an error message

    One of the downsides of working for a big corporation. Access is looked down on as a bit of a childish application. IT want us to switch to something they will build, but the department manager won't allow it as it would slow down enhancements (and take years to build). Because IT don't control...
  6. A

    Solved Nz has started throwing up an error message

    Found a way around part of the problem. This code If Not IsNull(txtApproval) Then txtOrigApprover = IIf(IsNull(txtApproval), "A", "B") End If MsgBox txtOrigApprover MsgBox txtApproval sets txtOrigApprover to "B", suggesting that txtApproval is NOT null. However, the...
  7. A

    Solved Nz has started throwing up an error message

    Hadn't seen that way of doing it before. Thanks. Unfortunately, same error message.
  8. A

    Solved Nz has started throwing up an error message

    Thanks. I've requested it but it's company wide so won't happen. I was, effectively, told that I have to work with it.
  9. A

    Solved Nz has started throwing up an error message

    I can't see this specific problem described already, here or via Google, but I apologize in advance if I was just searching using the wrong terms. Many of the Access databases I look after include some variation of If Nz(txtApproval, "") <> "" Then Where Nz is used to replace a Null value in...
  10. A

    Solved Kill working manually but not in code

    I asked but he wasn't very forthcoming. I get the impression whatever he did was either embarrassing (and he doesn't want his boss to know) or he doesn't know himself. His explanation was that "it was a permissions thing". I pushed for him to expand on that and he just said I the permissions on...
  11. A

    Solved Kill working manually but not in code

    In case it's of any use to anybody else, I found the problem but not the cause. The file in question had some property which was preventing it from being deleted using the method I was trying. I had the person who produced it remove and recreate it and all then worked, form my end of things. I...
  12. A

    Solved Kill working manually but not in code

    Apologies to ebs17 and Gasman. I didn't see your responses before I last replied. I can confirm 100% the line causing the problem is being reached and it's the the one that's meant to kill the file. Bennet: I think you're right. I added extra error handling and the result is "Error #70...
  13. A

    Solved Kill working manually but not in code

    Thanks, both. DocMan: DoEvents didn't help, sadly. MajP: Did as suggested and the same thing happened. The code gets to the 'kill' line, then nothing happens to the file I'm trying to delete and the code stops running.
  14. A

    Solved Kill working manually but not in code

    I'm running the following line of code in a module kill "Q:\Auto\Used Data\CasesCurrentlyBeingImported.csv" It doesn't produce an error message, but doesn't do anything. The module ends at that point and exits out. I thought it was a permission thing, but if I insert a break point just before...
  15. A

    Is there any kind of local setting that can override a date/time format specified in a table?

    Finally able to check the guy's machine (he was on vacation). From what I can see, everything in the Date and Time settings is identical to my own PC.
Back
Top Bottom