Recent content by theDBguy

  1. theDBguy

    Active X textbox borders

    Hi Jeff. I also don't get the issue you're having with the size limit, and exactly which ActiveX control are you referring to?
  2. theDBguy

    New data structure, incorrect query sums

    Hi. I might say create a Totals query to sum the errors first (that way, there are unique sample ids in it for the join) and then connect it to you sample table to sum the samples.
  3. theDBguy

    Unbound and Bound textbox data transfer

    So, if you limited your field size to 25, how many characters were you trying to store in them? How many characters are in the variable. The error seems to suggest it's more than 25.
  4. theDBguy

    Duplicate catch needs to remove row not field

    Hi. Me.Undo should do it; but sometimes, you may have to do it twice. Also, if you don't want the record saved, you need to add Cancel=True to your code.
  5. theDBguy

    Solved Access update query selects checkboxes

    Hi. Congratulations! Glad to hear you got it sorted out. Good luck with your project.
  6. theDBguy

    Adding Date Values in Text Boxes

    Hi. That's where the other part of the suggestion comes in - about using IIf() or IsNull() or IsDate(). And as @Bullschmidt just showed, also the Nz() function. Cheers!
  7. theDBguy

    Unexpected Form_Undo event

    That's because it has invalid data, which you have designed to be discarded.
  8. theDBguy

    Adding Date Values in Text Boxes

    Well, if you haven't used DateDiff() before, you could use this link as a reference. https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/datediff-function
  9. theDBguy

    Unexpected Form_Undo event

    Just FYI, once you use SetWarnings False anywhere in your app, it affects the entire program - not just the place (form, etc.) where you used it. Clicking on the X to close the form tells Access you want to force a close. So, when the data is changed but the BeforeUpdate cancels the save, then...
  10. theDBguy

    Adding Date Values in Text Boxes

    Okay, in that case, you should be able to use DateDiff(). You can use the IIf() statement to check for missing dates (IsNull() or IsDate() functions may work too).
  11. theDBguy

    Adding Date Values in Text Boxes

    Is this form bound to a table? If so, are you saying you have a bunch of date columns in your table? If so, that may not be the best design. It's possible you only need two columns, one date and another to describe what the date means (a third column might be for the "who" part).
  12. theDBguy

    Adding Date Values in Text Boxes

    Hi. Sounds like you may have an unorthodox setup. To calculate difference in dates, you can use the DateDiff() function. However, to apply that to what you have, you might consider posting some screenshots, so we can see what you're dealing with.
  13. theDBguy

    Unbound and Bound textbox data transfer

    Hi. Sorry, but no. All I see is a line highlighted in yellow - no "message" per se. What was the actual error message? It has to be, at least, different than what you were originally getting, right?
  14. theDBguy

    Unexpected Form_Undo event

    You could check your code to see if you are using SetWarnings False.
  15. theDBguy

    Unexpected Form_Undo event

    Hi. I suspect you don't have warning turned on in your database, if you're not getting a confirmation message before the form closes. If you are getting a message, then I think you'll see why this is a normal behavior.
Top Bottom