Automatically scroll through records

Hi Everybody

Access 2000 Windows xp

On a form with a single command button connected to a database of 1
thousand records.

I would like to be able to press the command button and automatically
scroll through the records as quickly as possible. annd then stop at
the end of the recordset.

Something like this below but continuous.

Private Sub CmdScroll_Click()
DoCmd.GoToRecord , , acNext
End Sub

Thanks

re: Automatically scroll through records

Hi Everybody

Oops! Should have read:

Access 2000 on Windows xp


On a form connected to a database of 1 thousand records.....there is
command button CmdScroll


I would like to be able to press the command button and automatically
scroll through the records as quickly as possible. and then stop at
the end of the recordset.


Something like this below but continuous.


Private Sub CmdScroll_Click()
DoCmd.GoToRecord , , acNext
End Sub


Thanks

re: Automatically scroll through records

Why not use the vertical scrollbar? If you click & hold in the right
place, the data will scroll downwards as fast as it can, without the
need for any code.

HTH,
TC (MVP Access)
http://tc2.atspace.com

re: Automatically scroll through records

Hi TC
Thanks for the swift reply.........I am probably not explaining myself
correctly.

What I am trying to do is to go from record to record by clicking on
the CmdScroll.
Like the normal go to next record......but........go to next record
........go to next record .......go to next record .......until it
reaches the eof.

I suppose the navigation buttons at the bottom of an Access WIndows
form is the effect I'm trying to achieve.

re: Automatically scroll through records

If you're trying to achieve the same effect as the navigation buttons
at the bottom of a form - why don't you just use those buttons? Why do
you want to write code for something that Access already provides for
you?

TC (MVP Access)
http://tc2.atspace.com

re: Automatically scroll through records

Try setting the "Auto Repeat" Property (in the "Other tab of the Properties
window) to Yes (True).

--
HTH
Van T. Dinh
MVP (Access)



"bobdydd" <reallyuseful2004@yahoo.co.uk> wrote in message
news:1144923477.356259.42130@t31g2000cwb.googlegro ups.com...[color=blue]
> Hi Everybody
>
> Access 2000 Windows xp
>
> On a form with a single command button connected to a database of 1
> thousand records.
>
> I would like to be able to press the command button and automatically
> scroll through the records as quickly as possible. annd then stop at
> the end of the recordset.
>
> Something like this below but continuous.
>
> Private Sub CmdScroll_Click()
> DoCmd.GoToRecord , , acNext
> End Sub
>
> Thanks
>[/color]

re: Automatically scroll through records

I never used this property so I just tried.
==> don't think this works for record-navigation.

Anyone uses this property? For what purpose ?

Arno R

"Van T. Dinh" <VanThien.Dinh@discussions.microsoft.com> schreef in bericht news:%23yAwRBwXGHA.4120@TK2MSFTNGP03.phx.gbl...[color=blue]
> Try setting the "Auto Repeat" Property (in the "Other tab of the Properties
> window) to Yes (True).
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "bobdydd" <reallyuseful2004@yahoo.co.uk> wrote in message
> news:1144923477.356259.42130@t31g2000cwb.googlegro ups.com...[color=green]
>> Hi Everybody
>>
>> Access 2000 Windows xp
>>
>> On a form with a single command button connected to a database of 1
>> thousand records.
>>
>> I would like to be able to press the command button and automatically
>> scroll through the records as quickly as possible. annd then stop at
>> the end of the recordset.
>>
>> Something like this below but continuous.
>>
>> Private Sub CmdScroll_Click()
>> DoCmd.GoToRecord , , acNext
>> End Sub
>>
>> Thanks
>> [/color]
>
>[/color]

re: Automatically scroll through records

It works for rec nav if you place the control on a form used as a Subform.
http://www.lebans.com/recnavbuttons.htm
RecordNavigationButtons is an MDB containing code to replace the standard
Navigation Buttons. The custom buttons exactly emulate the standard
navigation bar including the autorepeat property.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Arno R" <arraNOcomSPAM@tiscali.nl> wrote in message
news:443e9897$0$2017$ba620dc5@text.nova.planet.nl. ..
I never used this property so I just tried.
==> don't think this works for record-navigation.

Anyone uses this property? For what purpose ?

Arno R

"Van T. Dinh" <VanThien.Dinh@discussions.microsoft.com> schreef in bericht
news:%23yAwRBwXGHA.4120@TK2MSFTNGP03.phx.gbl...[color=blue]
> Try setting the "Auto Repeat" Property (in the "Other tab of the
> Properties
> window) to Yes (True).
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "bobdydd" <reallyuseful2004@yahoo.co.uk> wrote in message
> news:1144923477.356259.42130@t31g2000cwb.googlegro ups.com...[color=green]
>> Hi Everybody
>>
>> Access 2000 Windows xp
>>
>> On a form with a single command button connected to a database of 1
>> thousand records.
>>
>> I would like to be able to press the command button and automatically
>> scroll through the records as quickly as possible. annd then stop at
>> the end of the recordset.
>>
>> Something like this below but continuous.
>>
>> Private Sub CmdScroll_Click()
>> DoCmd.GoToRecord , , acNext
>> End Sub
>>
>> Thanks
>>[/color]
>
>[/color]

re: Automatically scroll through records

does


DoCmd.GoToRecord , , acLast

not do what you want to do for you

or


DoCmd.GoToRecord , , acLast

DoCmd.GoToRecord , , acPrevious a few times to have some of
them show

re: Automatically scroll through records

Arno

I referred to the CommandButton as stated by the O.P., not the Navigation
Bar at the bottom of the Datasheet / Form.

--
HTH
Van T. Dinh
MVP (Access)



"Arno R" <arraNOcomSPAM@tiscali.nl> wrote in message
news:443e9897$0$2017$ba620dc5@text.nova.planet.nl. ..
I never used this property so I just tried.
==> don't think this works for record-navigation.

Anyone uses this property? For what purpose ?

Arno R

re: Automatically scroll through records

I placed a commandbutton in the header of a continuous form.
I coded the button to go to the next record on_Click
I did set the Autorepeat-property to 'yes'
But: it did not work when I clicked with the mouse ... focus only moved one record.

Arno R


"Van T. Dinh" <VanThien.Dinh@discussions.microsoft.com> schreef in bericht news:uMdAYG0XGHA.3840@TK2MSFTNGP02.phx.gbl...[color=blue]
> Arno
>
> I referred to the CommandButton as stated by the O.P., not the Navigation
> Bar at the bottom of the Datasheet / Form.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Arno R" <arraNOcomSPAM@tiscali.nl> wrote in message
> news:443e9897$0$2017$ba620dc5@text.nova.planet.nl. ..
> I never used this property so I just tried.
> ==> don't think this works for record-navigation.
>
> Anyone uses this property? For what purpose ?
>
> Arno R
>
>
>[/color]

re: Automatically scroll through records

It is possible that one of the Form Events in changing the current record
stops the AutoRepeat action (because the CommandButton will lose the focus
briefly???)

It sounds like Stephen Lebans' method (Subform) is the way to go.

--
HTH
Van T. Dinh
MVP (Access)




"Arno R" <arraNOcomSPAM@tiscali.nl> wrote in message
news:443ede6d$0$2031$ba620dc5@text.nova.planet.nl. ..
I placed a commandbutton in the header of a continuous form.
I coded the button to go to the next record on_Click
I did set the Autorepeat-property to 'yes'
But: it did not work when I clicked with the mouse ... focus only moved one
record.

Arno R