How use table search/replace on data type Yes/No?

[twgonder]

The more we hear silence, the more we begin to think about our value in this universe.

Isn't 99.99999% of the universe a pretty silent place?
I think we fit in that percentage of space that isn't silent. Kinda' insignificant.

[twgonder]

The reason(s) for not using yes/no fields may not apply to you. Perhaps you will never need to migrate to sql server or the like. They are not necessarily bad to use. I probably would continue to use them in a lot of db's because the limitations won't apply to me. We were just trying to make you aware of the limitations. If you have a LOT of fields you think need to be altered, you can usually do with with sql and/or code.

...

Thanks for that reading list. I'll get right on that, after I finish with the Yes/No removal.

I took my time to study the scenario of Allen Browne. It seems pretty basic, the kind of query I'll probably be doing hundreds of times. Got a parent table defined that doesn't have a child record for some of the records in the parent, so a null gets returned, Yes/No doesn't allow for null so no go error. That's if I understand in practical terms what the problem was. Knowing Microsoft, it's got to be a problem in more than just Yes/No types.

Indeed, using a "inactive date" seems to overcome the problem as shown in the demo db I uploaded in post #10. Nice solution.

[twgonder]

I'll mark this problem solved if I can find how to do that.
(Edit: Looked around for five minutes, couldn't see how.) Or, am I logged off again? I never know my status when writing a post.
However, I still would like to know how to turn a No into a Yes with replace from Home>Find>Replace when on a Datasheet.

[Micron]

As already stated, this is not a replace thing - AFAIK, you cannot. Use sql or query as noted by me and others.
I think the point that Cox was making is, given the vastness of the universe, and considering that so far, we are the only ones who seem to be making any "noise", that makes us pretty special in one way or another. In other words, if we were 1 of thousands of civilizations known to exist by the evidence we create then we would not be so unique. As it is, we seem to be valuable in terms of what makes up the list of advanced sentient beings in the cosmos.

From my own take on humans as a civilization, we might be unique and valuable in cosmic terms but collectively we are woefully inadequate as a species and probably don't deserve our place in it.

Marking a thread as solved is in Thread Tools dropdown near the top of the page.

[CJ_London]

Your question is vague but in principle you would need a separate form to capture find and replace values then sql to find then replace values.

That form could be accessed by creating right click menus to open it

I’m not going to waste time going into any more detail than that as I don’t see any real benefit. Databases are not documents

[twgonder]

I thought the original question was very clear. What didn't I explain well? Microsoft took the time to put search/replace on tables. It works for everything I've tried, so far, except Yes/No fields. My decision, or that of others, to not use Yes/No fields should have no impact on how Microsoft Access works (or doesn't). I shouldn't have to (subjective opinion I know, but valid from a design POV) use another tool when there is one sitting there to be used. Either it works or it doesn't. If it does work, then how? If it doesn't work, then make a suggestion to Microsoft (but before I do that, I want to be sure there isn't a way to make it work that I haven't thought of--hence my original question). In short, I think entering in 0 (zero), since nulls aren't supposedly allowed, for the search and replacing it with a -1 should work.

That little rant made me think, ¿How does one search for a null in the Search/Replace tool?

[CJ_London]

I thought the original question was very clear.

it was - and the answer is you use sql, but you are going on about search/replace functionality, so I'm thinking perhaps it means something else. Hadn't appreciated the question about default value was intrinsic to the replace question.

With regards Allen's item, potentially it is a bit out of date - it refers to JET, Access now uses ACE - but the yes/no issue has not been resolved in terms of find/replace - don't know about joins, don't have anything to hand to test.

[twgonder]

With regards Allen's item, potentially it is a bit out of date - it refers to JET, Access now uses ACE - but the yes/no issue has not been resolved in terms of find/replace - don't know about joins, don't have anything to hand to test.

I sent a db file in post #10. It still fails in ACE as best as I can tell.

[Minty]

That little rant made me think, ¿How does one search for a null in the Search/Replace tool?

Rather bizarrely, it sometimes works if you type "" in the find section even though it's definitely not an empty string.

It's not brilliant the search and replace, tbh, I only use it very occasionally directly in tables or queries as a one off exercises (normally fixing some dodgy data).
It's easier to simply write a update query. Especially if you are using linked SQL server tables as it works loads faster.