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

  • Still Whining...

    Didn't make it to down to Jersey yesterday for Thanksgiving. My cough was just too bad. That's twice now in three years I've been too sick to make…

  • Stormy Weather...

    The nor'easter is upon us; it's snowing like crazy out there. It's actually been pretty windy most of the day, with smatterings of rain here and…

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

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