473,327 Members | 2,025 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,327 software developers and data experts.

Batch Printing in Access

I want to be able to batch print all records in a header table that have not yet been printed. This should be simple, but due to the format of the report, I cannot just print all records (the details linked to each heder record all appear on one report rather than on seperate reports).

I have a print flag in my header table to identify if a record has been printed or not. I can make a query to create a table of the header records not yet printed. Due to the nature of my report, I want to step through this table printing each record using the same report. That is, I want to start at the first record in the table, print the report, close the report, go to the next record, print the report, and so on until the end of the table.

I have tried many approaches with no success. Thanks in advance for any suggestions.

- Casey
Jun 11 '07 #1
1 3237
JConsulting
603 Expert 512MB
I want to be able to batch print all records in a header table that have not yet been printed. This should be simple, but due to the format of the report, I cannot just print all records (the details linked to each heder record all appear on one report rather than on seperate reports).

I have a print flag in my header table to identify if a record has been printed or not. I can make a query to create a table of the header records not yet printed. Due to the nature of my report, I want to step through this table printing each record using the same report. That is, I want to start at the first record in the table, print the report, close the report, go to the next record, print the report, and so on until the end of the table.

I have tried many approaches with no success. Thanks in advance for any suggestions.

- Casey

Hi Casey

Can you post the code you're using? Please use the tags.

This is fairly easy if your header table has an index (ID) number associated with each record.

Something like this inside your record loop

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport "yourreport", acViewPreview,,"ID=" & rs!ID
  2.  
J
Jun 12 '07 #2

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

Similar topics

0
by: nawwu | last post by:
I would like to know how to print HTML Pages in batch i.e without the user intervention, I want to setup all the printing parameters like file name and printer name thru the code. I tried it using...
4
by: Bill | last post by:
I need help closing a CMD window when it is executed from Access. 1) The batch file is called from Access. 2) Access closes, 3) the batch runs a copy of the access database (creating a backup)...
2
by: Ardie | last post by:
Hi, I'm currently working on a webapp that generates reports for the user and i was wondering if there was a way to do batch printing. I was playing around with the idea of sending the reports...
1
by: Mitchell Vincent | last post by:
I've had this trouble in every language I've tried for Windows. Apparently the problem is with the underlying controls or something.. When I loop through and use a hidden web gadget to load and...
1
by: Parasyke | last post by:
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...
3
by: Nixeh | last post by:
Hi guys, ive been using access on and off now for about 3 years but im currently working on a database for work. Ive got the database all sorted and is currently storing 1000records. Ive created a...
2
by: psbasha | last post by:
Hi, I have created a Executable ( Exe) of an Python application using Py2Exe.I have implemented for Batch or Interactive application run in the source code.But I able run the interactive...
0
by: jiafangsee | last post by:
Hi, I'm using Visual Studio 2005 and I have a web application where i generated some delivery order in crystal report then it's exported to pdf for viewing and printing. Now I need to develop...
22
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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

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.