Search results

What means "fail to work" exactly? Does it raise an error or does it appear to do nothing? - The latter would be expected when there is a valid date in the selected format as per Windows Regional Settings already. Also, please note: YYYY/MM/DD is not an ISO date format. The ISO date format...

Well, you created an indirect validation rule with your VBA code in combination with the Short Date format of the controls... Here you force YYYY/MM/DD as date format, which might not be a valid date format on the target (runtime) computer. - And, actually, I don't think YYYY/MM/DD is a valid...

Is there a Validation Rule defined for the control in the form? Does this Validation Rule expect the date to be in a specific format?

Please show the code that fails. The most common cause of such problems is when dates are passed on as text and not in Date/Time typed variables.

That was one of the reasons I asked for a simple reproducible example of the problem. If you just report an obscure problem with an error occurring for some of thousands of files and only include a vague description of your code, the chances of Microsoft fixing this are indeed zero. However, if...

Well, that's the point of defining column headers, isn't it? But, as a reminder, particularly for newbies, that might be sensible.

Can you provide a minimal sample db to reproduce the issue? PS: You also should have mentioned that you asked about the same problem before.

I believe this will only work if the query is the Record source of the form in question. In this case you can also omit "Form.". PS: Of course, if there are ambiguities between form controls and table columns in the query, you should not omit "Form."

I do not expect this to work. Even though, the error should be something along the lines of "The specified Recordsource is invalid or does not exist"

It does. I was referring to form and report properties, particularly Recordsource and (Control)Rowsource, not the VBA code. Put this SQL into the Recordsource property of a form (deliberately no line breaks): SELECT Column1, Column2, Column3, Column4, Column5, Column6, Column7, Column8...

Good idea in theory. In practice it is insufficiently reliable. Long property values, particularly SQL statements, will be broken up into multiple lines. The line breaks may happen in mid-word and thus defeat your search approach.

I believe you mean what Oracle calls Flashback Query. It appears to be very similar to Temporal Tables on Microsoft SQL Server. However, I'm not sure if this the right tool for this job. In the main-form/sub-form context data of one form might need to be restored but not from other form(s). How...

Making the buttons (appear to) float on their own will be difficult. However, you could put the buttons on a small pop-up form that floats over the report. - This shouldn't be very difficult. This solution is even easier than my pop-up form suggestion and unless you have a real reason not to...

It's not. By comparing the rounded values for equality of the first 4 digits, your criteria only shows values where there is no problem. Instead you should check whether there are records where the first 4 digits are different.

Collections are not persistent objects, they are just variables. As every other variable, they exist as "plain text" in your VBA code and at runtime of the code in memory of the Access process.

Double check whether the concatenated paths are all valid. My bet is: conOutDir is missing a backslash at the end.

I'm not entirely sure about VB6, but I think it does. A definite Yes for VB.Net. And it's a compiler option that applies to all files in a project. You don't need to put the Option Explicit statement in any file unless you want a particular behavior for one specific file overriding the global...

If the database application was created in 32bit and you open it in 64bit Access the first time, the whole project needs to be recompiled for 64bit. - Believe it or not.

I guess, because you named the project "InputBox" and thus created a name conflict.

Loose the "Pre".