Search results

Interesting, I'll have to try that. But is PEOPLE a multi-value or choice data type? Or what we might call normal datatypes in other databases?

Thank you. We will all miss UA. Right now, we have summer weather in Western Washington. In two weeks? Anybody's guess.

I agree on the naming convention for those fields. In fact, my first instinct was to double-check that one or both might be meta-data fields added by SharePoint to tables. It does include a number of such fields that are superfluous in Access. It may also be that the Lookup field...

The error message tells you the problem, in less than obvious terms. I can speculate about the problem a bit, but this would be subject to your verification about the field in question. In SharePoint lists, the concept of Primary and Foreign Key constraints is dissimilar to standard relational...

There may be licensed, 3rd party tools. I believe there was a presentation to one of the AUG chapters about such an add-in. Check the YouTube channel, IIRC, there is a license fee involved. Also, It may or may not be appropriate to what you seek. We also had a presentation at my AUG chapter...

No. ChatGPT is a liar.

Please confirm: Is your Access 2016 installation 32 bit or 64 bit? If it's 64 bit, you will need to recreate the mde (or accde) using 64 bit Access to be able to use the resulting accde or mde with 64 bit Access.

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