Search results

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.

That's a completely different approach (thanks for the idea), but I'm inclined to use Colin's option 2.

- Using suggestion 1 results in having the first number column and not the text column beiing displayed after selecting a value. - Usind suggestion 2, as you already mentioned, has the disadvantage that I can no more read out the value property but have to read `uxMultiColumnSample.Column(0)`...

My goal is to display gray text in a combo box that does not contain a value (null), indicating that the user should select a value from the list. Once a value has been selected, it should be displayed in black text. This works fine in a combo box with a single column of type Text (see attached...

I don't know the environment you're looking for a solution for, but I have an idea that I'd like to at least mention. As far as I understand, your software solution is about being able to say with certainty that your software has printed and that the job has reached the printer. Whether paper...

@bodders24 : If I understand you correctly you should dimension gclsHoliday as IHoliday: Public gclsHoliday As IHoliday