473,657 Members | 2,625 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Print labels - Best option between using access reports or HTML templates

Hi all,

I'm trying to generate labels to print in several different formats,
all of them with their own height,width and page margins. We've got
this done in MS Access 2000, using a designed report that fits with
each label type, and reads a table dinamically generated. But the
problem is page margins. Does Access store page margins and
information of that kind within de report? Is there any kind of
association between printer configuration and reports? For example, I
want to print some labels in A4, that have 0 left/right/top/bottom
margins, but i can't get this done with access, it "forgets" the
margins configuration when I send a data-filled mdb to the client.

The alternative way can be use HTML, by dinamically writing labels in
a formatted ASP and then printing, but I'm afraid the problem still
remains, because I don't know how to say IE (or other navigator) to
print the page respecting the format I'm sending.

Can I configure printing settings if I use ActiveX, embedding a
browser in HTML?

Please, any idea?
Jul 21 '05 #1
2 2311
crystal reports supports a wide variety of labels. you can generate a crystal
report and render it to the browser as a pdf file so you can keep the format
when you print it..

hope this helps..

"Luis Serrano" wrote:
Hi all,

I'm trying to generate labels to print in several different formats,
all of them with their own height,width and page margins. We've got
this done in MS Access 2000, using a designed report that fits with
each label type, and reads a table dinamically generated. But the
problem is page margins. Does Access store page margins and
information of that kind within de report? Is there any kind of
association between printer configuration and reports? For example, I
want to print some labels in A4, that have 0 left/right/top/bottom
margins, but i can't get this done with access, it "forgets" the
margins configuration when I send a data-filled mdb to the client.

The alternative way can be use HTML, by dinamically writing labels in
a formatted ASP and then printing, but I'm afraid the problem still
remains, because I don't know how to say IE (or other navigator) to
print the page respecting the format I'm sending.

Can I configure printing settings if I use ActiveX, embedding a
browser in HTML?

Please, any idea?

Jul 21 '05 #2

Thanks for reply.

By the moment we're not interested in using Cristal Reports, because
licensing it would increase our prices. We're sure our clients have, at
least, Office 2000, so we have to manage with this.

After the post yesterday, I realized MS Word has label assistants, and
it has the type of labels our clients use, so all I've got to do is find
some way to automate the rendering of labels from server and send the
results in a .doc file to client, or write some code in a macro that
reads data from another file. But the first way has a problem... we've
to be sure that Office is installed on server and have rights to
execute/read/write. And the second one needs two files to be sent to the
client, and the idea is send just one, already rendered file.

Some ideas?

Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
9242
by: DrUg13 | last post by:
In java, this seems so easy. You need a new object Object test = new Object() gives me exactly what I want. could someone please help me understand the different ways to do the same thing in C++. I find my self sometimes, trying Object app = Object(); Object *app = Object(); Object app = new Object();
3
10569
by: Chuck Reed | last post by:
I have a MS Access data base that creates custom reports for clients in PDF form then prints the reports after all client's reports have been printed. The problem that I have run into is that when acrobat is printing to my printer, I can get it to print only the first page of a report(OPTION 1 BELOW) or it is spooled to the printer then deleted in the print cue before it it printed (OPTION 2 BELOW). It's been very frustrating trying to...
2
2224
by: John Smith | last post by:
Perhaps the wrong place to ask but...Friend has names and addresses in Microsoft Works Database...how can she print off address labels from this database? Thanks, John
1
8837
by: Rolan | last post by:
I have a need to print very large font numbers on a card stock size of 5.5" x 8.5" in Access 97. The character count will not exceed 3 numbers across. So I'm assuming that a 3.5" to 4" height should work. Of course, 72pt fonts fall considerably short of this size. Can I use either Labels or Reports to do this? Any special setup requirements? I don't necessarily need to rotate the text. Can basic fonts be resized? I remember seeing...
11
1781
by: BerkshireGuy | last post by:
Hello, I need to create an interactive report that can be sent to agencies with the following: Application #, Date Approved, Reason Not Taken The reason not take should be a drop down in which the agency can select as to why the application wasnt approved and then send the "report" back to us.
3
2882
by: Guoqi Zheng | last post by:
Dear sir, Our E-commerce site needs to print out a few 100s invoice a day. I do not know what is the best way to print invoice. Those invoice has to be printed on a very precise position on our invoice format paper. I am thinking about the following to print the invoice. 1. Ms Access Report. 2. ASP.NET web form.
4
441
by: Luis Serrano | last post by:
Hi all, I'm trying to generate labels to print in several different formats, all of them with their own height,width and page margins. We've got this done in MS Access 2000, using a designed report that fits with each label type, and reads a table dinamically generated. But the problem is page margins. Does Access store page margins and information of that kind within de report? Is there any kind of association between printer...
1
2484
by: mikeyatsony | last post by:
Hi all... Is there a web for my ASP Web application tied to a SQL Server Express DB to print labels? I need a way to have reports printed from the user's browser. They wish to print labels for a mailing. Any thoughts would be great.
12
3529
by: Studiotyphoon | last post by:
Hi, I have report which I need to print 3 times, but would like to have the following headings Customer Copy - Print 1 Accounts Copy - Print 2 File Copy -Print 3 I created a macro to print the report three times, but do not know how
0
8392
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...
0
8823
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
8730
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
8503
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
8605
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...
1
6163
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
4151
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
4301
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2726
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

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.