Re: FP writing to Access - need autonumber value

From: Bob Evans (dont_send_me_any_mail_at_yahoo.com)
Date: 12/19/04

  • Next message: blar: "Intro & Ask for help" 
    Date: Sun, 19 Dec 2004 21:02:32 GMT

    After the record has been added, execute the following query:

        SELECT @@IDENTITY;

    This is covered in the following knowledgebase article:

        http://support.microsoft.com/kb/232144/EN-US/

    Bob

  • Next message: blar: "Intro & Ask for help"

    Relevant Pages

    • Re: 2 times same query, once with limits
      ... > Bob Bedford wrote: ... >> I've a query quite important to execute. ... ID in an array. ...
      (comp.lang.php)
    • RE: whats wrong with this sql statment? (uses "SELECT-IN")
      ... Then save this query and join it to your table on the Last_Name, First_Name, ... When I try to execute, i get an error message similiar to: ... REALLY a duplicate, and I don't want to see either record. ... TIA - Bob ...
      (microsoft.public.access.queries)
    • Re: Finally which ORM tool?
      ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
      (microsoft.public.dotnet.languages.csharp)
    • RE: SQL stored procedure executing twice
      ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
      (microsoft.public.access.modulesdaovba)
    • Re: Conditional "If Not ... Then" Statement not working properly H
      ... IF Not Bob = 42 Then Exit Sub ... (Condition will not execute because it is FALSE and the "IF" statement ... If Bob42 Then Exit Sub ... Returning to your IF statement, if the variables x, y and z are Boolean types, the simplest way to test if all 3 are TRUE is: ...
      (microsoft.public.excel.programming)
    Loading