Search results

I want to amplify Colin's message. Organizations and individuals should not run Production database applications on insider channels. Microsoft does not hide the fact that those channels can, and very often will, contain bugs. As a rule of thumb, all of your production database applications...

It comes with risks, but LLM AI could be helpful as well. The risk is that, as a beginner, you will not have the necessary background knowledge to properly evaluate responses. The potential benefit is that you can continue to refine prompts to get more information. Above all, though, you must...

YouTube has a built in search feature you can use to locate potentially useful videos. Enter the appropriate search term, such as "Cascading Combo Boxes", which were mentioned in this thread. The key is to be an active participant in the search.

See a discussion of this problem here in this thread.

"...I thought Numb3rs was SLIGHTLY A LOT more literate..." Fixed it for you.

Where is that "TempRawData" coming from? That would appear to be the source of the problem. It looks like a hidden line break character in that source text. I don't think it would be an indent, or tab character. You can probably resolve the immediate problem by "sanitizing" the input from that...

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