Solved

Need to add scroll through records in Access Form

Posted on 2014-09-11
12
613 Views
Last Modified: 2014-09-11
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
0
Comment
Question by:1212pro
  • 6
  • 3
  • 3
12 Comments
 
LVL 57
ID: 40316956
They can't be moved, only turned off.

 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.
0
 
LVL 57
ID: 40316974
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.
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40316982
download the sample db in this related thread

http://www.experts-exchange.com/Database/MS_Access/Q_24487585.html#accepted-solution

see the form "ViewIssues"
0
 

Author Comment

by:1212pro
ID: 40317078
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
0
 

Author Comment

by:1212pro
ID: 40317091
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
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 300 total points
ID: 40317124
@1212pro

did you look at the form "ViewIssues"?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

Author Comment

by:1212pro
ID: 40317148
Hi Rey,
Now I see.  Where do I find those arrow buttons to build this?

Thanks
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 200 total points
ID: 40317158
<<Is there any additional code beside DoCmd.GotoRecord or will the program know what Back, forward... means?>>

  No, just an additional argument.

  You can even use the wizard for the button to create the navigation buttons.

Jim.
0
 

Author Comment

by:1212pro
ID: 40317163
Rey, Found the button options.  Will let you know if I need help

Thanks
0
 

Author Comment

by:1212pro
ID: 40317213
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
0
 

Author Comment

by:1212pro
ID: 40317233
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!
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40317235
<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)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Run Time Error 3075 15 45
Running sum query 6 33
Replace NULL Value in Crosstab query with previous day data 6 31
Query design issue 2 24
Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
This article will show, step by step, how to integrate R code into a R Sweave document
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now