Search results

Proceed at your own risk, because you've now been advised of the increased potential for fraud. If you deliberately open this system up to allow deletion or modification of already invoiced orders, mostly bad things can happen after that. I suggest, though, that rather than taking our word...

I doubt that an independent auditor would sign off on the idea that an order could be deleted after an invoice for that order was produced. That is an open invitation to fraud. I once worked on such a system as a matter of fact. One of the main reasons the company I worked for at that time was...

It's easier to offer example SQL when the actual table structure is available. In this case, we assume that there is an order table, plus an order detail table if an order contains one or more line items. This does sound standard: "The invoice number is related to the order. I need a unique...

Join Colin's upcoming AUG meeting for a full one-hour tour de force on new Access features. I'm too lazy to find the link, but it's here somewhere.

Please join us for our Monthly Chapter Presentation, August 7th at 6:30PM Pacific (UTC -8) We’re excited to announce our next session, where we’ll dive into the power of incremental development using ChatGPT in the context of Microsoft Access and VBA. Our presenter, John W Colby, will walk us...

There is a difference between correction and public humiliation, though, is there not?

Not a bad idea, but gathering information on that kind of thing might be a bit hard to do.

I think an essential point to understanding the problem that is MVFs would be that they are seductive to new, inexperienced people, who are more likely to abuse and misuse them. At the same time, experienced, knowledgeable developers, who do understand the inner workings of MVFs, tend to be less...

My theory is that they know why it's a bad strategy but they have chosen not to implement the more appropriate Option Explicit because it would break thousands of apps and confuse people. Not every template uses macros, btw. Check out Northwind Developer....

It's ironic that the whole point of his upcoming presentation is that JWC intends to explain how he used AI to develop a project. The post title for this thread itself says it all: VBA and ChatGPT And yet, here we are stating how he MUST acknowledge that he used AI to complete a project, just...

I think that's the best summation of the situation I've seen.

Maybe you can wait until you see the presentation itself to criticize it? It will be given on August 7th. The YouTube video will be available shortly after that.

Perhaps you overlooked part of Post #1? "...I do not know Python but Chat does! So I started having Chat write the code and I learned how to channel Chat in a useful direction. Cool stuff." That sounds a whole lot like giving acknowledgement/credit to ChatGPT.

Hi, I think you are David, right? I recognize your Food Recall program. Welcome to AWF.

PowerApps is currently more flexible and extensible than AWA's ever were. Granted that doesn't make them a viable replacement for AWA's either, but AWA's were doomed from the beginning by the box they were put in to begin with. The train went from Station A to Station B and stopped there...

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.