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

  • Opening Day Approaches...

    Matt "the Bison" Kemp helps Abby on Sesame street in the Cutest. Video. Ever. As a side note, Vin Scully once dated Joan Ganz Cooney, In fact,…

  • Jersey Bound

    Heading to Jersey for the weekend to visit mom and family in general. Mom is doing well and spamming folks with her laptop. Have remembered to load…

  • Sign from on High...

    Even the gods think Vin Scully is the best baseball announcer ever. I mean, really, what are the odds of a rainbow showing up over Dodger…

  • 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.