Solved

Button control in access 2010 report

Posted on 2012-04-06
6
402 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
object variable or with block not set 6 31
Access Crosstab Query with Multiple Values 4 32
Dlookup MSACCESS 5 25
MS Access from Delphi 31 33
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

821 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