Search results

Like The_Doc_Man said. This time he beat me.;) Depending on WHY the new owner doesn't want the inactive products, in fact, you might not need to remove any of them during the migration. You can add an "InactiveDate" field to the product table and set the value for that field to the date on...

There is no reason to try to change current ProductIDs. Import them "as is" and continue on from there. Any new products will get their own new values as they are added. In fact, as a general concept, no external meaning should ever be assigned to Autonumber Primary Keys. If I understand the...

Join us tonight at 6:30PM, Pacific (UTC -8).

Agreed that a small sample accdb would be useful in following the process. However, I question the appropriateness of maintaining a calculated field in a table for "CurrentStock" at all. In a properly designed inventory system, CurrentStock, or QuantityonHand, or whatever term you use, can be...

The Access Pacific Playlist is at: Access Pacific Subscribe to get notifications of meetings and videos

I hope it doesn't come as a shock to anyone that arriving on time is something worth learning. I can cite some colleagues who have to hire entry level workers on the topic of how well that lesson has been assimilated among the youths of today. That along with showing up every single day. And not...

Perhaps I'm missing something, being a senior citizen and all, but isn't showing up on time generally a good idea for pretty much anything we do as humans?

"The result after running the above query shows zero records." Is that desirable or undesirable? What is the significance of returning no records?

True. And the reason we put teachers in charge of classes in school is that SOMEONE has to be the adult in the teaching/learning process. In parallel to that, parents are the adults in a family relationship.

I think what Pete is suggesting is that you use the search term "collection", not the specific name of any given collection. But I may be reading his suggestion wrong.

At some point, one of you has to assume the role of "adult in the room". If you defer to AI to fill that role, yeah, you lose.

I seriously doubt that AI will fade, no more than the internet faded after the dot com bubble burst in the late 1990s. In fact, the cycle is familiar. The "cloud" went through its period of over-hype and settled into a more rational role. Of course, I could be wrong about that. Maybe no one...

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