Search results

"The issue is I have a laptop that has most recent version of Office on and has the same mapped network drive to the pc with the DB..." Did you designate the folder where the accdb is located on your own computer as a Trusted Location for this laptop's installation of Access?

Well done, sir.

tautology /tô-tŏl′ə-jē/ noun Needless repetition of the same sense in different words; redundancy. An instance of such repetition. An empty or vacuous statement composed of simpler statements in a fashion that makes it logically true whether the simpler statements are factually true or false...

I would like to add that in this scenario, the fields in the Vouchers table for first and last names are technically distinct from the fields in the Veterans table, although on the surface they appear to be duplicates. Specifically, the fields in tblVeterans can be deemed...

Clarifying questions. Does this happen in all accdbs? Does it happen in only one accdb? Who uses these databases, besides yourself?

Explain why AI can not help generalize processes. What is it within the AI LLM that prevents this possibility?

Hm. It's almost like you have assumed the role of "Project Manager" and assigned your AI the role of "Able Assistant".

Bottom line: The set of "Things that you can do, but really shouldn't" includes using Functions instead of Subs where appropriate.

I've had similar experiences with Claude incorrectly telling me something can, or can't be done. Hence the need for a cycle of prompting, testing and reprompting. One example was a newer feature in the PowerApps environment that Claude hadn't yet encountered, the ability to execute Stored...

I figured that, but I couldn't resist the temptation. I apologize.

Upsize to SQL Server? :unsure:

Help me understand how that principle, with which I agree, applies to the use of AI to create new code solutions to new problems.

It depends on a number of factors, but the short summary is that AI can speed up iterative, or incremental coding projects. At least two of the basic factors to account for include good, detailed prompting and skeptical verification of output. By that I mean specifying exactly what the...

I searched for "Inventory" in M365. There are two templates offered, one of which appears to be the Business Inventory template you are looking for, although it's not designated as "2007". It certainly has the look of an Access database created in that era, though. However, at least two...

I've heard that you must continually remind Chatty, et al, of your coding standards. Also, you must insist that they are used consistently. Does that correspond to your experience?

In The Northwind databases, you'll find yellow information icons in many places. These are links to online help that explains features we incorporated in Northwind.

While I was out for my morning walk, it dawned on me you are after the functionality Ken describes.

LOL. The reverse of my experience today. :rolleyes:

My first visit this morning was painfully slow. Subsequently, performance returned to normal. Is it something to do with caching behavior of browsers?

Again, if you can explain the reason for this approach, not just the mechanics of this initial attempt, we can help you implement a design that works.