Search results

I swear it's been working for months, but it's hard to argue that it shouldn't have. Luckily, fixing it also solved today's fun Microsoft Trust Certificate issues, which miraculously evaporated when I stepped through it. Thanks for your help!

I have a really hard time sometimes figuring out why code that has worked for years suddenly stops working for apparently fundamental reasons without my making any changes to the database. For this one, I have a form code that essentially copies table data from one database to another while...

Thanks, MajP! Your ItemData(0) got me exactly what I want from my list box. Which is a list box & not a text box because, reasons.

I have an unbound form with unbound lookup boxes looking up from several tables/queries. The lookup functions are correctly returning a visible in my list boxes, but I can't seem to grab that list box values to use in my code unless I select the list box with the mouse. Selecting in either of...

Thanks all, for your feedback. The real root of my problem was that Windows 10 themes no longer update the System Application colors, although they still exist. As @petertheme kindly shared, his plugins for using the Access Themes would be one workaround for this. However, I don't want my users...

Thanks for the advice, Pat, but that only works in a world where all humans are identical. My coworker & I love my new eye-saving muted grey color scheme. My senior user hates it & demands "normal" colors. In this case, compromise would meet in the middle at grey on grey?

Yeah, me too. But my primary user complained. I guess they'll have to hire me to create user profiles. After I fix my Windows system themes again...

As far as I can tell, no... and the standard Windows dark mode is awful in Access. Can't read my property sheets at all now. Will have to go hack the registry again...

Does that change the form colors to dark mode? They stayed white before, but I can't say I was careful about how I chose them until I tried this.

I wanted to view & develop my longterm db in dark mode to save my poor, abused eyes, but not all of my team feels that way. I carefully changed all of my colors to System colors, thinking it would match the user's system. However, now that I've deployed my latest beta, they all have dark mode...

I know you've gone deep-dive into the code already (TL/DR), but I get this behavior sometimes when I copy data from the wed. Something to do with the line break character used in most HTML. I can avoid it if I'm careful to stop copying with the last text letter (harder than it sounds when I'm in...

Is there a secret trick?

That's a good point; I don't have to just replace the debug.prints; there's nothing wrong with ''debug.print. See - this is why I need you guys. Thanks for testing! I’m not sure why it bothered me, since my users would never think to look, but it feels sloppy. Since this db has been evolving...

Anybody good with writing search terms that would find all of my debug.prints that are not commented out? I'm not ready to remove them, I just want to know they aren't there sending secret messages in the background of my compiled program...

Happy to send you ALL of mine. I only had the energy to halfway shovel the driveway today, now it's raining ice on top of the rest...

It seems there's a stronger trend in looking down on those who insist on "proper" grammar. I admit that it has raised my awareness of local dialect and accepted use. I've had to give up on my fury over common "mistakes" after reviewing some of google's usage statistics and analyses by respected...

I know this thread is old, but I found it useful and tracked down another location of Albert Kallal's article: http://www.kallal.ca/Articles/split/index.htm