Search results

  1. MarkK

    self-referencing table with bridge

    I would use terminology 'transaction' and 'post.' The transaction is one, the posts are many. The transaction defines the date/time, and metadata common to the posts it contains, like payee, currency, etc... In each transaction the sum of posted amounts must equal zero. Each post represents a...
  2. MarkK

    Raise your hand

    Embedded in this view--to me--is that you may view justice more as punishment of the offender, and less as protection of society. Again, not a 'wrong' view, but consider, in respect to your slap/steal wallet scenario... • What if the person who only stole the wallet is well known to police for...
  3. MarkK

    Raise your hand

    It's not actually narrow. It's narrow, to you.
  4. MarkK

    Raise your hand

    @The_Doc_Man If you tell a story no one hears, where does that story exist? If you witness an event that occurs between two dogs, where does that experience exist? If you interpret events as meaning something, where is that meaning? • Observation is participatory and understanding is creative...
  5. MarkK

    Raise your hand

    @KitaYama Zero harm done. Indeed, thanks for starting an interesting discussion.
  6. MarkK

    Raise your hand

    Justice only exists in our minds. If there were no people, the entire spectrum 'justice <--> injustice' would fail to exist.
  7. MarkK

    Raise your hand

    To be clear, there is no part of my claim that says your claim is wrong. As with any nuanced claim, we are not so much talking about what the thing is that we observe, but who the person is who observes it. And for what it's worth, I've never seen incarceration as primarily punitive of the...
  8. MarkK

    Raise your hand

    1- I think requiring a witness to swear an oath as a ritual in a process is more about granting legitimacy to the process itself, not so much to force a witness to render accurate testimony, which as you observe, is impossible. If you were to design a process that at its core is only based on...
  9. MarkK

    Solved How to print underscores instead of a field value, in a report

    You might prefer something like... Sub Test() Debug.Print GetRSPUnderscore("Montgomery") End Sub Private Function GetRSPUnderscore(Text As String) As String Const PER_CHAR As Integer = 4 Dim i As Integer Dim tmp For i = 1 To Len(Text) tmp = tmp & " " &...
  10. MarkK

    How to use an incremental sequence in a query (instead of an Autonumber)

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

    Subform going corrupt when adding a field

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

    Rich Text Format, yay or nay?

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

    Solved Rounding To 16Dp Decimal (3 Different Answers)

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

    Open Report in Print Preview

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

    Open Report in Print Preview

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

    Medical

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

    Medical

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

    Medical

    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...
Back
Top Bottom