Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Is it possible to download field info from laptop to main computer changing the ID

Discussion in 'Information Technology' started by Wayne & Kerri Anne, Jul 28, 2006.

  1. Wayne & Kerri Anne

    Wayne & Kerri Anne
    Expand Collapse
    Guest

    Hi All

    My question is can you import field information from a laptop say which has
    the same structure as the table on a main computer.

    I have written a vb6 program that has two main tables
    One is tblworkorder which has a WOID as the Primary key field (Autonumber)
    and the second table tblWorkorderDetail has a WOID as a number field. all
    data is linked by the WOID fields.
    Is it possible to download this info from the laptop and have the main
    computer change the WOID in both tables to the next autonumber of the
    tblworkorder of the main computer. and if possible how would one do it in a
    kiss system. Very New to access 97.


    Kind Regards
    Wayne
     
  2. Loading...

    Similar Threads Forum Date
    Movies Ashdoc's movie review---Mission impossible 5 Rogue nation Theatre, Movies & Cinema Aug 12, 2015
    India Professor Bhullar's release possible after landmark SC judgement Breaking News Jan 21, 2014
    USA UPDATED! Dr. Prabjot Singh, Sikh Professor Attacked in Possible Hate Crime (2 Videos) Breaking News Sep 23, 2013
    A Shabad I came across - possible interpretations Sikh Sikhi Sikhism Aug 28, 2013
    To know God is to Love him, why this is not possible Sikh Sikhi Sikhism Mar 31, 2012

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    The by far easiest way is to change the autonumber fields from increment to
    random
    You'll then be very unlucky to get dups (and you can write pretty simple
    code to handle that)

    Another pretty simple way is the make sure that the On UPDATE Cascade field
    is checked for the reference,
    update to local WOID by the max(WOID) + 100 (or another suitable increment)
    just before the Append
    (to make sure you can lock the maintable during the process)

    The final way is to Make Recordsets with outer and inner loops handling
    WOID's 1 by 1
    (Requires pretty good knowledge of VBA/DAO programming)

    HTH

    Pieter

    "Wayne & Kerri Anne" <ker.way@bigpond.net.au> wrote in message
    news:Oy3PWAjfGHA.2188@TK2MSFTNGP04.phx.gbl...
    > Hi All
    >
    > My question is can you import field information from a laptop say which
    > has the same structure as the table on a main computer.
    >
    > I have written a vb6 program that has two main tables
    > One is tblworkorder which has a WOID as the Primary key field (Autonumber)
    > and the second table tblWorkorderDetail has a WOID as a number field. all
    > data is linked by the WOID fields.
    > Is it possible to download this info from the laptop and have the main
    > computer change the WOID in both tables to the next autonumber of the
    > tblworkorder of the main computer. and if possible how would one do it in
    > a kiss system. Very New to access 97.
    >
    >
    > Kind Regards
    > Wayne
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page