Search results for query: *

I've created the following function, but it is falling over at the Docmd.TransferSpreadsheet line - I'm just not sure how to include the recordset in the command. Can someone advise where I'm going wrong? Code: Function fcast_output() Dim db As Database Dim rs As Recordset Set db = CurrentDb...

I've searched without success.... I have a report containing a sub-report which has a standard format, the main report has a report header saying "The following orders were shipped last week" and the detail section contains the order info. The sub-Report contains the header "The following...

Hope I can explain this properly...... I have a main form where I enter an order number, and this opens a sub-form filtered on this order number. For each item on the order, I need to print a report specific to that Item, and want to do this via a 'print reports' command button. The...

I am attempting to count the number of times we produce a product, and the average quantity in each production run. I have the detail by production date, but the issue I can't resolve is how to count production on consecutive days as 1 entry. This is to cover where we begin production late one...

I have a main form, where the users enter an order number. after hitting return, this opens a subform, filtered by the order number. The fields on the subform are either populated automatically from an underlying query, or manually input by the user. When all inputs are complete, a command...