Search results for query: *

  1. S

    Question Updating MASTER / DETAIL Records

    UPDATE. Not sure if I've just had an Epiphany on this, but if I just add an event to the child Binding source - as below, then that seems to do the job? Not fully checked it through, but seems to work 100%, and obviously needs some tidying up/error handling... Private Sub...
  2. S

    Question Updating MASTER / DETAIL Records

    Thanks for the feedback - appreciate I have 2 minds on this with far more knowledge than mine. ;) John: I will work through your comments with Beth Massi's code, and hopefully all will be well. JMC: Have fixed the 2 bugs that had been thrown up, and understand your comments. As far as I can...
  3. S

    Question Updating MASTER / DETAIL Records

    Thanks John - I had already looked at another of Beth Massi's posts, but alas - maybe my lack of coding expertise in this area - her solution to the problem missed a key point (she claimed that if the relationships were set up, then the cascade option automatically populated the FK values and...
  4. S

    Question Updating MASTER / DETAIL Records

    Thanks - a couple of issues... Thanks - had seen a few of your posts, and wish I'd found the above a week ago! Trying to match the logic to my particular scenario, and whilst it was going well - I have run into 2 issues. 1. Dim lastAutoNumber =...
  5. S

    Question Updating MASTER / DETAIL Records

    Hope someone can help / point me in the right direction, as I have been looking this up for some while, and am stumped. I have VB 2010 accessing Access via the normal OLEDB connection (project data source). A Form containing MASTER/DETAIL Records - created by making a dataset from both tables...
Back
Top