Search results

While this statement is correct, I don't think we should talk about a "crash" here. The End statement intentionally terminates the execution of the VBA application, though not the host. It's not an error (if used intentionally) and not an unexpected termination ("crash") of the code.

^This! I don't think NZ is to blame here. IMO, the situation that triggers the error is something outside the scope of NZ. The most likely cause is that you are trying to read data from a record when there currently is no record, as @gemma-the-husky already stated.

I'm using Screenpresso for many years now. Particularly the ability to have multiple named workspaces to store screenshots in is a distinctive feature for me.

I believe (I can't verify this ATM), the path will be built relative to the HyperlinkBase directory defined for the database. If there is none explicitly defined, Access will assume the database's directory as HyperlinkBase. Result: If the document dragged into the hyperlink field is on the same...

Setting the HyperlinkBase property of the database to "file:///" could do that.

I didn't look at the file, but just reading the two statements quoted above gives me an idea where the problems lies.

I just tried to translate the OP's problem description into VBA code as simple and accurate as possible to create a runable reproduction scenario for the error message. - I don't have any clue about XIRR and its prerequisites.

I can fully reproduce the issue with the information provided: Public Sub TestDoubleOverflow() Const dblRate As Double = -16924727597.1152 Const dblTimeInvested As Double = 2.28767123287671 Dim result As Double result = dblRate ^ dblTimeInvested End Sub

I assumed, as permissions appear to be important, they would have been set where it matters. You could create and link a dummy list on Sharepoint. On startup your application writes an identifiable record to that table (list) and you then read the "Created By" column of that new record to get...

Does Access allow the user to edit data they don't have permission to? This should raise an error when they try to sync the data to Sharepoint at the latest, shouldn't it?

Probably because the "New Posts" section filters by "Unread" by default. Unless someone else posted in that thread it was marked "Read" for you and thus no longer shown in that list. You can adjust that filter by using the "Filters" dropdown on the right-hand side immediately above the list of...

The End statement in your code in the Exit_Err1 section terminates your application.

I believe (not verified) Randomize only uses the integer part of the numeric argument as seed. So, during any day you will get the same sequences but other sequences the next day. Either do not supply any seed at all to let it use the system timer or make sure the integer part of the seed is...

To some extent you can use the SysInternals process monitoring tools to see that Access uses multiple threads to run its internal stuff, particularly DB queries.

It makes sense, if multiple Access databases with different requirements are used. I've got a client who needs the A2010 runtime to still use a legacy ADP application but also needs a current A365 installation to use a different database with Modern Charts.

Public Function dbDAO() As DAO.Database Set dbDAO = Whatever you like End Function Your whole approach appears to be rather unusual for an Microsoft Access project. The commonly used approach is to link tables from one or more backend databases in to the current frontend database either at...

You just didn't pay attention to the documentation of RegRead (the link points to a 3rd-party site because I was unable to find the original docs right away.): You are trying to read HKLM\SOFTWARE\Microsoft\Office, which is a key! So, you must append a backslash to the path. @Gasman's example...

Unless I'm completely missing something, the second part of the summary, re VBA.CallStack, is a complete nonsense hallucination of the AI. I would prefer if you, as a knowledgeable VBA developer yourself, would filter such hallucination from your AI digests.

It doesn't. Inside your loop based on the Controls collection you remove items from the collection. - This is a bad idea because it will produce unpredictable and/or undesired results. If you need to remove items from a collection use an index based loop counting from the last to first...

No need to frown. The search results on your machine look perfectly fine to me. I've got multiple versions of MS Office installed on my computer. Therefor there are more occurrences of the VBE7.dll in my screenshot.