Search results

This may not help, but I thought I'd mention it in case there's something you can take from it. We had a client that needed to import csv files into their accounting system. However, the source files were in a proprietary format exported by a different system. We used Access to open the...

I agree. Whatever you did here doesn't address the real, underlying problem. Records in tables have no inherent sort order. To impose a sort order in a form -- such as the one in your screenshot -- you have to designate one yourself when you bind the form to a recordsource. If you do not...

The video from the July 3rd meeting of Access Pacific is available now on YouTube: Geoffrey L. Griffith shared and demoed two Access add-ins he created for the Access community. After the demo, the group participated in a live round of testing and the inevitable debugging which followed. It's a...

I'm still learning my way around over there, so I'll have to follow your steps to see what I can learn. Thanks.

What does "whoops" mean? Can you not create an account there?

Hi Ken. You'll find this a great community. And I'm sure your contributions here will be as valuable as they have been at the soon-to-be-departed Answers site.

If it can change once, it can change 20 times. An alias table is the safest solution.

What is the problem you need to solve? You have this code. What is wrong with it? Details are always a good way to help people understand what you are really asking. As is, it's just a piece of code that does work, but isn't somehow what you need, I guess? Thank you.

I have now published 9 videos on YouTube on the project. I'm about to pull one of them down though. It turns out that during the explanation of things I'd done, I found at least one important flaw that needed to be corrected. It's funny how the process of explaining something often exposes one's...

https://www.merriam-webster.com/dictionary/mollycoddle

The runtime is, just as the name suggests, used to execute your application. That excludes the design elements found in the full version. So, your users couldn't create new VBA procedures, to take an obvious example. I don't know if you could write code that created objects on the fly, but that...

Think of it as full disclosure, transparency, etc. All those things we want other entities to espouse.

"PeopleSoft". Hmm. Why does that sound SO familiar? ;)

One more, perhaps relevant, story along the same lines as the others. More than 30 years ago I created my first Access database. It was minimally functional but it did demonstrate the power of automating a process. After a year or two, we decided to seek assistance from IT to correct some...

Concatenate the full path and filename. But on the basis of that limited info, it's hard to be very precise in how you do that. Show us, please, the entire VBA procedure where you need to use the image. Also, I think you're making a mistake in how the image names are stored. It looks like...

Oh, I know why. I've always been "special". Seriously, it doesn't bother me that much not to have the display available. I know which channel I'm on anyway.

It's never appeared in either of my M365 installations that I can recall. Is there a way to configure it so it does appear? Or is that an artifact of being on beta channel?

"that info "?

You'll find it here:

At this point, I think complaints about imperfect results from AI LLMs fall into the same category as complaints about imperfect advice from other humans. Yup, mistakes can happen. Do your own due diligence. Trust but verify. All those cliches apply. In other words, perhaps we've read too many...