Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Button control in access 2010 report

Posted on 2012-04-06
6
403 Views
Last Modified: 2012-06-27
Hi

I have a button control in my Access 2010 report.

The report is large so when I scroll down, the button scrolls off the visible screen.  I can't seem to find out how or where to keep a button or other control so that it doesn't go off the screen when I scroll down on the data.
0
Comment
Question by:peispud
  • 3
  • 2
6 Comments
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 37816114
It will depend on the purpose of the button?  What do you want the button to do?

What section (Report Header, Page Header, group header, detail, group footer, page footer, report footer) do you have it in?
0
 

Author Comment

by:peispud
ID: 37816186
The report has a field called [Invoice Num].

The value of this field as read by  will be  read into a varaible using the Report_Current  event.

This varaible will be used to set a filter for the report.

So,  I need to be able to see both the button control and the desired record (which may be on page 2 of the report).
0
 
LVL 61

Accepted Solution

by:
mbizup earned 500 total points
ID: 37816216
To my understanding, this is a quirk/feature/bug in access 2010's report view.

Your controls - whether  placed in the report header or page header scroll along with the rest of the report, and are not visibly pinned to the top of the window you are viewing the report in.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 61

Expert Comment

by:mbizup
ID: 37816236
You can get the visual results you want by displaying the report in Print Preview, but lose the button's functionality.

A workaround might be to place your button on a ribbon associated with the report instead of on the report itself.
0
 

Author Comment

by:peispud
ID: 37819782
I've started to look into ribbons for access 2010.  I will accept your idea, but can't really spend too much time right away learning how to do this.

If you have any suggestions, then I will study them.

Thanks
0
 

Author Closing Comment

by:peispud
ID: 37823609
Thanks
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

860 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