Talk About Network

Google





Software > Access Forms > Re: Go to last ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 4 of 4 Topic 44671 of 46786
Post > Topic >>

Re: Go to last record (Access 2003)

by Carlos1815 <Carlos1815@[EMAIL PROTECTED] > Aug 8, 2008 at 09:43 AM

Thank you for your response!  I ended up figuring it out by doing
something similar:

'******************************************
Private Sub LastQuestion_Click()
On Error GoTo Err_LastQuestion_Click

    Dim iMaxstg As Integer

        iMaxstg = DMax("stg", "tblTopicTitle", "TopicTitle <> Null")

        DoCmd.GoToRecord acDataForm, "TopicTitle", acGoTo, iMaxstg

    Me.monyrtm.SetFocus

Exit_LastQuestion_Click:
    Exit Sub

Err_LastQuestion_Click:
    MsgBox Err.Description
    Resume Exit_LastQuestion_Click

End Sub

I had to use the DMax function because the topics can be shuffled, so
I basically told Access to go to the biggest stg number that has
"something in it" and set Focus in that record.
 




 4 Posts in Topic:
Go to last record (Access 2003)
Carlos1815 <Carlos1815  2008-08-08 07:39:45 
Re: Go to last record (Access 2003)
"Jeff Boyce" &l  2008-08-08 09:17:29 
Re: Go to last record (Access 2003)
"Ken Snell \(MVP\)&q  2008-08-08 12:32:46 
Re: Go to last record (Access 2003)
Carlos1815 <Carlos1815  2008-08-08 09:43:39 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 15:23:15 PST 2009.