long continuous subform, showing more records...

  • Thread starter Thread starter magmike
  • Start date Start date
M

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
 
magmike said:
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.
Click to expand...


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

Mayb the GetSetSB example.
 
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

Message posted via AccessMonster.com
 
magmike said:
How could I ask it to simply advance 10 records forward or 5 records
backward?
Click to expand...


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
 
How could I ask it to simply advance 10 records forward or 5 records
backward?
Click to expand...

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 -
Click to expand...

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!
 
magmike said:
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?
Click to expand...


What do you have against the standard Navigation buttons?
:-)

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