473,569 Members | 2,701 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

batch printing of spec sheets

Thanks for any help.. I currently have a database with about 100
products with picture links in an external folder. I have a form from
which I can successfully display a product, its specifications, and
print a sheet with the picture and the relative data. I'm trying to
write some code to allow me to bring up the products and add them to a
batch of about 20 different product sheets to print at one time, rather
than the user having to hit the print button 20 times after, that is
print a product sheet, then bring up another and hit print again, etc.
I need to accumulate a batch of sheets to print. Is there a way to do
this.. maybe code to place each product and its picture-filepath into a
temporary table then print all found in the temporary table? Thanks!
Dav

Dec 20 '06 #1
1 1588

Parasyke wrote:
Thanks for any help.. I currently have a database with about 100
products with picture links in an external folder. I have a form from
which I can successfully display a product, its specifications, and
print a sheet with the picture and the relative data. I'm trying to
write some code to allow me to bring up the products and add them to a
batch of about 20 different product sheets to print at one time, rather
than the user having to hit the print button 20 times after, that is
print a product sheet, then bring up another and hit print again, etc.
I need to accumulate a batch of sheets to print. Is there a way to do
this.. maybe code to place each product and its picture-filepath into a
temporary table then print all found in the temporary table? Thanks!
Dav
+++++++++++++++ +++
I have in the past created a print table (created on startup with all
the products ID's in it and an empty flag field to tick off for
printing (code this to alternate between on and off in an on-click
procedure), that way you can print sheets where the print this flag is
set to true by basing your report on a query that includes your data
joined on ProductID and where the print flag is set to on!
+++++++++++++++ +++

Dec 20 '06 #2

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

Similar topics

16
4179
by: Geoff Cox | last post by:
Hello, I publish some web pages using large fonts and would like to give the user the opportunity to print the pages using a smaller font. I believe that this is possible using different style sheets? I am not clear how the user would select the different .css files? Seems to be easier than having duplicate html files ...
17
2376
by: Geoff Cox | last post by:
Hello, I am trying to have 1. web pages in large font 2. web pages with smaller font for printing I am using <link rel="stylesheet" media="print" type="text/css"
5
1807
by: Paul | last post by:
I've bought two books on CSS, and found they're no good. Now I'm reading "Cascading Style Sheets, level 2 revision 1 CSS 2.1 Specification" , but it's tough going. I have lots of questions about parts in that spec. Does anyone know who can answer them? Is there maybe an "Annotated CSS 2.1 Spec" ? That is, one with extra explanation added...
5
2205
by: Mark Preston | last post by:
Admission first - I don't actually have a problem here but have noticed that a lot of people have been asking similar questions and getting very varied answers. What I've done is to sort of "compile the questions" into a theoretical problem to see what people think should be done to solve it. Maybe it will be a worthwhile discussion, but...
2
2991
by: DBQueen | last post by:
I have a database which will be printing out labels for SMALL test tubes (1/4" high). We have yet to find a reasonably-priced printer (labelwriter) which can effectively print this on ROLLS of labels....due to slippage, soon you have the printout missing the label. So we are thinking that we have to use sheets of labels. HOWEVER, one job...
7
1969
by: madhu2845 | last post by:
I want to know if any style or tag is available to avoid printing footer on a web page. I know that we can have two style sheets, one for print media and other for screen and in the stylesheet for print media, we can provide a style {display:none} to the footer to avoid it getting printed. What is the best way to achieve this?
8
12759
by: CJM | last post by:
What is the best way to force a page break when printing from a browser? A page in my application generates a series of tables which are usually less than will fit on a page of A4. Ideally I want to introduce a page break between each table when printing. I'm not sure what options I have available. I know there is some support in CSS but...
2
6020
by: Rodney Dunning | last post by:
Forgive me if this is a stupid question. I have a course syllabus located at http://www.longwood.edu/staff/dunningrb/teaching/easc101f06/easc101f06_syllabus.html. I use a <divcontainer for the main content of the page. When I print the page, or select Print Preview, I get only a single sheet, even the though the content should run to...
22
8937
Missionary
by: Missionary | last post by:
I need to batch print reports. I've looked at past posts about batch printing, but I don't know visual basic, so I'll need some coaching. I have a report based on a parameter query. I have it set to take the parameter value from a form that I use to preview and print reports. I have to repeatedly print that report using a different value...
0
7697
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...
1
7672
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...
0
7968
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...
1
5512
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...
0
3653
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...
0
3640
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2113
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
1
1212
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.