Search results

Does it have an accdb extension or an mdb extension? In which version was it created?

100% agree. I've been waiting for nearly 3 1/5 hours for a report. It is very extensive and ambitious, I know, but ChatGPT 5 has told me "another 15-30 minutes" for 2 hours now. I'm not sure if this particular request is really all that complex, or if it's just gone brain dead in the transition.

While migrating data from an accdb to a server database such as SQL Server is not a cost-free endeavor, it does address most of the security concerns for Access database applications. Comparing that cost to the cost of implementing a third-party application is an important part of the...

We had an interesting conversation last night following John's presentation on VBA and ChatGPT. For me, the main take-away at this point, subject to having time to review the recording, was the importance of developing a strategy for creating effective prompts to guide the AI assistant you...

You may have missed the post where the OP mentioned the new owner is interested in products active in the previous two years. That is history.

Nope. It was me. I am well-trained in the art of ostentatious Presentation titles.

History.

No, adding a different ProductID is not necessary. UNLESS, that is one your organization uses externally, it's not necessary. But they serve two different purposes. The Primary Key is internal to the table and related tables. A ProductID, or to make it maybe a little clearer, a ProductCode...

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