Search results

I don't think that's too surprising. My basic understanding of how LLMs work was that it used pattern matching on the data available to it. I think, in fact, that what is called "training AI", is simply accumulating sufficiently large data sets to support the algorithms needed to identify...

Be careful what you wish for. 😉 It's bad enough when someone here asks for more context before answering a question. I am not sure I would want to be badgered for details by Chatty. Seriously, though, I agree with the general approach. I often go through at least three iterations for prompts...

I was thinking it works here because the reference values are discrete alpha characters....

Interestingly enough, I've been so conditioned not to use BETWEEN because of the problem of Dates with times. It is appropriate here and is simpler syntax.

No problem, really, two characters is the same logic. I apologize for the bonus quotes, typing code in a vacuum isn't my strongest skill. 😉

Well, more context almost always leads to more complete answers. So, you are currently basing the lookup on one character. You could expand that to three characters, or two, or five. CompanyF = Left([Company_Name],3) Now you have to do a range based Lookup for the starting and ending segments...

It seems to me that the most straightforward way will be to revise and expand your current table. Convert the single character lookup values to 3 character lookup values and repopulate the assignments according to your new rules. Once the conversion is in place, in fact, you'll only need to add...

I had a similar experience with my website a couple of years ago. I ended up buying an SSL certificate that allowed me to use https:// instead. It costs less than a fifty dollars a year. For a while it really boosted traffic to have the cert, although I suspect Google changed their algorithms...

Continued success with your project.

My guess would be that it still uses http:// and browsers now consider that unsafe.

Create a second query that sorts this query the way you want it to appear. SELECT * FROM YourQueryNameGoesHere ORDER BY Daten.FoBiID

My ex-wife used to say that she finally felt she had mastered English when she could understand jokes that involved double meanings of words. Something like "Going to a meet market", for example, meaning a bar where you can meet people, not a store that sells hamburger and steaks.

Or, perhaps just common decency?

"...whenever an ID is read..." Read by what? Read where? Read how? "The object (for example: Customer) has to be returned" Returned to what? "Whenever an Object is saved to a table the ID (Property) has to be saved." If the ID in question is an AutoNumber, that will happen when the record...

[/spoiler] One other thing I just noticed here. In an early version, I was passing the names of a form and a control on the form as strings to the error handler. I had named the arguments sFrm and sCtl accordingly. However, I later found a way to reference code modules instead. Also MZ-Tools...

Not a lot, really. I don't have to worry about things like error logging, or error reporting (although that is a feature I left in from client days). Note that all of the arguments are optional because I might, just possibly, have an older accdb with a previous version that I don't want to break...

Here's an example of what I have in my code library. In a Standard Module: modAppConstants Option Compare Database Option Explicit Public Function New_AppConstants() As Appconstants Set New_AppConstants = New Appconstants End Function In a Class Module: Appconstants Option Compare...

That is probably where I first got the idea to try this approach. Thank you.

That sounds like what I was thinking. It's been too long since I set this up and details are hazy. Now you went and made me do research on my own code. 🤔

There is a method to do that. I believe Alessandro explained it in the video.