Solved Go to top of report

[KitchenDev]

Hi there!

I searched the reports-forum but couldn´t find a solution for:
Is there a way to place a button in a report and scroll to the top of the report via VBA? Like [Go to Top] ...

Best regards from Austria
Martin

 

[Gasman]

Why not start at the horse's mouth?

DoCmd.GoToPage method (Access)

Office VBA reference topic

learn.microsoft.com

As for button, yes, just add a button, not sure if you want that button to execute the above code or not?

 

[KitchenDev]

I tried that - doesn´t work. I think that is because i´m on a report, not a form!

 

[arnelgp]

you can use Sendkeys (or in my case an alternative KeysSends).

 

[KitchenDev]

Good tip! Thanks a lot. This does the job:

Private Sub cmdHome_Click()
   SendKeys "^{HOME}"
End Sub

 

[Gasman]

I tried that - doesn´t work. I think that is because i´m on a report, not a form!

Ah, I see that it only mentions a form.
Sorry.