Re: move last record "doesn't display the last record

From: Val Mazur (group51a_at_hotmail.com)
Date: 02/28/04

  • Next message: Tim Platt: "Connect to an Access database on another server" 
    Date: Sat, 28 Feb 2004 14:13:16 -0500

    Hi,

    How do you know what is the last record should be in your recordset? Order
    of the records in database table and order of the records in your recordset
    could be different 

    -- 
Val Mazur
Microsoft MVP
"Tsevy" <anonymous@discussions.microsoft.com> wrote in message 
news:89511728-CD31-4548-86F2-5A7745EC9BB5@microsoft.com...
>
>
>
> Hi
>
> when I click Move last I am not getting the last record
> If I create a new record  >> I will find the new record on my access 
> database  but move next will display different record
>
> the same problem with moveFirst event
>
> =================
> Form laod
> strsql  = select * tbl_emp
>
> mors.open strsql , goconn ,adOpenKeyset,adlockPessimistic
> ==============
>
> ==========
> cmd_movelast_click()
> mors.move last
> call form_show ' load the textbox lile            txt_Fist_name = 
> !(First_nm)
> end if
>
>
>
> thank
>
  • Next message: Tim Platt: "Connect to an Access database on another server"

    Relevant Pages

    • Re: Message Alert
      ... You or another user can press the F11 key to show the database window ... So the two strSQL lines needs to be changed also: ... assembled strSQL by pressing Ctrl + G, which opens the Immediate ...
      (microsoft.public.access.modulesdaovba)
    • RE: Creating a table in Basic
      ... different query for each of them. ... the design of the database is seriously flawed. ... table when the archiving is started. ... Dim strSQL As String ...
      (microsoft.public.access.formscoding)
    • Re: Multiple Record Inputs with one Form
      ... Dim strSQL As String ... Lets say we start out with two entries. ... "Jeff Boyce" wrote: ... database will let you do. ...
      (microsoft.public.access.formscoding)
    • Re: Import Text with existing schema.ini file utility
      ... the access database is stored. ... > schema.ini needs to be in the same folder as the textfiles. ... > 'Modify strSQL and filenames as required ... >>import those text files into Microsoft Access tables. ...
      (microsoft.public.access.modulesdaovba)
    • Re: SQLs
      ... the database ... 'Set an active connection to the Connection object using ... 'Create an ADO recordset object ... 'Initialise the strSQL variable with an SQL statement to ...
      (microsoft.public.frontpage.programming)