Search results

I'm not sure, but I'd consider also the possibility that removing the Edge browser might impact the SQL Monaco Editor in Access.

In order for anyone to offer specific suggestions about the impact of your VBA on performance with a SQL Azure back end, we need to see that actual VBA so we can try to identify the bottlenecks in it. Thank you for helping us help you.

Yup,

I've deployed a library catalog app to a non-profit. I didn't cater for this approach to author names. In hindsight, it could have been a better approach, albeit it would add to the complexity of the task to have to do contains searches on Author names to find variations. That might get more...

I doubt that the two issues are entirely separate, but we don't have eyes on the network environment which makes diagnosing the problems more difficult. In Post #1, you wrote, "Even if I copy the DB local I still get errors." Here, by "local" I at least thought you meant the laptop where the...

So either the message is referring to something else and you would help us get to the bottom of this by showing us an actual screenshot of the error message, or there is still a problem in the configuration of the Trusted Locations as they are defined on the Laptop which has the problem. Either...

"Enable content message"? That does mean that you have not yet designated the folder where the accdb resides on the Host PC as a Trusted Location for the laptop. If you need help doing that, let us know. Until you do that, there will be problems running it from the laptop as it is now set up...

I'm sorry, but I don't know what this means, "...asks you to give access rights but hasn't." Please explain, or better yet, show the actual message as a screenshot. I suspect, though, that it does refer to the problem of not having designated Trusted Locations. I'm going to refer to the...

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