Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Button control in access 2010 report

Posted on 2012-04-06
6
Medium Priority
?
409 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
[X]
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
  • 3
  • 2
6 Comments
 
LVL 48

Expert Comment

by:Dale Fye
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 2000 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

618 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