Search results

Isn't it to be expected that increased usage would lead to better understanding of the strengths and weaknesses of AI. Unrealistic hype was behind the initial exuberance for AI and also behind claims that it was going to end all human employment as we knew it. It's always been thus with new...

In this case, though, I would have spent even more time figuring out the code in the first place. Also, the quality of the resulting code has to be taken into consideration as well.

I just surfaced from a frustrating vibe session with Claude. I asked for a set of Stored Procedures to manage extended properties on tables. Long story short, the internals of reading, listing, appending and deleting extended properties are, as you might surmise, cryptic. So the first request...

PowerApps now has User Defined Functions (UDF) that accept parameters, perform calculations, and return results. Not quite VBA, but moving in the right direction.

Old? Ha.

I suggest that the likelihood a consumer would have food recall information prior to a chain supermarket having that information is probably not all that great. However, that might depend on how far out in the hinterlands the store is located and whether the store manager is concerned about...

Post #114 right before I posted it in Post #115

Hypothetical question: USDA announces a recall of eggs due to salmonella contamination. I don't see the announcement myself. The next day I go shopping at the local chain supermarket where I buy eggs. How likely am I to buy salmonella contaminated eggs? I.e. what are the odds that the chain...

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.