Search results

Unfortunately, I don't quite follow. The only thing I understand is that you are saying that Access (VBA), is not capable of performing your calculations. If that is the case, then there is no need to talk about VBA as the host for your calculation function (anymore), right? And that also rules...

Just a note: A .NET assembly containing IL code generally offers less protection against decompilation than an ACCDE (see, for example, the ILSpy tool). If you want to go down this route, you should at least consider obfuscation (e.g. using ConfuserEx). A native assembly would be more secure...

Thank you @MarkK . I already use this. I'm more or less a keyboard junkie. ;)

Sure. But it wouldn't behave like a renamed accdE.

Just as an additional note: It is not enough to rename an accdB to accdE. It must definitely be a database compiled to accdE. The accdE can also be renamed to accdR.

A good naming is often half the way. ;)

Maybe I accidentally pressed the right buttons in my sleep after all?

It has happened to me a few times that I have changed or corrected code in a referenced ACCDB. After closing Access, it was reliably gone. 🤪

That became ingrained in my muscle memory decades ago. I can't help but press Ctrl-S every few seconds (and compile first). I'm sure I've even pressed Ctrl-S on my wife in the middle of the night... 😅 😇

Looking back, I think this approach is actually pretty brilliant. It's simple, understandable, and absolutely waterproof. These criteria make it the best solution. (y) If I were you, I would implement it this way and throw the APIs overboard. If I ever find myself in this situation, I hope...

Thanks for the offer, Colin, but as Phil already said, it doesn't work in his test with the API either. However, retrieving the control window handle seemed to be the least of the problems. I trust his expertise and won't dig any deeper into this. (y)

@cheekybuddha : Thats already covered in my example here.

Of course, Adobe Sign or Docusign could be integrated in a comprehensive manner. :cool:

Thanks for the info @sonic8 . So I won't invest more time in it.

I'm not sure if you're trying to tell me that your suggestion should work... ...or not. 🤔 But I tried something yesterday (quickly, with ChatGPT's help) and didn't get any results either. I've attached this non-functioning database (I've not yet tried to invest more time to check if there's...

That's also a nice solution that works. (y) But I find the boilerplate code for this type of solution too large. Sure, I could encapsulate it in a class, but I would still have additional controls. I still tend to favor the solution mentioned above.

Access controls (text boxes, combo boxes, etc.) are not classic Windows edit control windows, but rather Access-specific containers. I can't describe it any other way, as I can't find any reference for this statement. However, that's how I remember it from the past. In classic Windows edit...

@sonic8 : Unfortunately, the API does not seem to work with Microsoft Access form controls (only with 'real' Windows controls as used in a UserForm).

Interesting approach, I'm not familiar with this API yet. I'll take a closer look at it.

That's also a completely different approach, so thank you too for this idea. But I'm still inclined to use Colin's option 2.