Recent content by Dave E

The rest of the world watches, and if it wasn't so important, laughs.

Now the the Israelis have been given the excuse to invade Gaza, and the West Bank, they won't stop until they remove Hamas and destroy the infrastructure. They been waiting a long time for this opportunity and they're not going to let it slip by. As long as the Middle East is squabbling amongst...

It seems that any view which upsets the Israelis is antisemitic. I have sympathies for both sides of the arab/Israeli divide. But I wouldn't trust either of them.

What mainstream science sources, and media outlets, are reporting this revelation? I haven't heard anything so far, so I'm leaning towards the hoax.

And, of course, it will work.

Thank you both for your comments. I still prefer my method but I accept it may not align with good practice.

The reason being that I can make the search easier using one field rather than 12? I can search for single months or multiple months (seasons, but not exclusively). By my thinking, 400 records X 12 fields is a lot more than 400 fields...and would use less coding.

Yes. The check boxes are initialised to ensure a two-state operation, and the code determines whether each is True or False. That part of the code is completed a working satisfactorily. The code tests for True or False so won't look for values. In other circumstances, I tend to use an...

Thanks for that but I'm not looking at the binary method, having looked at the code, it seems a lot of effort for little return. I am now clearer in my mind that my originally suggested method is the way to go. I will have unbound 12 check boxes and a separate field that has 12 symbols...

Thanks to all for your replies. I am going away to study and digest them... Thanks again. DaveE

Thanks for that... I've always wondered about using one-to-many table relationships. In the context of data being repeated a lot within the db, I've always used one-to-many. In this db, however, the plant has one unique flowering pattern so, I think, it can be held within the same table. A...

Hi CJ, Indeed, that would be the method, with the field being 'decoded' into months dependent upon each code bit. The string would be inspected by a looping VBA procedure on the OnCurrent event. And yes, some flowers have two flowering periods in a single year, so this method would cater for...

Thanks, Bob. I have considered that but the issue of storing, retrieving and decoding the data remains.

I would welcome suggestions on the subject of economy, and efficiency, of field-use and VBA coding. I have a gardening db which is recording all relevant data about plants in my garden. It has gone well over the years and, with some help from other members of the forum, is improving year on...

Forget the current OP, Pat. This is becoming a trend for you. You're showing a genuine lack of patience and the wording of your replies are sometimes demeaning to users looking for answers, not incivility. It's not that you need to seek forgiveness from anyone but you should count to 10...