473,624 Members | 2,274 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

11x17 OLE Spreadsheet not showing in report

2 New Member
Hi All,

i have an Access 2003 report that prints off a linked OLE to s spreadsheet. The spreadsheet is 11X17, but when I print off the reports only about 3/4 of the spreadsheet is visible.

Even more strange is that if I put a text box with a colored back ground i can see the text box, even if it is on the 1/4 of the spreadsheet that is nolonger visible. What I cannot see is the text that was put in the text box. It is quite strange.

Any Help would be appreciated

Thanks

Gary
Oct 25 '10 #1
0 1092

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2019
by: cjay85 | last post by:
I wish to direct reports that I have created in Access to Excel enabling me to produce a graphical output from Excel. The report is a simple query regarding responses to a letter mailing. There are two reports 'Reply Recieved' and 'Reply Not Recieved'. In an ideal world I would like to be able to create a graph showing the percentage of replys recieved against non-replys. Many Thanks
1
1596
by: ElanKathir .S.N | last post by:
Hollo Guys, I want to export my crystal reports (Crystal Report 9.0) to word format using visual basic 6.0. Means I want to export the reports with out preview. Now showing report using CRViwer9 object, but in other case I want to export without preview. Which object and method for direct export??
0
1360
by: massi | last post by:
HI, I sign today on this community. I need help, I use oracle report web, version 10.1.2.0.2, when I run a xls report (through url) I use format=spreadsheet, the report work... I open the file xls... and all it's ok, but if the file is bigger then 17 MB almost, the jobid run forever but the report doesn't work... If anybody can help me ... thanks a lot massi
6
5220
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet. Again, I have this part working. But the fields in the resulting spreadsheet are in a different order than the Access report. (Example: The fields in the Access report might go FirstName, LastName,Address,City--in the Excel spreadsheet, they come up...
2
7631
by: nofear | last post by:
I used to export my reports as snapshot but now I have to export them to Excel When I export my report to a Excel Spreadsheet the report header and footer are not included Only the data gets exported. How do I format a Access report for Excel the right way?
1
3035
by: Sport Girl | last post by:
Hi everybody , i have the task of developing in Perl a script that retrieves data from 3 tables ( bugs, profiles, products) from a MySQL database called bugs and display them in an excel sheet report. I always get when trying to test it " 500 Internal Server Error - The server encountered an internal error or misconfiguration and was unable to complete your request." Can somebody help me please.
8
1567
by: patriciashoe | last post by:
I have a database that features a number of numeric fields compiled during a year. Example: For each of 13 schools there is one record for each year. How do I construct a report that compares this one record for each school against the the record for the previous year? I would also like the report to show data from each year and have a number of calculated fields showing the difference between the two records (or years). I am basically...
1
3244
jbt007
by: jbt007 | last post by:
Hi All, I am using the following code to import a spreadsheet into my Access 2003 tblWeekly table: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tblweekly", strOutFile, True, "impData" The strOutFile contains the path and file name of the spreadsheet. The "impData" is the range that contains the data I need to import. It is a fluid range (changes from week to week). The spreadsheet is created using Access Automation...
0
910
by: Gary Seelen | last post by:
My issue is that I am trying to have access place an OLE spreadsheet file into a report. However the spreadsheet file is and 11X17 size. Basically the user just wants to print off instructions with his report, the insructions are in the spreadsheet. my issue is that the spreadsheet always cuts off... Is there a way to prevent this from happening?? Thanks, Gary
1
1879
by: Leah Beard | last post by:
I have a table with a stored hyperlink field and in the report from the table i want view the hyperlink, so i need to write a event procedure to open the hyperlink when a text box is clicked in the report. can you help?
0
8240
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
1
8336
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7168
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6111
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5565
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4082
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4177
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2610
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1791
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.