Search results

  1. M

    Elegant solution to a multi-table datasheet?

    Non-elegant solution to the problem. OK; well I thought I was going to be able to do it using a split form as a subform, but the split form wasn't functioning as a sub-form, and after reading this: http://www.access-programmers.co.uk/forums/showthread.php?t=133594 I decided to try something...
  2. M

    Elegant solution to a multi-table datasheet?

    Hmmm I'm not so sure I get you there. I've been working a sub-datasheet method that is dirty but might work for starting data entry today: see the screenshot. The way it's set up now is: the main form is linked to the first subform via HOLE-ID. The first subform is linked to the ones below...
  3. M

    Elegant solution to a multi-table datasheet?

    Hi vbaInet, the thing is that the table-infrastructure is already in place. Sure, I could make a new table that exactly matches the form, but then a geologist would only be able to put one alteration, mineralization, etc per depth record. By having the tables separate, it allows 1 meter mark to...
  4. M

    Elegant solution to a multi-table datasheet?

    I've been doing some research, and I may be able to accomplish something using subforms... However I am having difficulty getting it to grab the from-to from the parent table and replicating it to the other ones. Anyone have any experience with this? I might be able to do it on a onfocus or...
  5. M

    Elegant solution to a multi-table datasheet?

    Hi All, Sorry for the long winded post, but hopefully the attached images will help illustrate the problem: I'm currently developing and adding features to a rather complex database that has scaled well past its original use (isn't that most databases?); a geologic database with hundreds of...
Back
Top Bottom