Page Down/Up control

[Losartan]

Hello,

I have a continuous form that utilizes a touch screen for input. I have placed a page break after each record and am looking for a way to add a command button to perform like the Page Up button on the keyboard so the user can scroll throught the records.

Any ideas?

thanks,
jason

 

[Losartan]

It would be the easiest way! I'm building a status bar that shows what is going on and I need to have numerous records showing at once.

 

[missinglinq]

I agree with Ken, what's the point of using a Continuous View form if you're only going to allow one record to be viewed at a time? Single View forms are much easier to work with.

 

[dkinley]

Concur. You can take that extra step and build your own command buttons to navigate the records like a 'Next Record' or 'Previous Record' to go through one by one, there are plenty of samples running around on the www that do this.

-dK

 

[Losartan]

I think there might be some confusion. The continuous form shows more than one record. It currently displays 18 records but the user has to scroll to see more than 6 at a time. This is a duties task list that provides the user information on the status of a task. That's why I want more than one record to show and be able to scroll without the scroll bar on the side.

 

[dkinley]

I don't see why not - you could use the same buttons, go to next/previous record. Why wouldn't it skip to the next one?

If you didn't want the buttons visible on every record because it is continuous, you could place the continuous form on an unbound form so you only have one instance of next/previous buttons. To go a step further so it looks like a 'page scroller' since these buttons are only for this particular form and your resolution is the same you could probably look and say .. oh, 3 records per screen. Then the next button could say go to this record + 3 but set focus on next record to simulate a page leap but set the focus on the record at the top of the screen.

-dK

 

[dkinley]

hehe .. oh yeah, the good ole footer.

-dK

 

[speakers_86]

Hum...

Then what about putting buttons in the form footer that moves up/down x number of records when pressed?

I'm doing the same thing. Would you mind telling me how to do this?

edit-Maybe I should clarify! I'm just not sure how to move x records. I can move 1! But x?

 

[KenHigg]

If you still need this tomorrow maybe I can look at it when I get to work, I don't have a lot of this code here at home -

 

[speakers_86]

Yes, that would be great. I've googled it, but haven't come up with much.

 

[speakers_86]

Private Sub imgPageUp_Click()
[Forms]![frmplaylists].[Form].[frmPlaylistsSubPlaylists].SetFocus
SendKeys "{pgup}"
End Sub

Wooohooo!

 

[KenHigg]

Thats one way... I had done it using bookmarks or something like that... Not sure what issues you may run into using the sendkeys thing - Cool idea though.

 

[evanscamman]

To move forward or backward in larger increments than 1 you could do:
(I don't have VB open, so i know the syntax is wrong)

Dim intIncrement as Integer
intIncrement = 3
Docmd.GotoRecord, acGoto, me.currentRecord + intIncrement

 

[KenHigg]

Yeah that was it. DoCmd.GotoRecord. The form record number thing is an often over-looked feature. In a countuous form each record has a record number that is totally seperate from the table the data is stored in and it starts with 1 for the fisrt record, etc. So if you have 100 records displayed and you want to go to the 25th record you just do something like:

DoCmd.GoToRecord acDataForm, "MyFormName", acGoTo, 25

So if when your form is first opened you want to always go to the last record you could do something like:

Dim intLastRecord as Integer
intLastRecord = me.count     'This returns the total number of record the form is displaying

DoCmd.GoToRecord acDataForm, "MyFormName", acGoTo, intLastRecord

Thanks for the bumb evanscamman