98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Vertical Scroller disappearing?
Vertical Scroller disappearing?
Resolved · Urgent Priority · Version 2016
Thu 20 Jun 2019, 10:55Delegate Manny said...
Manny has attended:
Access Intermediate course
Access Advanced course
Vertical Scroller disappearing?
hi All,
Very random question. My vertical scrollar intermittently disappears on my subform?!
I would like to page up page down the subform on load so get rid of this problem. But after much googling, i am unable to find a solution?
please advise.
Manny
Thu 20 Jun 2019, 11:13Trainer Jens said...
RE: Vertical Scroller disappearing?
Hi Manny,
Thank you for the forum question.
If you open the sub form and open the Property Sheet and click on the Format tab, you should be able to find Scroll Bars. Here you can tell MS Access which scroll bars you want in the sub form.
When you open the main form the setting should be reflected in the sub form on the main form.
Please let me know if you already have done this.
Please also let me know which Default View you have in the sub form.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 20 Jun 2019, 11:18Delegate Manny said...
RE: Vertical Scroller disappearing?
Hey Jens,
Scroll bars: Both
Default view: Datasheet.
I havent changed anything in this form, so im curious why this has occured. It seems the simple fix is to go to last record and come back again on load, perhaps?
Manny
Thu 20 Jun 2019, 11:48Trainer Jens said...
RE: Vertical Scroller disappearing?
Hi Manny,
I have done some Googling, and I have found a solution which may do the job.
If you in the private module for the form add the two events below.
Private Sub Form_Load()
DoCmd.Requery
Me.ScrollBars = 2 'vertical scrollbar only
End Sub
Private Sub Form_Current()
DoCmd.Requery
Me.ScrollBars = 2 'vertical scrollbar only
End Sub
Please let me know if it doesn't do the job.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 20 Jun 2019, 12:03Delegate Manny said...
RE: Vertical Scroller disappearing?
hey jens, i've tried that one before, it doesnt seem to work for some bizzare reason.
If i click page up and page down on my keyboard, the scroll bar does appear, which makes me thing its a bug in access. but im not sure how to automate the page up and page down movement on the subform load?
Thu 20 Jun 2019, 12:14Trainer Jens said...
RE: Vertical Scroller disappearing?
Hi Manny,
Yes it is a bug.
Have you tried:
Application.SendKeys "{Pgdn}"
It is a walk around but it may work.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 20 Jun 2019, 12:17Delegate Manny said...
RE: Vertical Scroller disappearing?
i would like to try it, but it got a compile error, method or data member not found?
intellisense doesnt seem to recognise .sendkeys?
Thu 20 Jun 2019, 12:19Trainer Jens said...
RE: Vertical Scroller disappearing?
Sorry it is:
SendKeys "{Pgdn}"
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 20 Jun 2019, 12:38Delegate Manny said...
RE: Vertical Scroller disappearing?
hey jens - it worked!!!
i tried something else that also worked. i used your first response, i just requeryed it and it worked. bizzare ey!
Dim subfrm As Form_PriceByFundSubFormF
Set subfrm = Forms!PriceByFundF.PricingF.Form
subfrm.Requery
Thu 20 Jun 2019, 12:41Trainer Jens said...
RE: Vertical Scroller disappearing?
Good Manny,
It could be nice if Microsoft's products were bug free.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 27 Jun 2019: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Convert A Form Into A ReportIf there is a form that you want to to save as a report: |
