Welcome to SPN

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

Sign Up Now!

Copy records

Discussion in 'Information Technology' started by nicksbackwoods, Nov 9, 2005.

Tags:
  1. nicksbackwoods

    nicksbackwoods
    Expand Collapse
    Guest

    I have a table, used somewhat like a schedule. I would like to create a
    record and then have a command to create duplicate records with different
    dates. Like setting up recurring appointments in Outlook. Any help on how to
    accomplish????
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    India Copy of 48th Rreport of 'LOKPAL BILL 2011' Presented in Parliament Breaking News Dec 10, 2011
    Bhagats Sheikh Farid Copyright? History of Sikhism Nov 14, 2011
    Christianity Public library find is only surviving copy of rebel hymn book Interfaith Dialogues Jan 8, 2011

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Tue, 8 Nov 2005 10:50:09 -0800, "nicksbackwoods"
    <nicksbackwoods@discussions.microsoft.com> wrote:

    >I have a table, used somewhat like a schedule. I would like to create a
    >record and then have a command to create duplicate records with different
    >dates. Like setting up recurring appointments in Outlook. Any help on how to
    >accomplish????


    An appropriate Append query would work; without knowing the structure
    of your table or how you determine the desired dates I can't suggest
    what that query would look like, though.

    John W. Vinson[MVP]
     
  4. nicksbackwoods

    nicksbackwoods
    Expand Collapse
    Guest

    I am having a difficulty with the primary key, it is not an autonumber. As
    far as replication I am using a 7 day advancement, Wednesday to Wednesday,
    maybe 10 weeks in the future.

    "John Vinson" wrote:

    > On Tue, 8 Nov 2005 10:50:09 -0800, "nicksbackwoods"
    > <nicksbackwoods@discussions.microsoft.com> wrote:
    >
    > >I have a table, used somewhat like a schedule. I would like to create a
    > >record and then have a command to create duplicate records with different
    > >dates. Like setting up recurring appointments in Outlook. Any help on how to
    > >accomplish????

    >
    > An appropriate Append query would work; without knowing the structure
    > of your table or how you determine the desired dates I can't suggest
    > what that query would look like, though.
    >
    > John W. Vinson[MVP]
    >
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 9 Nov 2005 08:44:01 -0800, "nicksbackwoods"
    <nicksbackwoods@discussions.microsoft.com> wrote:

    >I am having a difficulty with the primary key, it is not an autonumber.


    Well, what IS the Primary Key? I obviously can't describe how to
    create it if I don't know what it is!

    What have you tried (post the SQL) and what specific problem are you
    having?

    >As far as replication I am using a 7 day advancement, Wednesday to Wednesday,
    >maybe 10 weeks in the future.


    So... you want to create 10 records one for each upcoming Wednesday?

    One way is to make use of an auxiliary table. All my databases contain
    a small table named Num, with one primary key long integer field N;
    it's prefilled (using Excel fill-down and copy and paste, the first
    time I built it) with values 0 through 10000.

    You can use this as the source of an Append query. If you want to
    append 10 rows, use a criterion on N of <10. You can then use

    DateAdd("d", 7*[N], [Enter start date:])

    to generate ten weeks' worth of dates. The other fields in your append
    query are up to you, since I obviously don't know what they should
    be...

    John W. Vinson[MVP]
     

Share This Page