January 18, 200719 yr Newbies I have a database that I use to print 2 sets of documents from 2 different databases by a part number. So you enter in the part number in a field click the button and bam you have both sets of paperwork for that part number on the printer! Well I wanted to add into the script the following, I have 2 sheets of paper I want to print out with those 2 sets of paperwork, however the number of sheets i want printed need to equal the number of records in one of the databases. So database #2 could have 20 records for that part number, I want it to print 20 of each sheet (the extra 2). Incase Im not clear or your confused heres a bit better explanation. We have 2 sets of paperwork here, one quality, one process, they work off a part number, to save time we created a database that printed from both databases at once instead of opening each one and printing that way. Well as a cost saving idea I thought it would be cool to have it print the other support documents with the 2 packets of paperwork. I scanned in both copies of the paperwork into layouts within the database. I got the script to work to print them by themselves with a click of the button but I cannot get them to print out with the packets. (( Id really perfer if it printed like this.. ((( Okay theres 10 quality records, I want 10 of each extra sheet to print with the quality/process records ))). Im struggling pretty bad with this one!
Create an account or sign in to comment