Search results

That is correct. Formatting is simply for display purposes. It does not change the underlying data.

And here I was treating your question as serious. Silly me.

I find that concept positively terrifying. What could possibly go wrong?

That is your opinion but you didn't offer any justification regarding what makes the wrapper simpler or what makes it faster. As I said, if you are using the dlookups multiple times from different places, having a "wrapper" protects you from changes should you decide you need to make a change...

I've handled standard BOM processing with simple queries when the maximum number of levels is known. This was of course before SQL Server added the Hierarchical features. Today, I would use SQL Server if that was the problem I needed to solve because it has the best tools for the job. Sadly...

Hope you're not planning on getting rich by selling it. There is almost no market for stuff like that in the Access community. If that isn't why you are doing it then I would question why you are wasting time reproducing something that works very well. You'd finish the project a lot sooner if...

But there is something wrong with the logic behind what you are doing. Whatever you are trying to do with the record should probably be done all at once rather than broken into tiny pieces. So, either the record contains a repeating group or a mishmash of unrelated fields or your processing...

Do the Britts? Do you ever agree on a PM? You really ought to block this forum since it disturbs you so.

Technically it is not a political party. It is a fragment of the Republican party, but it is a very large fragment . Sadly, the RINOs (Republicans In Name Only) are fighting the MAGA faction as if we were the enemy. They hate DJT so much, they would rather see him fail than succeed. Says a...

Unless you're going to be using each of those functions multiple times, seems like overkill.

Not possible. A querydef is static SQL. Nothing structural can ever be changed using a parameter.

If every query returns different fields, then every query is different whether they take a parameter or not. I don't have a clue what you're doing with the functions. Only you see the Nav pain (sic). The users never see it. Use a rational naming standard for your queries so you know what...

The normal solution simply works with the recordset. Not sure why you feel the need to move a step away from that and you haven't told us. A query returns the same set of columns each time it is executed. A saved query is static. ie, it's structure is not changing. That is why saving...

For multiple reasons, not just because the bible records that God gave them the land of Canaan thousands of years ago. They also won it fair and square in 1948 and again in 1967. If Israel has to give back either part, Mexico should insist on getting back California and most of the southwest...

Seems like Trump needs a history lesson also based on his latest comments that Israel can't keep the "West Bank" which is actually Samaria and Judea. Maybe he'll decide to give California back to Mexico because we shouldn't be keeping it:ROFLMAO::ROFLMAO::ROFLMAO:

I agree and Walmart is currently paying the price. I took a job as a manager in an insurance company 25 years ago. The whole thing was a disaster but one of the issues was that one of my people was an Indian, which was fine, but he didn't speak a word of English and I couldn't get rid of him...

The Palestinian Mandate created after the Ottoman Empire was broken up at the end of WWI was administered by the British until the area was partitioned into two states in 1948 so of course Golda had a "Palestinian" passport. Duh! The Arabs demanded ALL of the old Ottoman province and would...

THEY are the reason Trump won. He was so easy to beat and the Dems were too dumb and crazed by TDS to see how to do it. They believed their own lies and convinced themselves that their anointed candidates could do it. Biden did succeed but he had a lot of help from his friends as they...

All of this "disinformation" turned out to be true. Where is the apology for getting that wrong and endangering the public with the pseudo science they were pushing as reality? And the airwaves are a property belonging to us all. Therefore the government administers access to them to prevent...

The FCC under Biden was totally on board with lying about Trump. Why would they threaten anyone? The administration did threaten the social media companies with legislation if they didn't censor conservatives, especially Trump. Does that count?