Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Texas
    Posts
    37

    Question Unanswered: Access 2000 front end/back end

    Howdy,

    I've split my database with the wizard - putting the back end (tables) in a different folder on my local hard drive. Using forms, I can add records to my table but when I try to view the records with VB I can only "see" the 1st record ... any suggestions? Sample code below:

    ----------------------------------------------------
    Private Sub Form_Open(Cancel As Integer)
    Dim intRecords As Integer
    Dim intLoop As Integer

    Dim dbs As Database, recinit As Recordset
    Set dbs = CurrentDb
    Set recinit = dbs.OpenRecordset("initiate")

    intRecords = recinit.RecordCount
    MsgBox "There were " & intRecords & " Found"

    recinit.close

    End Sub
    -----------------------------------------------------
    A2K - W2k
    Thanks & Regards
    Pete

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    before the .recordcount try
    .movelast 'populate the recordset

    'and if you want to...
    .movefirst 'get back to the first record

    izy
    currently using SS 2008R2

  3. #3
    Join Date
    Jan 2004
    Location
    Texas
    Posts
    37
    Thanks Izy!!!!!!!!!!!!!!!!!

    It worked!
    A2K - W2k
    Thanks & Regards
    Pete

Posting Permissions

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