Search results

Yes, language settings matter.

Given the snippet shown, it should work, but that is why we need to see the actual SQL, not parts of it. The error about syntax or missing operator suggests the problem is elsewhere in that SQL, so that's what we need to evaluate. Also, please confirm that DateCost is a datetime datatype...

Please show us the SQL from the query. Not a screenshot of the query designer. The copy and paste the SQL, please.

This display format would be for display only, though, correct?

The blades come out whenever a site owner even suggests advertising.

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