Re: Finding a record number using SQL

Thank you! I will give it a try.


"Del Murray" <Del.Murray@xxxxxxxxxxxxxx> wrote in message
news:475de9d1$1@xxxxxxxxxxxxxxxxxxxxxxxxx
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: 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)
  • 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)