Need to add scroll through records in Access Form
Hello,
A real Access novice here!
I have an Access program that allows you to see only records that are assigned to you. The scroll arrows at the bottom of the frame around the form works great but I need to move that function to be inside the form because of screen resolution issues. Can someone please tell me how to add the scroll function to the body of the form? It could also be displayed as a drop down if that would be easier. See attached screentshot Doc1.docx
A real Access novice here!
I have an Access program that allows you to see only records that are assigned to you. The scroll arrows at the bottom of the frame around the form works great but I need to move that function to be inside the form because of screen resolution issues. Can someone please tell me how to add the scroll function to the body of the form? It could also be displayed as a drop down if that would be easier. See attached screentshot Doc1.docx
Just to add a bit, at a minimum, you can easily add the four basic VCR buttons and in the event procedure for each, use:
DoCmd.GotoRecord
command with the appropriate arguments (First, Prev, Next, and Last). It's when you start to add things like disabling the First/Last when your on the first or last record, jumping to a specific record, etc that things get a little more complex.
Jim.
DoCmd.GotoRecord
command with the appropriate arguments (First, Prev, Next, and Last). It's when you start to add things like disabling the First/Last when your on the first or last record, jumping to a specific record, etc that things get a little more complex.
Jim.
download the sample db in this related thread
https://www.experts-exchange.com/questions/24487585/getting-error-Object-Required.html?anchorAnswerId=ccepted-solution#accepted-solution
see the form "ViewIssues"
https://www.experts-exchange.com/questions/24487585/getting-error-Object-Required.html?anchorAnswerId=ccepted-solution#accepted-solution
see the form "ViewIssues"
ASKER
Hi Rey,
I see how that is working with page up and page down through the records. That would work fine but in this form, from the control number, when you press page up it will scroll from the latest record backwards & when you press page down the form actually moves down not letting you see the top of the form. I'm not sure where the keyboard page up and down controls are programed in.
Thanks for your help
I see how that is working with page up and page down through the records. That would work fine but in this form, from the control number, when you press page up it will scroll from the latest record backwards & when you press page down the form actually moves down not letting you see the top of the form. I'm not sure where the keyboard page up and down controls are programed in.
Thanks for your help
ASKER
Hi Jim,
Simple functionality like that would workk fine, no filtering or anything special would be needed. The VCR buttons would be fine. Is there any additional code beside DoCmd.GotoRecord or will the program know what Back, forward... means?
Thank you
Simple functionality like that would workk fine, no filtering or anything special would be needed. The VCR buttons would be fine. Is there any additional code beside DoCmd.GotoRecord or will the program know what Back, forward... means?
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Rey,
Now I see. Where do I find those arrow buttons to build this?
Thanks
Now I see. Where do I find those arrow buttons to build this?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rey, Found the button options. Will let you know if I need help
Thanks
Thanks
ASKER
OK, Now the First Record , Last Record and Previous Record VCR buttons all work right.
The Next Record button throws an error "You didn't specify search criteria with a FindRecord action. In the Macro window, insert a FindRecord action before the FindNext action"
Not sure why everything works but this one.
Thank you for your help!
Scott
The Next Record button throws an error "You didn't specify search criteria with a FindRecord action. In the Macro window, insert a FindRecord action before the FindNext action"
Not sure why everything works but this one.
Thank you for your help!
Scott
ASKER
Ok It was a mistake on my end. You guys are great. Thank you for your help on this. The sample database is a really good refference tool!
Thank you!
Thank you!
<Where do I find those arrow buttons to build this?>
easy way to do this...
open your form in design view
in the sample db
open the form "ViewIssues" in design view
select all the controls that you need, by clicking on them while you hold the SHIFT key
then, press Ctrl + C to copy the controls
on your database, selec the section in your form where you want the controls
then press Ctrl + V (paste)
easy way to do this...
open your form in design view
in the sample db
open the form "ViewIssues" in design view
select all the controls that you need, by clicking on them while you hold the SHIFT key
then, press Ctrl + C to copy the controls
on your database, selec the section in your form where you want the controls
then press Ctrl + V (paste)
If you want navigation buttons outside of what's there, you'd need to create them on your own and handle all the record positioning, which is a bit more complex than you might think.
Jim.