--- In MS_Access_Professionals@yahoogroups.com, "Youssef" wrote:
>
> Hi,
> I have a form to view the "Bible verses" and I added the next code to automate moving to next record.
> but,
> when it reaches to the last record it generates an error.
> so,
> I need to make the code stop when it reaches to last record
>
> the code is:-
> ----------------------------------------------------------
> Private Sub Form_Timer()
> Form.TimerInterval = TheTimeInterval * 1000
> If RunTimer.Value = True Then
> DoCmd.GoToRecord , , acNext
> End If
> End Sub
> ----------------------------------------------------------
> where "TheTimeInterval" is a combo box that contains values from
> "RunTimer" is a toggle button.
> 1 to 10 to control the speed of moving between records
>
> thanks in advance
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar