Re: Finding a record number using SQL

The code i gave you does what you want. You just need to make sure the
autonumber field is in your recordset.. You dont use a sql statement to find
the record you just added. It is alread in your recordset and it is the
currrent record.
You can use the "sort" method of a tADOQuery to order the recordset without
issuing a new select statement.
What


.

Relevant Pages

  • Re: Using For...Each loops when referencing reports.
    ... SELECT tblTx.*, tblTestTx.* FROM tblTx INNER JOIN tblTestTx ON ... 199 is just the ID in your last SQL statement. ... This will now write the exact SQL statement used to open the recordset to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using For...Each loops when referencing reports.
    ... Looking at the SQL statement, I think you're trying to return the records ... from tblTx and tblTestTx where is equal in both tables. ... This will now write the exact SQL statement used to open the recordset to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using For...Each loops when referencing reports.
    ... SELECT tblTx.*, tblTestTx.* FROM tblTx INNER JOIN tblTestTx ON ... '[Print the SQL statement to the immediate window] ... recordset to the immediate window. ... something to do with how I'm using the recordset. ...
    (microsoft.public.access.modulesdaovba)
  • Re: XML Persistence scenario
    ... The main reasons for my request, ... This is why i'm wondering if an XML persisted recordset could be a starting ... >> My goal is to not use SQL statement, just put filters properties and use ...
    (microsoft.public.data.ado)
  • Re: redirect if record already exists in database
    ... >> Do a SELECT from the authorization table WHERE the user column is ... not a recordset object. ... Please consider explicitly listing the columns in your SQL statement ...
    (microsoft.public.inetserver.asp.general)