Hi,
I'm using access 2003. Is there a way for me to open an access report with zoom to 82% automatically? Right now, I set it up as maximize, using
but I want it to zoom to 82% for users to be able to see all the data clearly when they open the report.
Please help.
Thank you in advance.
3  7686  ADezii 8,834
Recognized Expert Expert @Bay0519
Is 75% close enough? - In the Open() Event of your Report, place the following code:
- Private Sub Report_Open(Cancel As Integer)
-
DoCmd.Maximize
-
End Sub
- To Zoom the Invoice Report to 75%:
- DoCmd.OpenReport "Invoice", acViewPreview
-
DoCmd.RunCommand acCmdZoom75
Thanks, That's what I need. I was wondering what can be the code for zoom. Thank you again...
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: mar10a |
last post by:
I am trying to insert a .gif. file into an Access report - using
Insert Picture.
The original image is 8X11, but access changes the size to 4X6.5.
When I change the size of the image in access is puts white border
around it and does not change the actual image.
Is there a setting I need to change that would allow access to import
at the correct size, or do I need to use another file type besides
|
by: Elle Short via .NET 247 |
last post by:
Hello All, any help would be appreciated:
I am trying to pass a parameter to an Access Report. Just runningthe report from .net with no parameter in my access query and nowherecondition clause in my .net ...report prints correctly.
As soon as I add the parameter to my Access query, and thewherecondition to my .net....the .Net form pop's up a parameterbox for the user to enter the parameter. That's not what I want,I want to pass the text...
|
by: neoteny2 |
last post by:
I need MS Access to automatically create reports/subreports based on
specific criteria. I am building a database in Access 2003 with
different locations/sites. I have the "sites" table created containing
site info, including an empty field for "date". I also have a report
format already created displaying the site info. I need Access to ask
the user for a date, calculate three additional dates using the entered
date (adding or subtracting...
|
by: ellenh |
last post by:
I have read postings on the similar subject including the posting from
2003 shown below. This process works fine to display a single page
snapshot report in PowerPoint. I need to display subsequent pages from
the same snapshot file in subsequent slides in PowerPoint. I realize
that it is possible to add VB code to the Snapshot Viewer Control and
that there are properties such as .FirstPage, .NextPage, .LastPage,
etc, But I can't find...
|
by: sbuelter |
last post by:
Hello,
I am building an access report that is essentially a form letter that I will automatically fax to the recipient when a button is clicked on a form.
I have the form, faxing issues totally solved, however I can not figure out how to create lots of static content on a report. The dynamic content is the company name, address, etc in the header then 5 rows of pricing in the detail section. Now I need to add about 2 pages of...
| | |
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...
|
by: Composer |
last post by:
This is not a question but rather an answer, or at least a clue.
Like others, I had experienced seemingly random truncation of text
when exporting a perfectly good Access report to RTF. Or rather, one
person experienced it when another didn't, running the same database
on the same computer, both accessing it via Remote Desktop Connection.
This problem made no sense until we found that we had different screen
resolutions, and that when...
|
by: ncsthbell |
last post by:
Hello,
Wanted to ask the best approach to handle this situation: My users want to be able to go into an access application, press a button and it run a report and the report automatically run and be saved to a certain location in Adobe pdf format. Can I use DoCmd.RunCommand 'acCmdOutputtoText' or 'acCmdPrintPreview'? Not sure how to save the results of running the report.
Any suggestions will be appreciated!!
|
by: billelev |
last post by:
Here is some code that I have adapted slightly. It allows a report to be printed to a specific location.
It works by calling SaveReportAsPDF and specifying the access report name, and the root directory to which the filename should be saved. The routine adjusts registry values to achieve its aim.
Now, it works, but not quite as I would like it. I originally thought that I would be able to adjust a registry key (such as...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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...
|
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();...
|
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...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
