Search results

  1. C

    Solved DSum quantities based on a text date box.

    Hopefully someone can assist 🙏 Trying to update and load today :D
  2. C

    Solved DSum quantities based on a text date box.

    I missed an equals sign. But now I am getting #Error and it is constantly flashing really fast
  3. C

    Solved DSum quantities based on a text date box.

    G'day mate, I get a #Name? error
  4. C

    Solved DSum quantities based on a text date box.

    Hello, I am trying to sum all of the sheets cut on a date which is picked on a form. Form: Query SQL: SELECT JobInfoT.JobID, JobInfoT.CarcassCut_Due, JobInfoT.CarcassCut_Date, JobInfoT.CC_Sheets FROM JobTypesT INNER JOIN JobInfoT ON JobTypesT.JobTypeID = JobInfoT.JobTypeID WHERE...
  5. C

    On click event and call click event not functioning.

    I did this: ElseIf ChkLaminateBtops = True And Len(Nz(Me.TxtBTop_Due)) = 0 Or ChkSolidSurfaceTops = True And Len(Nz(Me.TxtBTop_Due)) = 0 Or ChkBtopOther = True And Len(Nz(Me.TxtBTop_Due)) = 0 Then txtmessage = MsgBox("Enter Due date for Bench Top Order." & vbCrLf &...
  6. C

    On click event and call click event not functioning.

    thanks heaps guys... Quick one, Why would i still be getting asked to complete this date when I have a date in there? Private Sub LblSetOut_Complete_Click() Dim txtmessage As String txtmessage = "" ' Check Orders Due Dates If ChkBoardOrder = True And...
  7. C

    On click event and call click event not functioning.

    Cheers mate :)
  8. C

    On click event and call click event not functioning.

    So Good! You guys have made me very happy and taught me a lot. Thank you so much.. :D This is what I did, couple of examples: '------------------------------------------------------------ ' Options Visible if true '------------------------------------------------------------ Private Sub...
  9. C

    On click event and call click event not functioning.

    Ok, Thank you so much.. :D Ill get my head into this and report back. (y)
  10. C

    On click event and call click event not functioning.

    Ok, awesome, thank you. I'll start re-doing all my code. Do I do this for all of the on click events? then Call those events Load and Current? Like this? (Do I still need the else to set to invisible?) '------------------------------------------------------------ ' Options Visible if true...
  11. C

    On click event and call click event not functioning.

    I think you are onto something here. If I comment out all code for the visible on and off, only have one event on, so to be speak, the function works as it should. I know my code is horrible and repetitive. Is this the issue? How can I code this correctly to make it work? Or, what do I need to...
  12. C

    On click event and call click event not functioning.

    hmmm Ill go thru them.. thanks
  13. C

    On click event and call click event not functioning.

    Sorry mate "control" ? This is the properties for the form.
  14. C

    On click event and call click event not functioning.

    Yes
  15. C

    On click event and call click event not functioning.

    Thank you I have the call values in On Current and in On Load. Still have issues.
  16. C

    On click event and call click event not functioning.

    I'm finding a couple of these are not working now but some are. Does it matter that some fields are in a page on the form? Do I need to specify the form every time? or me. is adequate. Actually some records work and some don't as well. Its really random now.. :(
  17. C

    On click event and call click event not functioning.

    Thank you, The table value is set to true. However when I step thru the code the highlighted ChkAssembled states -1 is that true? thank you
  18. C

    On click event and call click event not functioning.

    G'day Mate, Yes I have the Call there too.
  19. C

    On click event and call click event not functioning.

    Hello, I have a form with an on click event that makes fields visible when checked. I am then calling the click event when the form loads, opens and current. The on click is working, however when i reopen the form the status of the job doesnt hold the changes even when the checkbox is true. I...
  20. C

    Solved Open a record in one of 2 forms based on the last character of a field

    G'Day mate, Sorry I missed that and didn't check the form. Thank you!!! That worked and all is good in the world again:) Thank you everyone!
Back
Top Bottom