Search results

I am printing a report Invoice from a form with a subform. When I enter the invoice details on the subform (Datasheet) it automatically enters a blank row which then in turn prints out on the invoice report. I have a comand button from the form to print the invoice. How can I tell the report...

Hi, I have a master form Order Entry and a sub form Order Entry Sub Form the sub form is a data sheet so that I can add several rows of the order of different products, rates etc. The subform is linked to the main form by invoice number and customer name. However when I go to print the order...

Hi, I am trying to create a query that if a certain field type is picked then it will return another field value as follows. I am creating a new field called Rate the value of which all depends on what shift type is added on the order:= If [Shift Type] = Days then the Rate = [Rate Days]...

I am trying to print a report called 'Invoice' from a form showing the order details. I have set up a command button on the form to print the invoice with the event procedure as follows: strDocName = "Invoice" DoCmd.OpenReport strDocName, acViewPreview, , "[Invoice...