Search results

Of course you can declare an object variable ByVal. - However, this will only pass the pointer to the object by value (as a copy), not the object itself. - It is not possible to automatically "copy" an object. You would need custom code tailored to the particular type of object to copy an...

The compiler "determines" nothing of the kind. Why would it? It's your job to define the function and with it the types and passing mechanisms for its arguments. - Which is the default behavior I don't know. I acquired the habit of explicitly stating the passing mechanism in the method...

Your challenges has two different layers. The first layer is the low level handling of COM Port communication. The sample @arnelgp linked to is a good starting point and might be able to cover this for you completely. The next layer is communicating with your external display. To do that you are...

You are invoking DCount without any criteria. It is just counting *all* ProdOrderID in SearchPOQ. Use the Criteria argument of DCount to filter for the currently entered PO#.

Unless I'm mistaken, the export #56 from msaccess.exe is just a file dialog to select a file. There are documented and supported solutions available for that purpose. Thus, I would recommend replacing this old, never officially supported API declaration with a supported alternative, e.g...

There are several ways to achieve this. regasm /u should be the easiest. Of course, you can also delete all the registered COM Interfaces (Classes) from the Registry manually or with a script. You need to know their names and CLSIDs then though. Also be aware, that COM Interfaces can be...

I strongly second this recommendation! If someone figured out the username/email/password combination you used *anywhere* (incl. AWF), they will try the very same combination on a long list of sites (Paypal, Amazon, Microsoft, Ebay, you name it). If it matches anywhere they will use it to their...

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?

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.