Search results

I should have noted that I find the form factor for a smart phone makes PowerApps sketchy, albeit possible. I've settled on a cellular-enabled tablet as the better choice. Maybe the 20-somethings with perfect eyesight can find stuff on a phone, and there are thousands of apps for phones. I guess...

Yes, use Lookup Fields where you would, in Access, add number fields for the Foreign Keys to the two parent tables and enforce RI. The Lookups should probably include only the required Primary Key field, no display fields, as is usually done in Lookups. For some use cases, PowerApps makes...

I arrive in Seattle in 1980. Different place now. 😆 I moved to Puyallup a year ago. Love it here.

Yes, that's why I was being nitpicky. It refers to someone in that SharePoint tenant. If it is a required field, and I think that's optional, then that might account for the error.

Or did you mean "Person or Group"? Or something else? SharePoint is a different environment.

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