long continuous subform, showing more records...

[magmike]

I once had a code that would automatically scroll a continuous subform
to the last record as to show you that last "page" worth of records.

I'm trying to do something similar with a command button, where when
pressed, will move the continuous subform records forward or backward
one record within the current view. What I am really trying to do is
create my scrolling feature, avoiding the typical scroll bar. If I can
get this to work with a command button, i'm thinking I can get it to
work with an image, too.

Thanks in advance,

magmike

 

[Marshall Barton]

I once had a code that would automatically scroll a continuous subform
to the last record as to show you that last "page" worth of records.

I'm trying to do something similar with a command button, where when
pressed, will move the continuous subform records forward or backward
one record within the current view. What I am really trying to do is
create my scrolling feature, avoiding the typical scroll bar. If I can
get this to work with a command button, i'm thinking I can get it to
work with an image, too.

Ateohen Lebans has some stuff on navigating/scrolling at
www.lebans.com

Mayb the GetSetSB example.

 

[Linq Adams via AccessMonster.com]

From a command button on the Continuous subform

DoCmd.GoToRecord , , acLast

should move to the last record, showing the "last page" of records.

 

[magmike]

From a command button on the Continuous subform

DoCmd.GoToRecord , , acLast

should move to the last record, showing the "last page" of records.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200801/1

How could I ask it to simply advance 10 records forward or 5 records
backward?

 

[Marshall Barton]

How could I ask it to simply advance 10 records forward or 5 records
backward?

VBA Help is your friend (most of the time ;-))

The GoToRecord method allows you to specify the direction
and number of records to move:

DoCmd.GoToRecord , , acMext, 10
DoCmd.GoToRecord , , acPrevios, 5

 

[magmike]

How could I ask it to simply advance 10 records forward or 5 records
backward?

VBA Help is your friend (most of the time  ;-))

The GoToRecord method allows you to specify the direction
and number of records to move:

DoCmd.GoToRecord , , acMext, 10
DoCmd.GoToRecord , , acPrevios, 5

--
Marsh
MVP [MS Access]- Hide quoted text -

- Show quoted text -

In cases where the user pushes the button one too many times (at the
end of the list of records) they get an error stating that they can't
go to the specified record (because there isn't one). How can I code
it to just ignore the action and maintain it's position at the last
record without complaining about it?

Thanks!

 

[Marshall Barton]

In cases where the user pushes the button one too many times (at the
end of the list of records) they get an error stating that they can't
go to the specified record (because there isn't one). How can I code
it to just ignore the action and maintain it's position at the last
record without complaining about it?

What do you have against the standard Navigation buttons?


Take a look at http://www.lebans.com/recnavbuttons.htm