Search results

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...

Pat is 100% right. Northwind is deliberately not described as a working template for a working database application. It is a showcase of features, built on the best possible foundation we could devise. In fact, in the initial planning and design of Northwind, a significant amount of time was...

I've seen reports that this bug is now fixed in Current Channel Preview version 2506 build 18925.20092 released on 23 June. Note that this bug affected the Current Channel Preview. That's the channel which releases updates first and most frequently. In turn, that means anyone using that channel...

Yes, that's Brazilian Portuguese in the screenshot.

You're right and I knew it, too.

Does it matter to your client whether they can create a report summarizing the business they've done with every company for each one of the prior 10 years, by year or aggregated? If that report would matter, you have no choice but to abandon the non-normalized approach.

TRY what MajP has been offering. It's the perfect compromise. Data is either normalized or it is not normalized. Please disabuse yourself of that "quasi-normalized" misunderstanding.

I spent 20 years in the insurance business myself, both outside as an agent and inside as an employee. Your client may need 5 companies at any given time. He will end up replacing one of them within the very near future, and probably more than one. That's when this decision will come back to...

Once, years ago, when still working for a living (instead of kibitzing in on-line forums) we had a client that insisted on a denormalized data entry form for appointments on days of the week. That was doable, probably using an approach similar to yours. However, since there are only 7 days in...

Please describe this situation as a narrative. What is the end goal? Explain things like maximum and minimum in terms of the specific values you want to compare. Are you talking about a date range, a number range, or something else? Which fields should be filtered for max and min?

If this is the case, i.e. your queries join local Access tables or queries to remote SQL Server tables, the result is the slowest possible performance. The only time you should do that is when there is absolutely no other alternative. Figure out a way to avoid having both local Access tables...

Unfortunately, there's no way to show you ahead of time what the consequences are going to be. As I posted earlier, it's a matter of the number of future billable hours of work that will be required when Safeco goes out of business and you have to add a new field for the replacement company...

Early on my Access career, a situation exactly like this forced me to take normalization seriously, learn what it really involves, and how to avoid uncomfortable conversations with clients who want to know why it required so many billable hours to add one more field to a table to accommodate an...

Here is a link to a blog article that explains the problem in some detail and describes the approach needed to resolve it. Note that article has internal links to other articles on the same topic.

Are you an experienced Access developer wondering how to take your skills mobile? I'd like to share with how I’m replicating the Northwind Developers Edition template from Access—step by step—in PowerApps. Several months ago, I decided to start a project that had been in the back of my mind for...