473,698 Members | 2,576 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2003 report appears differently on different machine?

10 New Member
When I view a report in another machine, it looks slightly different. First of all, the logo in the report heading does not show up when you print, also in print preview, you can see the last letter is missing from several texts.

I have read other postings online and have done why they asked to check. I have checked that the printer settings are the same for both machines and the same fonts are installed (ie arial). Both machines are using access software not runtime. Both machines are running windows xp and office 2003 sp3.

I can not think of anything else. Has anyone else encountered the same problem?

Thank you for your help.
Mar 17 '08 #1
5 3350
NeoPa
32,569 Recognized Expert Moderator MVP
You've probably found this answer before, but just in case, the selected printer (including driver) is often different between machines. This effects Access reports quite directly, as the results are displayed using the settings of the printer. In other words, it's laid out for a specific printer on the current machine.
Mar 18 '08 #2
lionelm2007
10 New Member
You've probably found this answer before, but just in case, the selected printer (including driver) is often different between machines. This effects Access reports quite directly, as the results are displayed using the settings of the printer. In other words, it's laid out for a specific printer on the current machine.

So how could I develop a database application that is printer independent. I am pretty sure there are a lot of access developers who develops database applications for their client. Do they tell their clients that they should have the same printer and driver that they have.

Any suggestions?
Mar 19 '08 #3
NeoPa
32,569 Recognized Expert Moderator MVP
That's true of course.

The variations between printer capabilities are not that vast. By designing your reports to fit within the capabilities of all printers (allow a small margin for lack of precision in the drivers), you should be able to make them pretty well portable. This is what I had to do for my reports.
Mar 19 '08 #4
lionelm2007
10 New Member
It makes sense. Sometimes I don't think how the machine and printer communicate to output the report. I just want the report to work. Thank you for your input.

Since you mentioned that, I was thinking, could it be that when you "size to fit" the label controls, they could shrink a bit on another computer with a different printer driver and you would see missing letters.

I just tried to change the font size on my machine and when I view it, it will not show the whole word because the label box can not accommodate the larger font size.

I would say it is better to leave some room in the label box to accommodate for different printer drivers and never "size to fit" a label control. I have not tried this on another machine yet but it should work, I hope.

Any other suggestions is greatly appreciated. Also, do you think Crystal Reports is more robust than internal Access reports.

Thanks again.
Mar 20 '08 #5
NeoPa
32,569 Recognized Expert Moderator MVP
I've heard that many people like Crystal Reports but I can't comment from my own experience. Sorry.

As to your other questions, I'm afraid I don't know exactly what your situation is clearly enough to answer them helpfully. I suggest you try out your ideas and see the results. That's what I'd do in your position (maybe after checking in TheScripts first of course ;)).
Mar 21 '08 #6

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

Similar topics

1
2167
by: Corrie Meyer | last post by:
Announcement: SwiftReports standard edition 1.0 for Visual Studio ..NET 2003 released by UniSwift. We are pleased to announce the first release of a fully-managed reporting tool for the Microsoft .NET framework. SwiftReports provides complete code integration with the Visual Studio .NET 2003 environment. Developers can use Visual Studio .NET 2003 to write code in either C# or Visual Basic .NET for report control and event handling.
6
4748
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance
1
43954
by: Tim Marshall | last post by:
I've just received a new computer with Win XP Version 5.1.2600. I want to have Access 2003 and Access 97 running on this, so I did some googling on cdma and it seems I must install these versions of Access "sequentially", ie, A97, first. When I use the Office 97 installation cd, pick my choices, I end up, at the end of the installation, an error telling me the system.mdw could not be created. When I click OK on this, the installer...
26
6093
by: Dragon | last post by:
I have an Access 2003 .mde sitting on an SQL Server. The tables for the application also sit on the Server. I'm having a problem with ODBC on only one of about 10 machines. All the other machines using my Access 2003 .mde see the linked tables without a problem. I've configured the User DSN (under Control Panel, Administrative Tools) tab to match what the other machines are set to, but this didn't work. I keep getting an error message...
7
8859
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I want my users to be able to select a report, click on a command button on a form, which will then automatically create the report as a pdf file and save it to the user's machine. I am using Adobe Acrobat (5.0 I think) and have Adobe Distiller as a
12
3090
by: Ron Weldy | last post by:
I have a test server runinng 2003/IIS 6 with a mixture of asp and asp.net files. On my workstation I have a share set up to the folder where the web files reside. I am just doing quick and dirty asp editing (like I used to be able to do with 2K/IIS5) where I use VS.NET, open an asp file, make changes, save and refresh my browser. Problem is that I get an Access is Denied error when I try to save the file and then the file gets wiped on...
2
6267
by: Wayne | last post by:
I've been having a click around Access 2007 this afternoon and have discovered some things that range from annoying to alarming. My Access 2003 menu bars, which I, like many others, use extensively, are now hidden behind an "Add Ins" tab on the Ribbon. Hardly an intuitive place for a user to find them. Unless my memory is failing me, I'm sure that Access 2003 menus displayed normally in the 2007 Beta. The other thing I've discovered...
17
7662
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running Office 2003 to be able to run the database. While I use multiple versions of Access on my...
2
19474
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I will be writing this article intended for those who are in the same level, or maybe lower, of my technical knowledge. I would be using layman's words, or maybe, my own words as how I understand them, hoping, you will understand it the same way that...
0
9169
Oralloy
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...
0
9030
jinu1996
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...
1
8899
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
8871
tracyyun
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...
0
7738
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
6528
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
5861
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
4371
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
4622
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

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.