Search results for query: *

PHV - Many thanks, means I'll need to create a few queries to do what I want! Peter

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

Thanks REMOU, but can you tell me how I handle things if it's not the sub-report that has no data? Thanks

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

sorry - should have said this is an Access97 database

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

Randy, I've now managed to get a solution for my problem. Thanks very much for taking the time to look at my issue, and I've no doubt you will probably have to help me again in the future. Thanks Peter

Randy, It's based on the production date - consecutive days should be counted as 1 including weekends (ie start on a Friday, finish on a Monday....

No, I meant started production on a Friday and finished on a Monday - we work a normal Mon -Fri week and produce every day....

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

AceMan1, The 'ShipToNo' is a code specific to a certain customer, and is auto populated when an OrderNo for this customer is entered in the main form. The User needs to overwrite the corresponding ShipTo Address for each order, hence having 2 controls for the ShipTo Address (ShipTo and...

TheAceMan1, Thanks - you may have partly answered the question, as I thought a subform was treated as a separate form! I should probably be driven by the After Update on the main form. When the subform opens (having been filtered on the Orderno field) if the 'ShipToNo' = xxxxxx, then make the...

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