Recent content by theDBguy

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?

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.

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.

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.

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

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!

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

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

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...

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).

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).

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.

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?

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

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.