Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    1

    Unanswered: First Post - looking for help

    Hello everyone! this is my first post. I am trying to come up with the following scenario :

    I need to create a macro, insert query or module that can create the following.

    table 1 - I create a record and want to click button to create 8 duplicate records on table 2. a standard duplicate button does not work cause the primary key has been set as an auto count (ID) feild so it cannot create a dup.

    hope this makes sence. any suggestions?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why would you want to create 8 duplicate records, albeit in table 2?

    what you coudl do is insert some new records to the table two using a record set, palced in the after insert event

    eg
    dim MyRS as recordset
    'open the recordset (forget the code to do that, buts its available on line)
    dim iLoop as byte
    for iLoop = 1 to 8
    with myRS
    !acolumn="Blah"
    !bcolumn="Blah di Blah"
    !column1=anumericvalue
    end with
    next iloop
    close RS
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •