Recent content by andymartin3186

  1. A

    Solved Sendobject PDF, cc field sometimes empty gives error

    Thank you for helping
  2. A

    Solved Sendobject PDF, cc field sometimes empty gives error

    Update, Changed the QuotationEmailCC variable type to Variant and it works.
  3. A

    Solved Sendobject PDF, cc field sometimes empty gives error

    Ive tried using an Nz function and splitting the results into 2 different actions, one with a CC argument and one without. Still fails. I'm doing something stupid what is it? Private Sub EmailQuotationBtn_Click() Dim CustomerName As String Dim CustomerEmail As String Dim...
  4. A

    Solved Sendobject PDF, cc field sometimes empty gives error

    Hi, I have a button on my job form which emails a delivery note to the particular customer contact email address on the job. I also have in my customers table a PODEmail field where I can add other people in as the CC section of the delivery note email. These are entered and seperated by a ...
  5. A

    Solved Dymo Label printing issue

    This worked. Thanks I just created a blank report rather than using the wizard. I still had to rotate everything 90 on, but that makes sense as to how it prints. Thank you!
  6. A

    Solved Dymo Label printing issue

    Hi, I've created a report to print a single dymo label to my 550. The labels I'm using are 2112283 25mm high x 54mm wide and when using the dymo software they come out of the printer narrow edge first with the text 90 degrees on so the label is landscape when viewed. I've attached a photo of one...
  7. A

    Solved Check box on continuous form - affects all rows

    Thanks, this worked great. The only bit that got me was the setfocus to "GF" line of code. Turns out "GF" was a text box but was 0cm x 0cm so couldn't see it anywhere but it wasn't hidden. I added one and it worked great.
  8. A

    Solved Check box on continuous form - affects all rows

    I believe the issue is because its unbound. Do I need to add a field to the job table and bind the control to this? I didn't really want to store this in a table as its just temporary one off when running the report
  9. A

    Solved Check box on continuous form - affects all rows

    Hi, I have a form where I can choose a customer, and then a subform displays all jobs currently set to "For Delivery" I have added a control on the subform which is an unbound yes/no check box. A query then looks at this check box status to decide whether to include this item on the delivery...
  10. A

    Label not showing on subform if value is 0

    Whayhey this worked!! Its also showing 0 now when there is nothing Thank you!!!
  11. A

    Label not showing on subform if value is 0

    Yes I currently have one result for testing purposes, and OrderID is the first column
  12. A

    Label not showing on subform if value is 0

    No, its not on the main form as its a dumb form used as a main menu. This could be the issue. The TotalOpenPO query is basically returning all orders that "received" = False. The count is to count the number of lines in the query, Am I doing this the wrong way? Is there a better way?
  13. A

    Label not showing on subform if value is 0

    Sorry I was stupidly mixing it up with thinking it was a text box! I've created a label on the main menu and put this in the main menu on load Me.LblOpenOrder.Caption = DCount("1", "TotalOpenPOQuery", "[OrderID] = " & Nz([OrderID], 0)) It errors with 2465 can't find |1 in your expression
  14. A

    Label not showing on subform if value is 0

    I wasn't sure how to do this as its on the main menu and there is no control source. Each subform has an associated control source as the related query If I create a label on my main menu with control source =Count([ComponentOrderQuery]![OrderID]) It shows Error
  15. A

    Label not showing on subform if value is 0

    Sorry no joy with this
See more
Back
Top Bottom