Search results

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...

OK. I'll walk through the process. From my main switchboard I click on a button that executes a OpenForm macro that in turn opens up a query which ask to enter a like parameter "Enter serial Number". I enter the information I'm looking for and hit enter. This then opens to a form/subform...

I should have said "re-execute" the same form once I'm done entering data for a specific item into it. I would like to be able to re-execute the same form i'm in after saving the information instead of having to go back to the switchboard to process another record. The process is query driven to...

Excellent... Works just fine. Created reports showing where a piece of equipment is at any given point in time. Thank you... I have another question for you (i'm going to search for a answer also). Is there a way to execute a form via a button or command from a form?

plog...Thanks you have been a great help. It's been a long time since i played with this stuff. Rust is starting to come off the old noggin... I don't know of another way. Let me explain: The equipment table is a repository for the assets that the warehouse stores and records the movement of...

Agreed. I had the redundant info in the eto just to see what it would look like. I have since pulled it out. The ETO now only contains the fields associated with the movement of equipment (plus the Equipment ID). I need to leave the location field in the equipment table as this field will be...