Recent content by PMF1957

Thank you sir. I created the form and it worked great, It did not request the starting and ending numbers several times, thank you. However (isn't there always an "however"). The printed reports do not print the way I need them to. They are printing in the following manner: Workorder#1 - Copy1...

Thanks for responding. I can get the three copies by executing the following: From the on Click from the main page: DoCmd.OpenReport stDocName, acViewNormal, "Bulk Work Orders Filter", , , "Copy1" DoCmd.OpenReport stDocName, acViewNormal, "Bulk Work Orders Filter", , , "Copy2" DoCmd.OpenReport...

I'm Back....Sorry about this gang but I'm having trouble finding a solution for another report issue. I'm running Access 2010 and I have a query that extracts a range of Workorders that I can currently print out a single copy. What I need to be able to do is to print three copies of the report...

Thanks for putting me in the right direction and your time....

OK resolved this with some additional research and with the great help of pbaldy, thank you very much. I will lay out my solution below: From the form/buttion where the report is requested, on the ON CLICK [Event Procedure] i added the following: DoCmd.OpenReport stDocName, acViewNormal, "Work...

On this report I'm working on the process is as follows: a button on the switchboard fires off a query generated report and asks for the starting work order number and the ending work order number, then prints the work orders in that range. So I guess the answer to you question is no it is not...

Pbaldy....Hope you had a good weekend. I move the code to the load event. The report prints only one copy and nothinig in the footer.

I thought it would move the desired text to the desired location.

OK. I removed the OpenReport lines out of the load event. What I want to do now is the following: On the first copy of the report I want to print I need to put into the footer Text62 box "AFS Copy". On the second copy I want to print i need to put into the footer Text62 box "Shop Copy". On the...

The button is on the main Switch board. "Print WO's by WO range". It is used to reprint or print workorders in a supplied range. When clicked it drives a query asking for the starting then ending work order number. When those are supplied it prints/reprints the workorders in the range you...

I added to the load: Private Sub Report_Load() DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "1" DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "2" DoCmd.OpenReport "rptBulkWorkOrdersbyWorkOrderNumberRange", , , , , "3" End Sub Then added to...

pbaldy, Thank you for the reply. Yes to your question but mainly if the code I specified is good my main question then becomes where do I place it, in what sequence or process does it go...

Hey all, I could use a little help (maybe a lot of help). I'm a novice (more rookie) in access, but I have created several straight forward system so I have some idea of how this stuff works.... This is what I'm trying to do. I have an old access database (written with 2003 but running under...

Sorry to take so long to get back to you. Thanks for the reply. I'm going to give that a shot and see what happens. Just so you know I kinda found a work around for this. I placed a unbound button on the main form with instructions to click it then Press and Hold the Shift key then hit F9. It...

Tried that. The button on the switchboard executes a openform macro called "ETOForm" and I placed that same macro on the "on Click" process on a button on the form. When I click it nothing happens. Update: I can change it to execute any other query or report and it works. It will just not work...