473,789 Members | 2,806 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Printing reports from different trays without locking the db in design mode

Hi,
I have an invoice which is being printed on two different trays. This
is being done by some simple code in VB, and it works.

However, my report goes into design mode in order to change the
settings for the printer, and this locks the system for new users to
enter and a restart of the database is the only solution.

Is there a way to avoid putting the report into a design mode when
printing from 2 different trays, or is there another way of solving
this issue.

I use Access 2003.

THank you for your help

Eskil

Nov 13 '05 #1
1 1603
eskil wrote:
Hi,
I have an invoice which is being printed on two different trays. This
is being done by some simple code in VB, and it works.

However, my report goes into design mode in order to change the
settings for the printer, and this locks the system for new users to
enter and a restart of the database is the only solution.

Is there a way to avoid putting the report into a design mode when
printing from 2 different trays, or is there another way of solving
this issue.

I use Access 2003.

THank you for your help

Eskil


Make a copy of the report, and setup the copy to print to the second
tray. Then you should be able to programatically control when each
report gets printed.

Nov 13 '05 #2

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

Similar topics

1
3143
by: Abe | last post by:
Need some information regarding SQL Server locking. Requirement is to run SQL Statements for reports (read-only) that will not lock-out other people trying to update (write lock). For this, we tried the following to make the db connection not deny write locks (our report code will not have a read-only lock). ADODB.ConnectionObj.Mode =adModeShareDenyNone But this made our connection bumped whenever someone tried to update.
3
2467
by: Justin | last post by:
Does anyone know how to set this up in Access 2000? I need to be able to print packing slips to multiple trays on a single printer. (ie. two paper colors) Thanks.
1
2886
by: Xavier | last post by:
I love you all. i cannot print the same report to 2 diferent paper trays using ms access. i cannot print the same report to 2 different printers KB200546 gives a way to di it but it doesn't work with Access Runtime. What can i do ?
5
556
by: Ira S | last post by:
I use a DYMO labelwriter with my Access 97 database. I just purchased a new computer and in the report section under page setup/paper size, the new computer keeps changing the size automatically. I know something must be different on the machines. But what? I have checked everything ! Thanks, Ira
16
48888
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use a commercial program such as Adobe Acrobat and its associated API. The technique uses Ghostscript and Redirection Port Monitor - two free programs for creating PDF documents provided free by Russell Lang. The actual automation requires VBA...
0
1297
by: ALMA_J_III | last post by:
Hi all! Customer will use HP LaserJet 4200TN printer for printing of invoices. 3 different versions of invoice on different color of paper should be to print. HP LaserJet 4200TN have 3 paper source trays. Maybe some from you have experience in printing to different trays of this printer. Crystalreport Report object has PrintOptions class and the next papersource properties:...
2
2896
by: Jurjen de Groot | last post by:
I'm about to start a new ASP.NET application, this application will generate several types of documents (PDF HTML XML-DOC) wich have to be printed at the client-side... (probably on different printers A3 and A4 type) At this time I'm trying to figure out what would be the best way to accomplish this : 1. printing through HTML in a IE windows will result in page title & nr as header and URL + Date as footer, wich is far from acceptable....
0
252
by: matpublic | last post by:
Hi, I'm working in a networked printer environment and within my application I'm using reporting services to create several documents. These documents may have different paper sources (trays) on the output printers, and some are duplex and some simplex. However, I'd like to group the documents together to ensure when output to a printer they are all printed together.
3
2472
by: k2storm | last post by:
I'm having problems with Reports and I'm seeking some help, or advice on how to solve this problem. Any help will be much appriciated! It’s hard to explain but I will try to do my best: In my Database I have about 6 to 7 reports that show me all the data from different tables. When I open any Report in 'Print Preview' Mode everything looks fine and the Reports open just fine. But once in a while, for some strange reason and I don't know why,...
0
9666
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
10412
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
10200
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...
0
9986
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
9021
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...
0
6769
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
5422
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
5551
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3703
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.