473,329 Members | 1,457 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,329 software developers and data experts.

Access 2003 report appears differently on different machine?

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 3323
NeoPa
32,556 Expert Mod 16PB
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
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,556 Expert Mod 16PB
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
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,556 Expert Mod 16PB
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
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...
6
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...
1
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...
26
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...
7
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...
12
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...
2
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...
17
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...
2
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.