Recent content by MarkK

...or generate it in a query...

My 2c about sequential numbering is that it is a presentation concern, not a data concern. Except in the context of items 24 and 26, the fact an item is in row 25 is meaningless. A sequence number is a property of a list. A single data point (a row) carries no concept of order. And this is...

Before rebuilding the entire Db, try just that form. • Create new blank form • Copy/paste controls and code from dead form • Delete dead form • Now try add your new control.

I find it useful in two cases... • To pretty up labels. I use a TextBox set to RichText, and drive data into a formatted html template. • To give users control over formatting in the body of reports they produce. I supply an editable rich TextBox, and combine their rich formatted text as the...

omg, wtf?

Like almost everything, not really as simple as it may first appear. • It is impossible to represent an infinitely repeating decimal with a computer. There is not enough memory to store infinity. It will be rounded or truncated or something, because the precise result is impossible. • Because...

Maybe post your database. I am curious to see code that opens a report in ReportView when called using acViewPreview. I have never seen such a blatant error in Access before.

Are you sure this code runs? This line... ...explicitly opens the report in in print preview (because you've used the acViewPreview switch, which overrides the default view). If it is opening in report view, it seems possible the HyperlinkAddress property of the hyperlink might be opening the...

But this doesn't answer the question I'm posing, not that you are necessarily responding to me. - We can probably agree that there are basic human rights, like food, shelter, clothing, and we will strive to provide these as a matter of justice. Regardless of how poor they are or for what...

Fair enough. It's what I heard, and I fully concede that says something about me, not him. Furthermore, if I've caused a hurt, I apologize. That was not my intent. But the question of much greater interest to me, and the central intent of my post: • As an ideal or abstraction, is the provision...

So in broad strokes, the poor deserve to suffer. That's what you're saying, correct? In broad strokes, if you can't afford medical, and all things being equal, this is self-inflicted. This makes me think of something I read in Slaughter-Five by Kurt Vonnegut. My counter claim is that there's...

IMO, don't save the composite assembled FullAddress in the table. Only store raw data. It is an unforced error to design a table knowing that data in a single row could ever be in conflict with itself. Do you drive without a seat-belt, or paddle without a PFD? • No. It's not safe. • Anything...

Good code expresses intent. In expressing your intent, whether you want to... • do something, or • get something ...is a critical distinction.

Don't do it. Ask your AI about the data principle SSoT. You should never design and use a data structure in which a single data point, like a date, is split into component parts that co-exist with the single source they were split from. This invites the unforced error that your stored data is...

Wow, nice work!!!