Search results

I find it rather mind boggling how a clear structure, a few icons, and (over)confident writing style tricks people to stand in awe and not question the actual sensibility and veracity of the statements made. I counted 10+ statements in the AI output in this thread that are either factually...

Oh, Yikes! I can! I missed the fact, that this error message only happens in an ACCDE. For completely unrelated reasons, I never ran that new project as an ACCDE yet. Now I just tried it and also get the error "Requested type library is not a VBA project.". This is unexpected and very...

I cannot confirm this weird limitation. I never used Navigation Forms until I recently "inherited" a large project making extensive use of Navigation Forms. In that project there are several Navigation Forms with a lot of code, event procedures and others, and there is no noticeable problem...

Look on the website of the statistics bureau of your country of interest. For Germany you find price index information here: https://www.destatis.de/DE/Themen/Wirtschaft/Preise/Verbraucherpreisindex/Tabellen/sonderauswertung-nahrungsmittel.html

As far as I'm aware, Microsoft has not yet announced a fix for this issue. I suggest you monitor the corresponding post Query Reference to Remote Database Fails on AFo for updates on this issue.

I skimmed both of the referenced resources and couldn't find any mentioning of "unreliable results". In my experience it is simply not possible to create an index on a column that is not suitable due to non-met requirements. The NULL results in your queries of the COLUMNPROPERTY are indeed...

I have some experience with municipal registers, even though rather with land registers, and I strongly want to second, or third, @MarkK and the @The_Doc_Man 's suggestions of also storing the identity of the register itself with the record. This is the proper way to reference such register items.

Great that you found a solution already. If you want to understand the problem you encountered ... There are two problems with this declaration. Strings in VBA are Unicode Strings and each character is represented by two bytes. So, your c variable has a length of two, not one, as far as the...

Thank you. Here is the link: https://codekabinett.com/rdumps.php?Lang=2&targetDoc=logical-numerals-sorting-access-vba

@dalski , I really like that you provided the SQL Statements to quickly reproduce the problem! This is the prime way to ask this type of question. I ran your scripts and, as far as I can see, they work without issue. Here is an query on the system views that show that there are your two indexes...

The error message is not fitting your situation exactly, but it still hints to the solution: DB.Execute SQLString, dbSeeChanges

Selection.save does not save anything. I raises an "Method or data member not found" compile error. As it is an compile error, I suspect that this line is not actually in your real code but you made this error just in the post here.

I'm slightly confused... The Selection object does not have a .Save method. With the limited fragments you provided of your original code, I don't see any code copying anything into the Selection object. Under these circumstances a "Command not available" error doesn't seem entirely unreasonable.

Should be technically possible to some extent. - But this is dangerous! Sooner or later this will go wrong for some reason. Both should be possible. But before further expanding these ideas any further, ask yourself these questions: Who is going to do the administration of the server? How are...

I suggest you ask it to provide failing test cases for all the problems the A-non-I hallucinated. IsNumeric is used, but only to weed out anything that is not any kind of number at all. The limits of IsNumeric are basically correct, but completely irrelevant in the context of the function...

Here is a crude approach that I find much more comprehensible than Copilot's suggestion: Public Function IsLargeInteger(ByVal varValue As Variant) As Boolean If IsNumeric(varValue) Then If CDec(varValue) >= CDec("-9223372036854775808") _ And CDec(varValue) <=...

Because the OP has in VBScript in use already, and the conversion can be done in seconds while the deprecation will take several years.

It is, but can be converted to VBscript with minimal effort.

*Reading* HKLM is not a problem for non-admin users.

If you prefer a script over an Access app, you should look into Powershell.