Search results

It probably does, but it's the principle of the thing that she complains about.

Many years ago, partly in jest, I suggested that in place of a license key, users could only install Access if they passed a 10 question quiz on Database Normalization. I still think about that sometimes.

I have a cousin who plans to move to Apple and alternatives to MS Office over this one. She creates regular newsletters for a couple of organizations she supports. Without Publisher, she'll need an alternative anyway, but she won't just stop with that one application.

That would be an enhancement to the Northwind Developer Edition that someone would need to make if they were to modify it for use in that specific situation. Keeping in mind, of course, that these templates are intended as a showcase of Access functions, and not out-of-the-box working databases.

Yup, that's exactly what I had to deal with. Users who could not resist "verifying" the csv by checking it in Excel.

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