Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    London
    Posts
    341

    Question Unanswered: Retrieve NewID after Insert (ASP + VB + ACCESS)

    Hi Guys,

    I've been asked to create an online evaluation form and I've pretty much designed it now but i'm having trouble now in tracking what the unique number is of a record I've just created. I've looked and looked through the web but I have no knowledge of ASP pages so I'm really struggling here.

    I've attached a text document which documents my script section.

    Could someone please have a look at this and see whether they could help me to create a sequence which would insert a record, create the new ID, and store the new ID as something which I can access on another page (or at the very least, print to screen).

    I know this is asking a lot but from knowing nothing about ASP to getting this point has pretty much used up my capacity for new learning
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Hmm, well there is a way, but it aint pretty...
    This article is the best ASP specific example I can find...

    And here is an Access specific article to back up the theory involved (well worth a read!).
    George
    Home | Blog

Posting Permissions

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