Search results

  1. O

    Refer to calculated field on Subform from Main form

    Sorry, dB was too large!! Take two..........
  2. O

    Refer to calculated field on Subform from Main form

    Just to be clear I do understand that the code will only trigger on an on current event when the user moves to the record, this is how i need it to suit our procedures, thanks
  3. O

    Refer to calculated field on Subform from Main form

    Thanks guys, I have stripped the DB down, please find copy attached....! Fingers crossed someone can see what I am doing wrong, thanks again.
  4. O

    Refer to calculated field on Subform from Main form

    Ok, thanks for everybody's input. To try and simplfy things and identify the source of the issue I now have the following: Form: Purchase Orders Subform: Purchase Order Subform Text box in footer of subform: "SumItemsReceived" with Control Source of: =Sum([QuantityReceived]) Text box on main...
  5. O

    Refer to calculated field on Subform from Main form

    Thanks for this, that’s a great site. Had a read through overnight so hopefully with a bit of practice that should really help things. That said, all the debugging usually refers to when you encounter errors but in this case may code runs without any. All that is happening is that it...
  6. O

    Refer to calculated field on Subform from Main form

    Might sound crazy but I’ve never mastered stepping through code and when I tried an online VBA video in doing it it intimated you cant step through form class subs which I find difficult to believe. I’ve written tonnes of amateur code and just relied on trial and error!
  7. O

    Refer to calculated field on Subform from Main form

    No, all the control names are correct as I get no code errors at all. I deliberately tried changing a name to check it errored and it did proving all the names are correct?
  8. O

    Refer to calculated field on Subform from Main form

    Dear All, I think the lockdown is getting to me and given me brain freeze..... I have a cmd button on my main form "Purchase Orders" called tglRecieveAll. On the main form is a subform set in datasheet view called "Purchase Order Subform". On the subform footer is a calculated field called...
  9. O

    make the first letter uppercase

    Minty, its taken a while to get round to trying this but followed your advice and got it working, many thanks, appreciated.
  10. O

    Using Totals Query As Data source within main query

    Hi thanks for this. I use the Nz function widely so am familiar with this to remove a NULL but in this case I actually want a NULL but it seems the DCount still gives a 0 even when no records meet the expression criteria?
  11. O

    Using Totals Query As Data source within main query

    Thanks very much for your response, appreciated. I have opted for option 3 and created the following expression in an unbound text field just to tes the results. The expression works perfectly however it returns a 0 in the case of no records. Ideally I'd like to know if there was a case of NULL...
  12. O

    make the first letter uppercase

    Thanks Minty, I'll have a go with this later, appreciate your help.
  13. O

    Using Totals Query As Data source within main query

    Hi, I have a table "Suppliers" and a table "SuppliersApprovalDocs". Both a a relationship on the SuppliersID field. Within the SuppliersApprovalDocs table there is a date field [DocExpiryDate] and a chk field for [DocRenewalReceived]. If the DocExpiryDate field = <Date() and the...
  14. O

    make the first letter uppercase

    Yes you well be right, although I'm still not clear on the field code to call it and get it to work?
  15. O

    make the first letter uppercase

    Sorry for the late reply to your responses above. I found the following function code on the site and was hoping to use it on a text field to ensure correct text field formatting. I tried calling the function on a text field on the Key press action using the following which I also found o the...
  16. O

    Count iterations performed in SQL recordset loop

    Thanks for this another good idea! I have added the record count to the error hadndler MsgBox and also added it to the 'Success' message box although I had to move the position of this one from after the End With to before the .Close as that point the .RecordCount was not available once the rs...
  17. O

    make the first letter uppercase

    Hi, old post I know but like your code as below. I have added it to my DB as public function and called it on a text field as follows: Code Tags Added by UG Please use Code Tags when posting VBA Code...
  18. O

    Count iterations performed in SQL recordset loop

  19. O

    Count iterations performed in SQL recordset loop

    Wow, thanks so much for that. So interesting to see how you’ve managed to simplify the code, will be very helpful for other areas in my DB. Will try your input early eve tonight and feedback on results, thanks again.
  20. O

    Count iterations performed in SQL recordset loop

    Yer fair point you are right on that. Ignoring the Null values seems sensible and straight forward enough in the SQL which I can do. I’m fairly new to VBA bad learning fast so not heard of Errant link before but sounds interesting and like the idea of displaying the last successful file copy...
Back
Top Bottom