Recent content by morganpeet

I have tried everything and the subform is still adding an extra line of zeros into the original table and so printing out a blank on the report. Can somebody please help me?

Hi, I still haven't got rid of my extra line of zeros? Can anyone help?

Thanks for your reply. I would appreciate any help you could give me and any pointers as to where I am going wrong!!!

Thanks for having a look - this is a work in progress so some things aren't set up properly yet!

The form is a data entry form where i enter the invoice details. For every invoice I enter on the form it adds a blank row for each invoice no. I just deleted all the table info to start again and the very first invoice I entered it entered a blank row with 0 values.

Hope this works

I know this might sound really thick - but how do I upload screenshots? I pressed print screen but couldnt paste it in?

Sorry I didnt explain myself very well. I am printing a report based on Invoice detail table. The subfrom is automatically adding a blank row to the Invoice detail table so that is showing up on the report. Hope that makes sense!

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

Sorry I forgot to say that I am printing to a report - any idea?

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

Thanks so much - its easy when you know how!!!

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