DXMachina (dxmachina) wrote,

  • Mood:

Banging my Head Against Access

Today would've been my twenty-seventh wedding anniversary. Damn I'm old...

Managed to finish most of the quotation application today. Still a couple of thing to finish this weekend, but it should be working for some testing on Monday. Access is driving me crazy. Somethings that are conceptually so simple are just so difficult to actually implement. For example, the first part of the application has the operator input the recipe components for the standard in a subform, one component at a time. I wanted the subform to automatically number each component record sequentially, starting at one. The autonumber won't work for this because it just picks up where it left of the last time. There is a published workaround to do this in a report, but not in a form. I tried setting up a field in the subform to count the component records for the standard, and then set the default value for the new record to the count plus one. For God knows what reason, it numbered the first component '1', the second component '1', and incremented after that. If you stopped and clicked on an earlier record, it reset the counter to the correct position, but then did the same behavior from that point. After a good day of banging my head against it, trying various permutations of the code with different triggering events, I finally tried counting the records in the table using DCount(), rather than using Count() in the form. That worked. I have no clue as to why the other ways didn't. It really ought to be simpler than that, ya know?

New Farscape tonight. Aeryn's back. Damn it was good.

No ride today, but I'll hit the bike path in the morning before I head up to Somerville to play games with the Somervillains. Should be a good day. Now to sleep.
Tags: programming, somervillains, television

  • Baby, It's Cold Outside...

    So, it was -10°F outside when I got up this morning, just before sunrise. I don't recall ever seeing a colder morning. Just thought I'd mention it.

  • Halloween 2014

    It's a chilly, windy, misty night here, so there hasn't been a lot of trick-or-treat traffic so far. That a shame, because it was pretty nice out…

  • We're Having a Heat Wave...

    For the first time in what has been an extraordinarily temperate summer, the temperature has broken 90° here at Casa Machina. We are the midst of…

  • Post a new comment


    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.