Display data in record order.

**tvac** · 03-04-2009, 07:33 AM

I've updated from Office Pro for XP to Office 2007, opened my old database and saved in new format.
Records saved as 'Ref' which is the primary key. When opening a form in 2002 to display data, the first record displayed was 1 followed by 2 etc. Buttons would select 'First' Last' 'Next' 'Previous.'
In 2007 the same happens, except if a new record is created and the form opened, that new record is displayed first, not record 1.
So, in Access 2002 if records were numbered 1 to 20 they would be displayed automatically 1, 2, 3 etc., but now with say 2 new records created i.e. 1 - 22
the display order is 21, 22, 1, 2, 3 etc.
How do I rectify this to display records in Ref order 1 to 22?
Hope someone can help. Regards - John

**ExlGuru** · 04-14-2009, 03:06 AM

Try this code it will help you.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    Dim cell As Range
    Dim OldText As String, NewText As String
    
  If Sheets("Sheet1").Range("Z1").Value = 1 Then
    For Each cell In Target
        With cell
            On Error Resume Next
            OldText = .Comment.Text
            If Err <> 0 Then .AddComment
            NewText = OldText & "Changed to " & cell.Text & _
              " by " & Cells(1, 2) & " at " & Now & vbLf
            .Comment.Text NewText
            .Comment.Visible = True
            .Comment.Shape.Select
             Selection.AutoSize = True
            .Comment.Visible = False
        End With
    Next cell
  End If
End Sub

Thread: Display data in record order.

Thread Tools

Rate This Thread

Display

Display data in record order.

Re: Display data in record order.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions